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.

Best answer

Adding a row to a Google Sheet which creates a New G Drive Folder & adds a link to the row in the Google Sheet

D

Hi,

 

I’m trying to create a Zap that will enable me to…

 

 

Trigger:

  •  Add A new row to a G sheet file

Action: 

  • Create a folder in my G Drive when a new row is added to a G Sheet
  • Add a link to the folder into a cell within the row that was added to the G Sheet

 

So far I can create a Zap that will add the new folder, but I can’t figure out how to get the link, and insert it into the new row of the G Sheet. I need the G Sheet to look like this

 

Folder Link First Name Last Name  Address
Link to P-Smith Folder Pat Smith NYC
Link to J-Doe Folder John Doe NYC

 

 

 

I think that it can be done, based on the question uploaded by this user. but I can’t figure out how to get it working...

https://community.zapier.com/general-questions-3/work-flow-to-create-new-drive-folders-from-sheets-update-sheets-when-new-file-is-created-in-those-folders-2957

 

 

Is there a pre-made Zap for this, or how can I get the link added to the new row in the G Sheet ?

 

 

 

Thanks in Advance

 

 

Best answer by XRay TechBest answer by XRay Tech

Hi @Donal,

The trigger should be a new row added in gsheets.:

 

Then add a create folder in gdrive step:

Then add an update g sheet row step and use the variables from the first step to find the row that was pulled and for the link to the folder, use the id of the gDrive from step to to populate the link.

 

Happy Zapping! 🤓🎉
 

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.

XRay Tech
Forum|alt.badge.img+4
  • XRay TechZapier Expert
  • Zapier Expert
  • June 21, 2021

Hi @Donal,

The trigger should be a new row added in gsheets.:

 

Then add a create folder in gdrive step:

Then add an update g sheet row step and use the variables from the first step to find the row that was pulled and for the link to the folder, use the id of the gDrive from step to to populate the link.

 

Happy Zapping! 🤓🎉
 

Liz_Roberts
1 person likes this
  • Liz_Roberts
    Liz_Roberts
D
  • DonalBeginner
  • Beginner
  • June 21, 2021

Hi XRay Tech,

 

Thanks for the fast reply and this makes sense.

 

One Question: Will this add a link to a new row every time I add one, as this is where I was going wrong?
I thought by using the format that you showed (1.Row ID:3) would keep adding the link to the same row every time, instead of adding a new link to each new row.

 

 

Thanks Again,

-Donal

R

Hi @Donal,

If you still need assistance with this, here is a 2 min video about the solution.

https://www.youtube.com/watch?v=54-nch0t8PQ&ab_channel=robotsarenice

 

D
  • DonalBeginner
  • Beginner
  • July 13, 2021

Hi robotsarenice,

 

I got it completed using the same approach that you used in the video with one change. I wrapped the folder link in a formula as follows…

 

=HYPERLINK("https://drive.google.com/drive/folders/XXXXXXXXXXXXXXXXXXXX", "View Folder")

 

Then when someone views the Google Sheet they will see a link called “View Folder” instead of the full URL.

 

Regards,

Donal

Terms & Conditions