I’m trying to set up an automation using Zapier, and I’m running into a bit of a road block.
Here’s a basic summary of what I’m trying to do:
- An Excel file lands into a OneDrive folder.
- Zapier sees the file and appends about 10 rows of data at the end of that file. (The 10 rows of data do not change (or rarely do).)
- The edited file is then uploaded to an SFTP server.
Here’s where I’m struggling:
I can’t seem to get Zapier to edit the file that was just uploaded. It can see it, and it can trigger the Zap based off of that file. But the “edit Excel file” action seems to really want to edit some existing file, not the one that was just uploaded. I think that’s pretty much the issue, as I seem to be able to do all of the other steps just fine.
Does anyone have any ideas? Or is this better in the Zapier community? I thought I would ask here first since the Automators crew are the best!