The goal of our Zap:
When it fires, if a spreadsheet with the title “[input data title]” does not exist, create the spreadsheet titled “[input data title]” in Google Sheets.
If the spreadsheet with that title _does_ exist, find that spreadsheet and add a row.
We use a master sheet to determine whether to create a new spreadsheet or update an existing one - if a row in the master sheet exists with title === “[input data title]”, the sheet exists.
The issue is that in order to accomplish this flow, we need to use the Path action. Path A will create a new spreadsheet and update it with the first record. This works great!
Path B attempts to find the spreadsheet created by the title. Path B is not aware of the spreadsheet ID that was created in Path A since these two actions will not execute in the same Zap run.
In Path B, in the “Create Spreadsheet Row in Google Sheets” action, in the “Spreadsheet” field, I choose the Custom tab and select the “[input data title]” data field. (see screenshot 1) I cannot simply select the spreadsheet since this has to be dynamic - it needs to create or update a spreadsheet based on the incoming data.
When I go to test it, Zapier returns an error. “Requested entity not found” (screenshot 2).
Is it possible to conditionally create a Google sheet with a dynamic name, or update that sheet if it already exists, all in one Zap?