I need to get multiple files that are being submitted through a hubspot form and upload them to a google drive folder with the contact record name. So far I made it work with just 1 file, but I need it to work when users select multiple files to upload. My steps are:
- New form submission in hubspot
- Find contact in hubspot. This takes the email on the form and grabs the First and Last name after finding a contact with that email.
- Text formatter by Zappier. I added this to format the URL from the form and split it into the multiple files URLs.
- Create Loop From line items in looping
- Get File Public URL. This should grab the URLs from the text formatter/Loop
- Find a folder in Google Drive. I take again the first and last name to avoid a duplicate and if there isn’t a folder with those it creates it
- Upload file
So far the loop kinda works, if I upload 5 files it uploads 5 files, but is always the first URL, so the first file is repeated 5 times. I also tried adding a Google sheet to send the URL there, grab it, and then clear the row for a new URL, but the same thing happens, it always takes the first URL only. I believe my issue is in how im mapping the Line items on the loop step, but I’m lost there on what or how to map the correct URL.
Thanks in advance.