Skip to main content

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!

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!

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.

 

 

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.

 

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?

@Colin Kettler 

Zap action: GDrive - Find a File

This searches for a specific file by name.

 

Hello everyone, I’ facing the same problem now :(

But I don’t get how I can use the ID.

When I create a new Spreadsheet row in SpreadsheetA, Zapier cretaes a new Google Drive Folder and makes a copy of SpreadsheetB. And now I want to move SpreadsheetB into die new created folder. But I set up the funnel, I am not able to choose a Spreadsheet ID, because the Spreadsheet doesn’t exist when I create the Zap.

I know how the Spreadsheet will be named, but I don’t know which ID it will get when it will be created.

 

Do I miss something?

I appreciate any help.

Maybe it is not even possible, but I tried it for days now ad thought I give it a try and aks :)

 

Best,

Britta

@Britta 

For the File field, use the ...] button at the right of the field input to switch to ‘Custom’ mode, then use the +] button to dynamically map the File ID from a previous Zap step.

Help link for configuring Zap actions steps: https://zapier.com/help/create/basics/set-up-your-zap-action

 

Oh, great. I just tried it and that works! Thank you so so much!!! 🙂 I didn’t get the dynamic part. But now it makes sense :)

Yay! Thanks so much @Britta for following up here to confirm that using the ...] button to select the Custom value option as Troy suggested did the trick. And thanks for helping out here @Troy Tessalone! 🤗

Sounds like you’re all set for now but please do reach back out to the Community if there’s anything else we can assist with. In the meantime, happy Zapping! ⚡️

Terms & Conditions