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? 

 


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

3 replies

Userlevel 7
Badge +14

Hi @Nhanik 

Good question.

Try this Zap action: GDrive Find File

 

Userlevel 7
Badge +12

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. 

 

Userlevel 7
Badge +9

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!