About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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
Best answer

Get a File Share Urls from Google drive folder and Create Rows in Google Sheets with URL

  • 12 April 2021
  • 8 replies
  • 1054 views
D

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.

icon

Best answer by Troy Tessalone 12 April 2021, 17:56

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Userlevel 7
Badge +14

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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D

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. 

Troy Tessalone
Userlevel 7
Badge +14

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D

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

Thanks Again! 

D

Hey,  @Troy Tessalone...

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

Troy Tessalone
Userlevel 7
Badge +14

@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!

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D

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! 

AndrewJDavison_Luhhu
Userlevel 7
Badge +10

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

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
Terms & Conditions