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!
Best answer by ken.a
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: (view larger)
Map the File ID to the “File” field in your “Move File” step.
Grab the Folder ID from the “Create Folder” step: (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!
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 :)
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.
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! ⚡
