Add sheet to google sheets workbook and then add rows to the sheet

How To
1

I want to add a sheet to a Google Sheets workbook and then add rows to it in a flow. I can create the sheet with a unique name that I calculate in a variable. However, the “Add Rows” module seems to require a static reference to the sheet, whereas I need a dynamic reference to the name of the sheet I just created. Is this flow possible?

2

I solved this by using the “Enter Manually” Search Method option. I then dynamically referenced the spreadsheet ID and the sheet name that I calculated in earlier steps.

1 Like