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:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2203d7f4-4e77-49bf-b128-427d3f7c5b93.png)
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