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.

  • Home
  • Get Help
  • How Do I
  • How do I set up a Zap to download and save files from unique URLs in Google Sheets to Google Drive with specific names?

Hi Team,

 

I need help with the following scenario.

I have tried to set up a Zap that monitors a Google Sheet file, so that when a new row is added, it downloads a (publicly facing) text file from the URL which is saved in column B of the new google sheet row, and when saving the text file to google drive it uses the cell text from column A of the new row.

I have almost got this to work using these steps: 

 

I’ve been able to get it to download a file, but only the link that it explicitly maps to  

 

I need this to work for when I copy in multiple unique rows into the spreadsheet. I.e. if I copy in 15 rows of data, each with a unique name in column A and a unique URL link in column B, i would get 15 unique text files downloaded to my google drive folder each with the file names from Column A.

 

Thanks for your help.

Dan

 

 

Hi @Dan W 

For us to have more context, post screenshots with how your Zap steps are configured in EDIT mode.

Sure,

 

 

@Dan W 

Have you tried turning the Zap ON and testing live?

Check your Zap Runs history for activity and to see the DATA IN/OUT for each Zap step:

https://zapier.com/app/history/

 

Help link about sending files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

Make sure the link in the GSheet is to a publicly accessible direct download URL.

 

 

Terms & Conditions