Zapier Google Sheets Integration Issue After Adding, Deleting Columns and Changing Sheet Name

Hi @Pentaneon 

Good question.

Try remapping the entire step from selecting the spreadsheet, worksheet, then mapping the variables to fields.

The Google Sheets trigger on my Zap stopped working

If your Google Sheets trigger stops working suddenly, first check if you’ve accidentally inserted a blank row anywhere in the spreadsheet. Zapier interprets a blank row as the end of the spreadsheet and may have trouble finding any new rows below it.

In addition to this, making the following changes to your spreadsheet while the Zap is turned on can cause errors:

• Deleting existing rows or columns.
• Adding rows anywhere other than to the bottom of your sheet.
• Resorting the sheet.
• Renaming/adding/rearranging columns.
• Renaming the sheet.
• Filtering the sheet.

If you need to make any of those changes to your Google Sheet, turn your Zap off while you work on the spreadsheet, and then turn it back on again.

Thank you for your suggestions.

I've checked, and there are no empty rows in my spreadsheet. I also tried deleting the Zap and remapping everything from scratch, but the issue still persists. It seems that the problem isn't related to blank rows or a mapping error. I'm still encountering the same error message even after taking these steps. Any further guidance or suggestions would be greatly appreciated."

 

@Pentaneon 

Please post detailed screenshots with how your GSheet Zap step is configured.

The error indicates the worksheet is named DATABASE, but in your screenshot it says DB.

The error indicates it was trying to write to column Q, which may be outside the configured range.

Thanks for your reply:

CURRENT SHEET VERSION:
 

2. Lookup Spreadsheet Row in Google Sheets
 

3. Update Spreadsheet Row in Google Sheets