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
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.
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
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.
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
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
can i run the zap manually, instead of auto update, this way i could stop the protection when i need to update the sheet
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.