Skip to main content

I have a Zap that with the following steps:
1. Trigger Step: when a SquareSpare form is submitted
2. Steph 2: Create Company in Bigin
3. Step 3. Create Company in Bigin
4. Step 4: Paths to move files from SquareSpace form to Google Drive subfolders and update Bigin Company with links to Google Drive subfolder files.

The issue is in Step 4. In the Google Drive step that moves files to the subfolders, the files are converted from docx, jpeg etc to binary files.
 

I have tried modifying the configuration of the steps in Step 4, but the result is the same.

Has anyone else experienced the file type being reformatted in this scenario?

 

Hey ​@Seattle Rain,

Can you post screenshots of Data In, Data Out as well as how each Zap step is configured for us to have more context?

Here is a helpful article about dealing with Files in Zapier- https://help.zapier.com/hc/en-us/articles/8496288813453-Send-files-in-Zaps. Hope it helps!
 


Thank you so much for your quick reply.

After digging a little further, I am seeing that the issue is that the files that are being uploaded from the SquareSpace form submission are stored on a SquareSpace related content server, as well as being added as a link on a Google Drive sheet.

When my Zap attempts to open the Google Drive link to the files, it fails as the link is attempting to pull the file from the SquareSpace content server. Without administrative-level permissions to SquareSpace, Zapier cannot grab the file in its original file type and converts is to a binary file.


Hi there ​@Seattle Rain! 👋

I think you’re right, if the file links require you to be logged in order to access them then that’s likely what’s causing the trouble. Are there any settings on the form in Squarespace that would allow you to make the uploaded files publicly accessible?  

If so, that should allow you to pass them to other apps via a Zap. 

If not, it looks like Google Drive can be connected to Squarespace Forms directly: https://support.squarespace.com/hc/en-us/articles/28568908060301-Reconnecting-forms-to-Google-Drive. So you could potentially use a Find a File Google Drive action to then search for the file that was added, rather than attempting to use the file URL supplied by the Squarespace trigger. 

Would either of those approaches work?