Best answer

Can't Update Google Sheet Rows

  • 8 July 2020
  • 2 replies
  • 394 views

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)

icon

Best answer by jesse 18 February 2022, 14:18

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +12

Hi there @EchoAutomation! Without seeing your Zap, it’s tricky to know what the issue is, as there could be a few things that would give you the error message that you’re seeing. 

 

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!

Userlevel 7
Badge +9

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