About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

Move a spreadsheet I just created into a folder I just created

  • 24 August 2023
  • 5 replies
  • 137 views
Colin Kettler

I feel like this should be simple but I don’t know what’s going wrong. 

 

I’m creating a deal in an app called Pipedrive. 

My first task was to create a new google drive folder when the new deal was created. 

The second task is to create a google sheet when the new deal is created. 

I would like to move the newly created spreadsheet to the newly created google drive folder.

Zapier prompts me to put in a search task so I did. 

The google drive search task test had no problem finding the newly created google sheet, but then when I go to create a new task to move the “found” google sheet, it says that it can’t find the sheet with the name given.

Here’s the Google Sheet that it should be able to move...

 

 

Any help here would be much appreciated.

 

Thanks!

icon

Best answer by ken.a 24 August 2023, 13:07

View original

5 replies

ken.a
Userlevel 7
Badge +6

Hi there @Colin Kettler,

Welcome to the Community! 🎉

Looking at the screenshot, it looks like you might need to tweak your field mappings in step 5 a little bit.

The “File” and “Folder” fields looks for the ID. Could you please try remapping those fields with the ID instead?

Here’s what it’ll look like:

  • Grab the File ID from the “Find a File” step:
    5ef005052f4879399712858f9a0695f4.png
    (view larger)
  • Map the File ID to the “File” field in your “Move File” step.
  • Grab the Folder ID from the “Create Folder” step:
    43d4c70b3e28a6f32d4df0c50679284f.png
    (view larger)
  • Then, map the Folder ID to the “Folder” field in your “Move File” step.

Could you please give that a try, and let me know how it goes!

jayeshkumarbhatia
Userlevel 6
Badge +6

Hi @Colin Kettler , 

 

In Find a file action, you have to search via file id and not file name. You will get file id from Action 2.

 

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @Colin Kettler 

In the Zap for the GDrive Move File step...

For the File field, map the ID from the GSheet Step 3.

For the Folder field, map the ID from the GDrive Step 2.

You should not need Step 4.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Colin Kettler

Thank you all! 

 

Changing the fields to look for the ID instead of the file name worked great! 

 

Would you recommend using the file ID for the “Find file in Google Drive” as well?

Troy Tessalone
Userlevel 7
Badge +14

@Colin Kettler 

Zap action: GDrive - Find a File

This searches for a specific file by name.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions