Skip to main content
Question

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


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?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Troy Tessalone
Forum|alt.badge.img+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.


  • New
  • April 22, 2024

These are my steps right now.

 

After which step should I search for “http”?

And what action should I use?

 

 


Troy Tessalone
Forum|alt.badge.img+14

@rtlew 

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

 


  • New
  • April 22, 2024

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
Forum|alt.badge.img+14

@rtlew 

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

 


  • New
  • April 22, 2024

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
Forum|alt.badge.img+14

@rtlew 

Like this...