Please assist.
Here’s what I am trying to do in the zap.
- Email to zapier with an excel attachment (works)
- Add to excel file to Google drive (works)
- 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.)