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”).
We’ve fixed this bug! @chadhively make sure to update the Google Sheets – Add Single Row action is up to date (the UI will prompt you to update the action if it isn’t), and give this another try.