is there a way to auto populate data in a protected excel/google sheet. i don’t want anybody to alter the data that zapier populates into assigned columns
How do I auto-populate data in a protected Excel/Google Sheet without allowing edits?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24207 replies
-
24 July 2023
Hi
Good question.
400 bad request
If you see this error in a Zap, check if your worksheet is locked or protected.
This prevents Zapier from being able to write to the sheet, so you'll need to unlock it.
- Beginner
- 3 replies
-
24 July 2023
Is there some way to work in a protected sheet, i need it for CRM and my agents will be adding other data in the same sheet manually, and i don’t want them to accidentally alter the zapier data
Userlevel 7
+14
- Certified Zapier Expert
- 24207 replies
-
24 July 2023
It will result in an error if trying to use a locked GSheet worksheet.
400 bad request
If you see this error in a Zap, check if your worksheet is locked or protected.
This prevents Zapier from being able to write to the sheet, so you'll need to unlock it.
- Beginner
- 3 replies
-
24 July 2023
thank you, doesn’t solve my problem though, there should be a way we could give restricted access to zapier, it works in specified columns anyway
Userlevel 7
+14
- Certified Zapier Expert
- 24207 replies
-
24 July 2023
If you have a Zapier paid plan, you can submit feedback and feature requests via a ticket to Zapier Support to be logged: https://zapier.com/app/get-help
- Beginner
- 3 replies
-
24 July 2023
can i run the zap manually, instead of auto update, this way i could stop the protection when i need to update the sheet
Userlevel 7
+14
- Certified Zapier Expert
- 24207 replies
-
24 July 2023
Look into using Transfers by Zapier: https://zapier.com/app/transfers
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.