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!
Best answer by XRay TechView original
Does this need to work with the data that already exists? Or just moving forward any new rows that come in with a url?
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
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.
Nest Use a Formatter step that would extract a URL from the data especially if there is other text in that cell.
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.
@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 😂
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! :)