I have tried several different ways with different Zap apps and I can NOT get a Google Sheet row to update when an email is added. I want a sheet row to get updated when the email field from the initiating app is updated. I keep getting “There was an error writing to your Google sheet.” I use a ‘Lookup’ to make sure I can find the row that has been updated and it works great - but when I go to update the row - I get that error. I tried with multiple trigger apps and get the same result. HELP!!! (please)
Best answer
Can't Update Google Sheet Rows
Best answer by jesseBest answer by jesse
Hey there!
I am going to post this solution from our help documentation incase it’s helpful for others running into the same error message:
Causes
This can occur if:
- The Sheet name or tab (worksheet) name has changed since it was initially selected in the Zap editor.
- The Google Sheet has protected sheets or ranges.
- The connected Google Sheet account for the app does not have proper permissions, for example, it has read only permission.
How to fix it
- Remove any sheet or range protections. You must disable protected sheets and ranges in your Sheet.
- Enable Editor permissions in the connected Google Sheets account. If you're using a Sheet that was shared with you, make sure you have Editor permission.
- Reselect your spreadsheet and worksheet. If the name of your spreadsheet or worksheet has changed, reselect both in the Zap editor.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Staff
- 3731 replies
Hi there
In this case, I think that you’ll get the best help if I pass you onto the Support Team as they can take a closer look with you. I’ve passed your post onto them and someone from the team will be in touch via email as soon as possible.
Thanks!
+9- Architect
- 1348 replies
- Answer
Hey there!
I am going to post this solution from our help documentation incase it’s helpful for others running into the same error message:
Causes
This can occur if:
- The Sheet name or tab (worksheet) name has changed since it was initially selected in the Zap editor.
- The Google Sheet has protected sheets or ranges.
- The connected Google Sheet account for the app does not have proper permissions, for example, it has read only permission.
How to fix it
- Remove any sheet or range protections. You must disable protected sheets and ranges in your Sheet.
- Enable Editor permissions in the connected Google Sheets account. If you're using a Sheet that was shared with you, make sure you have Editor permission.
- Reselect your spreadsheet and worksheet. If the name of your spreadsheet or worksheet has changed, reselect both in the Zap editor.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.