We created a Zap that Uploads a PDF every time a new file is added to a Google Drive folder, but we can’t get it to work properly.
The way it works is: the trigger is a new file in the Google Drive folder, we pull the county from that file name using Zapier Formatter, then use a lookup table to match that county to the folder it should be in using Zapier Formatter. This all works fine. The next part is where it breaks down, and we have tried different things.
We just tried using the OneDrive Find Folder step to look for a subfolder in a folder that we identified. Then we take that folder path output for the OneDrive Upload File step to upload a pdf to that folder.
The Problem: Testing it works fine. However, once we turn it on, the Zap creates a whole new root folder “b!PFXhaa1lK0-xlUAHRO1VqM...” and recreates all of the folders (including the QuestionPro Intakes Folder) in that. Then it puts some of the files in there, and some of them where we want them to go. We can’t figure out why this new folder is being created or why only some of the files are going there. We tried creating a custom folder path and just skipping the Find Folder step entirely, but that didn’t fix the problem. We also tried disconnecting and reconnecting the OneDrive account and that didn’t fix the problem either.
Can anyone help?




