Skip to main content
Best answer

Give Zapier automation editing rights to Google Sheets


EricTWG

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 by Troy Tessalone

@EricTWG

Sheet itself has to be unprotected.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @EricTWG 

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.


EricTWG
  • Author
  • New
  • 3 replies
  • March 16, 2023

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? 


Troy Tessalone
Forum|alt.badge.img+14

@EricTWG

I’ve seen Zap errors when the tab and rows/columns/cells are protected.


EricTWG
  • Author
  • New
  • 3 replies
  • March 16, 2023

So is this because I dont have full editing rights or is it the Sheet itself has to be unprotected?


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31147 replies
  • Answer
  • March 16, 2023

@EricTWG

Sheet itself has to be unprotected.


EricTWG
  • Author
  • New
  • 3 replies
  • March 16, 2023

okay thank you!