Skip to main content

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?

 

 

Hi ​@Aubrey R. 

From the screenshots, we can’t see how the variables are mapped for the 2 Formatter step in EDIT mode with the field mappings visible.

 

For live Zap Runs, check the DATA IN/OUT for each step to help you trace the data flow and troubleshoot: https://zapier.com/app/history/


Weird folder path that is sometimes created

 

@Troy Tessalone Here are steps 2-5 in editing mode. The folder path is QuestionPro Intake Responses/Yreka in this example. We have tried looking at the data in/out and the weird folder is showing up and we aren’t sure why. 

 

 


@Aubrey R. 

For Zap step 5, OneDrive Upload File, do you need to select a Shared Folder?

Check the warning note at the top of the step seen in the screenshot below for possible context.

TIP: Click field labels to see tooltips with more info.

 


@Troy Tessalone We tried both shared folder and folder and the problem is still happening. But we created the folder on the OneDrive account that is connected to the Zap so I don’t think it should be a shared folder. We just had “search shared folders” marked as “yes” just in case on the previous step.


@Aubrey R. 

In the Zap Runs history details, check the LOGS tab to see the underlying API requests/responses, which may have clues.

 

You can try opening a ticket with Zapier Support to see if they can do deeper troubleshooting: https://zapier.com/app/get-help