This topic was automatically generated from Slack. You can find the original thread here.
Working on a Google Sheets workflow. I need to create a new spreadsheet and then add rows to the spreadsheet. I am able to create it, but in the next step when I am wanting to add a row, I need to reference the newly created spreadsheet from the prior step. I can’t figure out how to get this to work dynamically. The format for the option is “Sheet Name” + “Sheet Id”, but when trying to just replicate this with text, it does not recognize it. I have tried a bunch of different combos and can’t get anything going. Anyone have experience with this one?
If you click “Enter a custom expression”, you should see the object explorer, which will display all the previous steps’ exports, and you should be able to select the newly created sheet ID
Oh yea, sorry, you’ll need to also either reference the sheet name dynamically, like you are doing with the spreadsheet ID, or I think you can maybe hardcode it to “sheet 1”? I might be wrong about that though.
The automatically populated list is called “async options” and that won’t work if the ID is referenced dynamically, since we don’t evaluate that until workflow execution.
Yeah, makes sense why its not avialable in the list. Have tried Sheet 1, Sheet1. Also tyried creating a worksheet within the spreadsheet dynamically (which worked fine), and then refeencing the worksheet name and id as well. Still get the config error at the bottom
You’ll need to update the prop that is asking about a header row to “no” for the same reason — that pulls in the header row automatically, but that won’t work when referencing the spreadsheet details dynamically.
