Hello,
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 Tech
Hello
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.
+12Hi
Does this need to work with the data that already exists? Or just moving forward any new rows that come in with a url?
+11
Just checking in to see if you still need help with this?
If anyone has the solution to this, it would be appreciated!
+4Hello
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.
Thank you
+11Hey
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! :)
Join us on Friday, June 19, 11:30 a.m. ET for a hands-on community build-along where you'll learn the Zapier SDK, follow a live walkthrough, then build your own use case with a Zapier team member in your corner.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
