Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello,

I have a Google Sheet with many many columns and rows. Within some of them are URLs to files (mainly JPGs and PNGs, but some are PDFs). I want to create a Zap that can grab the files from the URLs and save them into specific Google Drive folders.

Thank you so much!

Hi @iane 

Does this need to work with the data that already exists? Or just moving forward any new rows that come in with a url? 

@GetUWired Yes, the URLs already exist on a CDN. I just need a zap to access/open the URL, and save the file to Google Drive Folders.

@iane 
Just checking in to see if you still need help with this? 

If anyone has the solution to this, it would be appreciated! @AndrewJDavison_Luhhu @iane @GetUWired 

Hello @iane ,

 

We have figured out your problem and there is a very easy solution. It seems that you can simply take the URL in the cell.

Take the URL seen in the cell

Nest Use a Formatter step that would extract a URL from the data especially if there is other text in that cell.

Select Extract URL from Text Transform option

Once you get the URL you can simply choose to “Upload a File” to Google Drive and put the Output from the Formatter step into the file field.

 

This should solve your issue and the file will be in your desired location in Google Drive.

Thank you @XRay Tech I appreciate the response! I unfortunately had to do everything one by one and have moved on from this, but I’m sure someone else will greatly benefit from the time saving zap 😂

Hey @iane,

Thanks for letting us know. I’m so sorry to hear you ended up having to manually tackle it, that’s not ideal at all! 

I’m going to mark this as solved as it looks like XRay Tech’s suggestion here would be just the ticket! :)

Terms & Conditions