Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Get a File Share Urls from Google drive folder and Create Rows in Google Sheets with URL

I have folder of images in Google Drive and I would like to be be able to add the URLs of the images to a Google Sheet along with it’s respective file name. I’m aware of the new file trigger, however these are current files already in google drive. 

For new files, I was able to setup the new file trigger to “Add File Sharing Preference in Google Drive” to get the URL, use the “Text” function to create the file name as I wanted it to be and post this information into the google sheet with no problem. However, these aren’t new files in my google drive and I’m not sure how to handle in the case of current vs new files.

Hi @dd2mywork 

In general, Zaps work when turned on for new data going forward.

One thought would be to (re)move the old files and then move the files back into the GDrive folder, thus triggering the Zap.

Otherwise, there may need to be manual work done to backfill data as desired.

Hi @dd2mywork 

In general, Zaps work when turned on for new data going forward.

One thought would be to (re)move the old files and then move the files back into the GDrive folder, thus triggering the Zap.

Otherwise, there may need to be manual work done to backfill data as desired.

Thanks for your time! I will try doing this again. Maybe I didn’t wait long enough before retesting the trigger when I attempted this previously. 

Hi @dd2mywork 

FYI: Some Zaps have instant triggers, other Zap trigger are not instant and can take 1-15 minutes to fire depending on your Zap plan.

The GDrive trigger are not instant.

You can check you Zap Runs history details here: https://zapier.com/app/get-help

Will see how it goes. I hope to be able to use this information to populate a google sheet.

Thanks Again! 

Hey,  @Troy Tessalone...

Do I need to use Lookup Spreadsheet Rows action prior to or can I just use Create Spreadsheet rows? 

@dd2mywork 

You can use GSheets Create Row w/o a prior GSheet Lookup Row step.

GSheets Lookup Row is useful for finding an existing row and returning all the data from the row to use in following Zap steps.

TIP: When in doubt, try it out!

Thanks, @Troy Tessalone ! I’ve tried all of the Google sheets actions since yesterday and made sure that the Google Drive files for the trigger weren’t buried in subfolders, to no avail! I will keep trying...for now! 

@dd2mywork 
Just checking in to see if you still need help with this? 

Terms & Conditions