Help

Google Sheets error: “There was an error writing to your Google sheet.”

Last updated:

Troubleshooting Tip: The issue can occur if the Google Sheet has protected sheets or ranges AND if the connected Google Sheet account for the app does NOT have proper permissions." ie read only.

Symptoms

After attempting to test a Google Sheets action, you may see an error that says “There was an error writing to your Google sheet.”

Causes

Zapier will show this error if something about your Google Sheet changed after you selected it initially. For example, if the name of the spreadsheet or a tab (worksheet) of the spreadsheet changed. Or can occur if the Google Sheet has protected sheets or ranges and if the connected Google Sheet account for the app does not have proper permissions i.e. read only.

How to fix it

  1. Check your Google Sheet doesn't have protected sheets or ranges, as well as restricted permission for the connected Google Sheet account used in the Zap.
  2. Edit your Google Sheets action
  3. Open the Spreadsheet field to force Zapier to get the latest names of your spreadsheets and re-select the spreadsheet you want to use.
  4. Open the Worksheet field to get the latest names of the tabs of the selected spreadsheet and re-select the worksheet you want to use.
  5. Re-test your action
Example

In this example, the tab we wanted was renamed from Inventory to Produce:

Opening the Worksheet field to select the new worksheet name


Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community