Skip to main content
Question

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

  • 23 July 2024
  • 3 replies
  • 60 views

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.