The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success

Help w/ Google Sheets

Remove ads while supporting the Unscripted philosophy...become an INSIDER.

sonny_1080

Making friends and solving problems!
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 30, 2019
338
567
241
28
Los Angeles, CA
I'm trying to build a list on Google Sheets with some very specific protections, permissions, and automations. I'm not even sure Google Sheets is capable of doing everything I'm trying to do. Anyway, if there's a Google Sheets expert on here, I'd love to ask you some questions.

The first question I have is: is it possible to have an entire sheet protected, and then when someone wants to add to a column, they have to request permission -> but requesting permission brings them to a list of questions, that when submitted, I can approve or disprove. If approved, they get access to add to that one column.

I know that sounds a bit convoluted, but I'd appreciate any help.
 

Don't like ads? Remove them while supporting the forum. Subscribe.

Andy Black

Dad, Husband, Inbound Marketeer
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,624
46,596
4,306
Ireland
I'm trying to build a list on Google Sheets with some very specific protections, permissions, and automations. I'm not even sure Google Sheets is capable of doing everything I'm trying to do. Anyway, if there's a Google Sheets expert on here, I'd love to ask you some questions.

The first question I have is: is it possible to have an entire sheet protected, and then when someone wants to add to a column, they have to request permission -> but requesting permission brings them to a list of questions, that when submitted, I can approve or disprove. If approved, they get access to add to that one column.

I know that sounds a bit convoluted, but I'd appreciate any help.
What about a Google Form that adds new entries to a Google Sheet? I can’t visualise what you’re trying to do. Maybe new entries to that Google Sheet are eyeballed by you and then added by you to the master document?
 

maverick

Aspice, officio fungeris sine spe honoris ampliori
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 26, 2012
471
1,141
369
Create a project on Upwork. Many skilled google sheets people there that could solve this in a few hours.
 

sonny_1080

Making friends and solving problems!
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 30, 2019
338
567
241
28
Los Angeles, CA
What about a Google Form that adds new entries to a Google Sheet? I can’t visualise what you’re trying to do. Maybe new entries to that Google Sheet are eyeballed by you and then added by you to the master document?
I think this can work. I’ll keep you updated!
 

sonny_1080

Making friends and solving problems!
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 30, 2019
338
567
241
28
Los Angeles, CA
What volume of data are you dealing with? How frequently will the sheet be updated?
Not enough data for Hevo. I checked that link out. I'm just creating a list of user-generated content that I can monitor by making sure edits are protected unless granted permission.
 

sonny_1080

Making friends and solving problems!
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 30, 2019
338
567
241
28
Los Angeles, CA
@Andy Black

My audience wants to call it sonnyslist. They made a #sonnyslist.

I really don't like that lol.
 

Andy Black

Dad, Husband, Inbound Marketeer
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,624
46,596
4,306
Ireland
@Andy Black

My audience wants to call it sonnyslist. They made a #sonnyslist.

I really don't like that lol.
You can say thanks and name it something else. They’re people who know you. Maybe it won’t work for people who don’t know you. Saying that, it worked for a fella called Craig.
 

sonny_1080

Making friends and solving problems!
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 30, 2019
338
567
241
28
Los Angeles, CA
You can say thanks and name it something else. They’re people who know you. Maybe it won’t work for people who don’t know you. Saying that, it worked for a fella called Craig.
And angie lol
 

sonny_1080

Making friends and solving problems!
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Speedway Pass
Oct 30, 2019
338
567
241
28
Los Angeles, CA

Sponsored Offers

  • Sticky
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2020
Yeah, your youtube channel is incredible and all the videos I have seen so far are really great...
  • Sticky
FEATURED! Introducing... WEALTH EXPO$ED, A Short Story By MJ DeMarco
Finally! I just launched a short story on Kindle (FREE if you have Kindle Unlimited)! After...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
I planned to make a separate post for this video but it is useful here as well for anyone...
  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
Last promo of the year.. Get the training you need now or miss it. Promo Code: FINALHOUR...
  • Sticky
MARKETPLACE Kill Bigger Incubator
UPDATED POST: Hey Guys! I wanted to give a quick update on what this program has become. In...
  • Sticky
MARKETPLACE Grow Your Business With a Book (An Unorthodox Marketing Strategy That Built One of the Largest...
Are you looking for a new, lesser-known but potentially very lucrative source of leads to your...



Forum Sponsor

sponsor

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom