A new client is entered in a google form, and in one zap, a template google sheet is copied and renamed with the client name, then populated.
Later in the case, I need to update the client’s worksheet and use the update to trigger a document to be drafted using google doc. In order to do this, I have to be able to identify the newly made client worksheet. Unfortunately, because the worksheet is created in a different app, I cannot find it.
Is there a way to pull the worksheet ID from the prior app? I have tried finding a way, I have also pasted the ID to another sheet thinking of a way to find and use it. I can’t seem to find the solution.