Skip to main content

Hi,

It’s me again. I’m creating a zap to create a new record in my CRM system every time a form is submitted. Everything works fine, extracting data, creating Google Drive, etc… The only thing I get stuck on is getting the uploaded files from the Gravity Form in my Google Drive.

The URLs are all combined in 1 field. When I upload this field to Google Drive I get a txt field in return. So I guess I need to separate these fields and upload each file separate. 

Can anyone point my in the right direction to do so? If I get a single URL, can I upload to GDrive?

Thank you once again for your advice!

You can use a Formatter or an AI by Zapier step to take the combined text and split it into separate links. If you use Formatter, it will probably take several steps to split, extract, and then cleanup the links, but those tasks are free and don’t require a paid account. The AI step will only take one action, but requires a Pro account.

After you get the links taken care of, you will probably need a Loop step to add each link to the record...unless your CRM supports line items or multiple uploads in a single step.

I’ve done this exact thing for Hubspot and needed the Looping step.


Thank you @DavidLGS!

I have a Pro account so that’s covered. Do you have a prompt example how you’ve done this?

The files don’t need to go to the CRM, they need to get uploaded in a Google Drive folder.


Sorry, no, I don’t have a prompt. I actually did mine with a code step. :-p

I also just checked my zap, and I definitely used a loop step for adding the files to Drive. So, first ingest the raw data, split the links into line items, create a loop based on line items, then add the files to Drive.


Let me try and I’ll get back as soon as I’ve worked it out.


Reply