You may see this error in your Google Sheets action, you may see an error that says “There was an error writing to your Google sheet.”
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.
You must disable protected sheets and ranges in your Sheet.
Enable Editor permissions in the connected Google Sheets account.
If you're using a Sheet that was shared with you, make sure you have Editor permission.
If the name of your spreadsheet or worksheet has changed, reselect both in the Zap editor.