About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.
Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.
Have a question? Let's get you an answer!
Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.
All of our best learning resources can be found here.
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.
Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.
Check out what is new and upcoming with Zapier with our regular product updates.
Early Access Program
Want to join Early Access? Learn more here.
Look as good as Zapier makes you feel with our new swag storefront.
Can anyone help me figure out how to fix this issue? Attached are the screenshots for reference. Thanks!
Best answer by SamB 22 March 2022, 12:32
It looks as though @Podcast Elevator was able to get past that error by refreshing the fields in the step and reselecting the spreadsheet and worksheet. This may not fix the issue for all cases though so I wanted to follow up here to summarize all the possible causes and solutions for anyone that’s having similar issues:
We also have a guide on how to fix this sort of “There was an error writing to your Google sheet” error here: Google Sheets error: “There was an error writing to your Google sheet.”
I had this exact same issue, I have a lot of experience with Zapier but still couldn’t figure it out!
I deleted the entire step and re-created it. That seemed to work!
FYI: Hidden columns and protected columns can cause issues as well.
Great minds think alike, @Podcast Elevator! ;)Hmm, this is very odd indeed. After you reselected the spreadsheet and worksheet did the name on the error message then match the name correctly, or were were they still different? If you could send over a screenshot to confirm this so we can see the latest error that would be super helpful.Also, are there any frozen columns or rows on the Google Sheet? If I remember correctly, that can sometimes cause trouble with updating rows.
Hi @SamB, thanks!
That's exactly what I thought as well when I saw the error message, but I already tried doing what you suggested and still come up with the same error message. Is there any other workaround on this?
Hey @Podcast Elevator, welcome to the Community! From the look of those screenshots it seems as though either the Spreadsheet or Worksheet name may have changed recently as it doesn’t match the name of where Zap is attempting to add the row to:Can you try reselecting the Spreadsheet and Worksheet in the Zap and then retest to see if that then allows you to create the test row in Google Sheets? Hopefully that’ll do the trick! :)
I had changed the linked Gmail account. Still didn’t work.
Hi @Podcast Elevator
Can you share another screenshot showing how you configured that step? It looks like either an issue with your connection or configuration, you may try reconnecting your account or using a different gmail/google account.
Please post screenshots with how your Zap step is configured, thanks.
Also, check out the available help articles: https://zapier.com/apps/google-sheets/help
My name is Lisa Orr and I’m a product manager at Zapier. We recently launched App Extensions a new tool that lets you build a custom action in the Editor.
We’re looking for users to join the App Extensions beta program, so if you want to learn more about building custom actions that fit exactly what you need, let’s chat.
Schedule time with me
I want to hear from you!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.