Question

How do I automate copying URLs of unzipped images from Google Drive to a Google Sheet with Zapier?

  • 12 April 2024
  • 4 replies
  • 34 views

Well, after at least a dozen hours trying to figure this out on my own, I’m seeking help.

I am trying to copy the URL’s of photos on google drive and place in a google sheet (will likely concatenate multiple url’s into a single cell)

Workflow is as follows

  1. Trigger New Submission. Product info and photos submitted through 123formbuilder.com. When multiple photos are submitted it creates a zipped folder
  2. Create Multiple Spreadsheet Rows. The URL for that zipped folder is added to a google sheet row. A google apps script runs to unzip the folder, creates a new folder in google drive. The name of the newly created folder is equal to its original URL @ 123formbuilder.com. The script renames the images in the new folder IMG_1.jpg, IMG_2.jpg, and so on.
  3. Find a file in Google Drive. I’ve not had much success finding anything with this step. Not certain it’s even needed.
  4. Formatting step for SKU’s, not related to google Drive image URL’s
  5. Formatting step for SKU’s, not related to google Drive image URL’s
  6. Create Spreadsheet Row in Google Sheets. A google sheet is used to upload product information to an ecommerce site. One of the fields is for image URL’s. For that field, I’m trying to insert the URL of the just created IMG_1.jpg from google drive, but I’ve not figured out how to do so. I was hoping step 3 would help with this, but it has not.

I did have success with this zap when only 1 image (unzipped) is uploaded. Because of the need to unzip multiple image folders, I’ve added steps 2 and 3 but have not had any success yet. I appreciate any advice that can be offered as to how to get this to work. Thank you kindly.

 


4 replies

Userlevel 7
Badge +6

Hi @DenverGuzzi,

Welcome to the Community! 🎉

Based on your workflow, you might need to add a Looping by Zapier step to your Zap.

You can learn more about Looping by Zapier here: 

Hopefully, this helps!

 I’ve not used looping yet, so I will read up on it. Thanks ken.a!

Just an update, I never had any luck with this. I think looping could be needed, but I thought I’d first try to recognize one file in Drive, before adding a looping feature. 

Userlevel 7
Badge +6

Hi @DenverGuzzi,

Thanks for giving my suggestion a try.

I’d recommend reaching out to our Support Team regarding this one. Our Support Team has the correct tools to look closer at the Zap and guide you how to achieve your workflow.

You can reach our Support Team here: https://zapier.com/app/get-help

I appreciate your patience and understanding.

Reply