I want the file uploaded in the HubSpot form to be stored in Google drive.Is that possible with Zapier?
Best answer by MarinaH 9 July 2021, 01:31
Thanks for the question - you should be able to build a Zap like this:
Hope that helps!
Hi @MarinaH ,
I am trying to do this and I keep receiving the error “Only absolute URLs are supported”. I am inputting the field from the form that asks to upload a file. The steps I’ve done so far are:1. Hubspot - New form submission2. Put the form into a google slide3. Create a folder in Google Drive4. Moved the Google slide into that folder5. Get public URL from the Hubspot form submission using the value from the form that requires a file upload6. This is where I want to upload the file from step 5 to the folder created in step 3. But I keep receiving that error.
Please post screenshots of how your Zap steps are configured, thanks.
@Troy Tessalone Please see attached screenshots.
What Zap step is returning the error?
The mapped data point for File URL looks to be sample data and not an actual File URL as indicated by the field description (smaller gray font).
Observation: The Public URL from HubSpot (in this example) shows a .txt file, is that right?
NOTE: You can check if the Public URL returned from HubSpot is accessible, by copy/pasting the URL into a browser tab.
Check out this help article for working with Files in Zap steps: https://zapier.com/help/create/basics/send-files-in-zaps
@Troy Tessalone I am getting the error on step 5, I can’t get the public url.
Please see attached
Error is because a file URL is not being mapped/sent for the File URL field, as you can see in the data attempting to be sent when tested.
@Troy Tessalone The field that I am using is from a form on hubspot that requires a file to be uploaded. I’m not sure how to put an actual file in there until I can turn the zap on and test it?
Can you post a screenshot of the data points returned from the trigger step in the Zap? (HubSpot New Form Submission)
@Troy Tessalone Please see attached
From the screenshots, the test record from the trigger step is placeholder sample data, which is not representative of the actual values that would come thru when the form is actually submitted.
Have you submitted an actual form? (If not, go ahead and do that.)
Then you can pull thru newer test samples from the trigger step by following this article: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger
@Troy Tessalone Got it! Thank you! I had to turn tbe zap on to pull the information! Thanks so much!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.