Recreate the issue:
- Create a workflow with Add Row to Google Sheets step
- Select Google Account
- Instead of selecting a particular Sheet from the dropdown, try to enter a string (or a reference). The step does not connect to Google to search for the sheet, and it won’t load the Sheet’s tables in the next field.
This Google account has more than 100 sheets, so there is no way to use some sheets unless I enter the Sheet ID directly. I know the sheet ID is correct because this all works if I use the Get Data step for Google Sheets.
I have made the Workflow available to support in my account (“Temp-Onboard-Workflow”).
Thanks for everything you do.