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?