How do I use the Add A Row module to add a row to a sheet I just made in a previous module (Add A Sheet), within the same scenario?
In other words, when I use the Google Sheets Add A Row, how do I reference the Sheet that I just created in previous step using the Add A Sheet module? How is the new sheet referenced in subsequent Google sheet modules, when we don’t have the Sheet Name beforehand?
Normally I would manually select the location of the spreadsheet (which is known), then you select the Spreadsheet ID (which is also known), then the Sheet Name. In this case, I know the sheet name, but not until I create it inside the same scenario.
Do I need to use the generic API to add the row?
