Zap loses connection to Google worksheet after the file is updated (replaced): "Could not find the selected worksheet" error

Question

I have a zap that downloads a csv (via EasyFTP), uploads it to Google Drive, downloads using Get Many Spreadsheet Rows, formats a few things and then populates a Zapier table.

This works great the first time but after that it fails.

The zap stops at the Google Sheets step (Get Many Spreadsheet Rows).

When the csv is uploaded to Google Drive it is set to replace the existing file of the same name. Even though it has the same file name, after it’s replaced the zap can’t locate it - to be more precise, it can find the spreadsheet but not the worksheet.

Can anyone suggest a solution?

Screen shot below…

Troy Tessalone · Answer

Hi ​@RyanForsythe1979Issue with the worksheet is because each Spreadsheet worksheet has unique IDs, except for the default worksheet in a spreadsheet which has ID 0.e.g. Spreadsheet A has Worksheet X with ID 123Then you replace Spreadsheet A, which in turn replaces Worksheet X with Worksheet Y, which has a different IDTry adding this Zap step: GSheets - Find WorksheetIf the replaced Spreadsheet has the same Worksheet names, then you can find the new Worksheet by Title to get the Worksheet ID to map to the GSheet step for Get Many Rows.

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded