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.

Hi,
I’m trying to copy the worksheet of new files added to a specific folder in Google drive.
 
For the action of copying to take place I need to define the worksheet name, which I don’t have, so I added the find worksheet action and have added the dynamic fields from the New file in folder, yet I keep on getting error that the worksheet is not found. 
 

 

Is there a way to make the action work with dynamic fields? or an alternative solution?

Thanks! 

Hi @Wael 

Good question.

Perhaps the “(2)” is causing the issue?

Can you confirm with screenshots that the GSheet you are trying to use has a Worksheet tab named exactly as shown?

 

Hi @Wael 

The New File trigger would return the title of the file. So, if you’ve uploaded a new spreadsheet it would return the title of the spreadsheet. Not the individual worksheets in that spreadsheet. 

If it helps, generally the default worksheet id for a spreadsheet is 0 (only true for the first worksheet on a google sheet)

Hey @Troy Tessalone  


Thanks to your view, I noticed that I using the incorrect title that refers to the worksheet name and not the file. Here below the update version of the Zap.
 

 

 

Hi @GetUWired 

Thanks for the info, unfortunately, the file is an excel (csv) conversation to google sheets when uploaded to the drive and I think that is the reason your solution didn’t work. I saw a previous conversation with your solution and had already tried it. 
 

Cheers!

 

Hi @Wael, our Transfer feature may help you accomplish your end goal. Let me know if I’m on the right track with this! 

Terms & Conditions