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?

1 month ago
23 July 2024
3 replies
50 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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.