Skip to main content
Visit Freshworks.com Visit Freshworks

Hey there,

I’m trying to create an automation using the Google Sheets Orchestration and hitting a bit of a dead end. For logging purposes when creating users we want to record what has been actioned during automations in a Google Sheet, but the full flow is currently 2 separate automations:

 

1st automation: Creates calendar event and adds an entry to the Google Sheet with various details (department/job title etc) and sends approval. We’ll call the “pre-stage”.

2nd automation: Creates the accounts for the new user (Google/Zoom/Slack etc). In this flow I want to update that original Google Sheet on the same row with information such as date of the user’s creation etc.

 

Problem is that I can’t seem to find a way to refer back to the specific row that was created in the 1st pre-staging automation. That means if we pre-stage 2 users, then there doesn’t seem to be a way to actually refer to those rows again. Am I missing something? 

Hi @easy-peeler ,

 

Sorry for the delay. Unfortunately, we cannot refer back to the previous row updated in the 1st Automation, as linking Workflows in the Product is not possible.

However, we recommend using a Timer node and maintaining only one Workflow. This way, you can introduce a time delay before creating user accounts and subsequently updating the row in the Google Sheet.

 

Thanks,

Abhishek

Reply


Terms of Use