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

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