Move excel file to a different folder in Google drive (works)
Next day Email to zapier with an excel attachment with same file name (works)
Add excel file with same name to Google drive (works)
Move the new excel file with same name to a different folder in Google drive (does NOT work)
The move function will only work once. I assume because the first move is linked to the file ID and even though the next day’s file is named the same, the following move won’t move it because now there’s a new file ID.
Question - How do I set up the move action in the zap so that tit will find the revised file ID each time?
(By the way, I tried to use a Find step to find the same File Name. This did not work. I was hopeful as I read this suggestion here.)
Best answer by christina.d
Hi there, friends! I wanted to consolidate some of the responses here in case it’s helpful for anyone following along. 🤗
Troy recommended trying these Zap steps:
Trigger: Email by Zapier - New Inbound Email
Action: GDrive - Find/Create Folder
Action: GDrive - Upload File
He also suggested trying a Delay step in the Zap to avoid having to use multiple Zaps. Here’s some helpful reading for how to setup delays in Zaps.
This was also presented as alternative:
TamRazzleDazzle wrote:
Hey @NC-Kin! I’ve been reading through your issue here and I am wondering if using paths logic would better suited instead of using two zaps? Maybe that could solve the issue of the file not being found? 🤔 I’m not 100% sure if this would work but figured it’d be worth a shot if you haven’t tried it yet! Here’s a link to branching logic with paths. https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths
Please post screenshots with how your Zap steps are configured with the variables mapped between Zap steps in order for us to have more context, thanks.
Make sure you are dynamically mapping the GDrive File ID between Zap steps.
Thanks for the response. I should clarify that I am using two zaps - one to upload the excel file and another to move. I couldn’t figure out a way to have them in one zap, but wanted to give context. Also, I’m only in the test mode at this time.
So, below are the pertinent Find and Move the excel file that is failing after the first time.
Like I shared above, the test works once and then stops working even though the file I upload to Google Drive has the same name.
If I understand you correctly, it’s a timing issue for one zap to do everything because I have two triggers (one being an email and another being a date). Thus, I separated them, which I’m okay with.
The heart of the problem is that the Move action only works once in the second zap, despite the file being named the same. And, as I mentioned, I tried to do the Find function in hope it would help the Move action, but it still did not work.
Generally speaking, here’s what’s happening.
---
Zap1 - xMonday - via email upload the file to Google Drive
Zap2 - xFriday - find & move the file uploaded on xMonday to a different folder in Google Drive
Zap1 - yMonday - via email upload the same named file to Google Drive
Zap2 - yFriday - finding & moving the yMonday file doesn’t work even though the file name from xFriday is the same yFriday
---
Does this make sense? Happy to clarify anything else.
Hey @NC-Kin! I’ve been reading through your issue here and I am wondering if using paths logic would better suited instead of using two zaps? Maybe that could solve the issue of the file not being found? 🤔 I’m not 100% sure if this would work but figured it’d be worth a shot if you haven’t tried it yet! Here’s a link to branching logic with paths. https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths
Hi @TamRazzleDazzle - Thanks for the suggestion! I will definitely test it.
Hey @Troy Tessalone - I was only the testing phase of the Move zap, so there’s no history. Maybe what I’ll try to do is turn it on and see what history shows. I’ll reach back out so I’ve tested that out as well as the delay step.
@Troy Tessalone - Thanks for all your help yesterday! I don’t know why but today the zap is working as intended. I didn’t change anything. 🤷 I did, however, add in the delay step you recommended which is super helpful. Thanks again!
Hi there, friends! I wanted to consolidate some of the responses here in case it’s helpful for anyone following along. 🤗
Troy recommended trying these Zap steps:
Trigger: Email by Zapier - New Inbound Email
Action: GDrive - Find/Create Folder
Action: GDrive - Upload File
He also suggested trying a Delay step in the Zap to avoid having to use multiple Zaps. Here’s some helpful reading for how to setup delays in Zaps.
This was also presented as alternative:
TamRazzleDazzle wrote:
Hey @NC-Kin! I’ve been reading through your issue here and I am wondering if using paths logic would better suited instead of using two zaps? Maybe that could solve the issue of the file not being found? 🤔 I’m not 100% sure if this would work but figured it’d be worth a shot if you haven’t tried it yet! Here’s a link to branching logic with paths. https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths