Skip to main content
Question

Google Sheet URL Retrieval


I have created a connection from Smartsheet to Google Sheet. 

 

Trigger is Updated Row in Smartsheet

Action is Path, A B or C : to create a Spreadsheet in Google. 

I then want to go find the URL of the spreadsheet created and then update it in the smartsheet row but by using the Path action it wont allow me to add any additional steps.  

 

how can i accomplish this? 

 

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

Good question.

Try this Zap action: GDrive Find File

 


GetUWired
Forum|alt.badge.img+12
  • Zapier Expert
  • July 15, 2022

Hi @Nhanik 

The spreadsheet url is returned from the create spreadsheet step. You cannot consolidate paths back into 1 flow. You will need to add the update smartsheet action into the path’s workflow. 

 


jesse
Forum|alt.badge.img+9
  • Architect
  • July 18, 2022

Hey @Nhanik! Just checking in here to see if you were able to get things working the way you were wanting in regards to updating the sheet, with the advice from this thread. Let us know where you’re at and if you were able to get things working!