Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

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

  • October 23, 2025
  • 4 replies
  • 26 views
R
Forum|alt.badge.img+1

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…

 

Best answer by Troy Tessalone

Hi ​@RyanForsythe1979 

Issue 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 123

Then you replace Spreadsheet A, which in turn replaces Worksheet X with Worksheet Y, which has a different ID

 

Try adding this Zap step: GSheets - Find Worksheet

If 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.

 

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34066 replies
  • Answer
  • October 23, 2025

Hi ​@RyanForsythe1979 

Issue 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 123

Then you replace Spreadsheet A, which in turn replaces Worksheet X with Worksheet Y, which has a different ID

 

Try adding this Zap step: GSheets - Find Worksheet

If 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.

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9721 replies
  • October 29, 2025

Hey there ​@RyanForsythe1979 👋

How did you get on with that Find Worksheet action Troy suggested? Did it help get the correct worksheet selected and fix that error?

Let us know how it went. Happy to lend a lend if you’re still stuck. 🙂

R
Forum|alt.badge.img+1
  • RyanForsythe1979Beginner
  • Author
  • Beginner
  • 13 replies
  • November 6, 2025

Hi ​@Troy Tessalone, that suggestion worked for me.

Much appreciated, thank you!

Ryan

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9721 replies
  • November 6, 2025

Yay! 🎉 I’m so pleased it did the trick ​@RyanForsythe1979. Thanks for popping back in to confirm that. And thank you ​@Troy Tessalone for helping out here!! 🙌

Feel free to reach back out if you need anything else. In the meantime, happy Zapping! 😁⚡ 


Terms & ConditionsAccessibility statement