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.
After attempting to test a Google Sheets action, you may see an error that says “There was an error writing to your Google sheet.”
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.
- 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.
- Edit your Google Sheets action
- Open the Spreadsheet field to force Zapier to get the latest names of your spreadsheets and re-select the spreadsheet you want to use.
- 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.
- Re-test your action