Is it possible to give An automation Editing rights within a protected Xcel or Google sheets?
I am trying to make it so when one of my orders moves to a complete or shipping status. that it populates
Task name and Address to a protected document. My account with google has editing rights to certain cells which are the ones I am trying to automate input too. But it throws an error stating its needs editing rights.
Best answer
Give Zapier automation editing rights to Google Sheets
Best answer by Troy TessaloneBest answer by Troy Tessalone
Sheet itself has to be unprotected.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31173 replies
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.
It doesnt give me a 400 bad request error. Because I was testing it out. Mutliple people use the google sheet that has formulas that need to be protected, from accidental deletion. So are you saying theres no other way around it. Its simply i have to unprotect the sheet?
+14- Zapier Expert
- 31173 replies
I’ve seen Zap errors when the tab and rows/columns/cells are protected.
So is this because I dont have full editing rights or is it the Sheet itself has to be unprotected?
okay thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.