Can anyone help me figure out how to fix this issue? Attached are the screenshots for reference. Thanks!
Answer
Google Sheets “There was an error writing to your Google sheet. Unable to parse range” error
Best answer by SamB
It looks as though
- The spreadsheet or worksheet name changed since it was initially selected: Try refreshing the fields and reselecting the spreadsheet and worksheet.
- The selected worksheet contains frozen/hidden/protected columns or rows: Try unfreezing/unhiding/unprotecting those columns/rows in the selected worksheet.
- The connected Google Sheet account has insufficient permissions (read-only): Assign editor permissions and reconnect the Google Sheets account to ensure we’re using the updated permissions for the account.
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.”
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 Orchestrator & Solution Partner
Hi
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
+9- Zapier Solution Partner
Hi
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.
+11- Community Manager
Hey
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! :)
Hi
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?
+11- Community Manager
Great minds think alike,
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.
+14- Zapier Orchestrator & Solution Partner
FYI: Hidden columns and protected columns can cause issues as well.
Hey there,
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!
Mitch
+11- Community Manager
- Answer
It looks as though
- The spreadsheet or worksheet name changed since it was initially selected: Try refreshing the fields and reselecting the spreadsheet and worksheet.
- The selected worksheet contains frozen/hidden/protected columns or rows: Try unfreezing/unhiding/unprotecting those columns/rows in the selected worksheet.
- The connected Google Sheet account has insufficient permissions (read-only): Assign editor permissions and reconnect the Google Sheets account to ensure we’re using the updated permissions for the account.
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.”
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.