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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

Question

How to link a Google Sheet column to a Google Drive file?

  • 22 April 2024
  • 7 replies
  • 26 views
R

I created a zap that automatically creates folders files for my clients, which is named “John Smith” for example.

 

How can I extract that client folder link, then update a specific column with that link?

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @rtlew 

In the data returned from the GDrive step, search for http to narrow the list of variables that are a link, then find the one to map between Zap steps.

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

These are my steps right now.

 

After which step should I search for “http”?

And what action should I use?

 

 

Troy Tessalone
Userlevel 7
Badge +14

@rtlew 

The link to the GDrive Folder would come from Step 2.

 

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

I can’t get passed this error message, when I try to “update the spreadsheet row”.

 I want the link to appear in Column A (which is always blank)

 

 

Troy Tessalone
Userlevel 7
Badge +14

@rtlew 

The Row field expects the Row or ID variable from Step 1, which will be a number.

 

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

There is no row variable from Step 1...it is always blank. I want to FILL it in with the Google Drive link.

Troy Tessalone
Userlevel 7
Badge +14

@rtlew 

Like this...

 

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

Reply


Terms & Conditions