This topic was automatically generated from Slack. You can find the original thread here.
hey Pipedream friends! i’m running into an issue on a workflow. when a new row is created in one sheet, i want the workflow to add a new row of data in another sheet based on one of the values in the source sheet.
example, column AR in the source sheet has the value ‘business’, workflow looks for a tab in the sheet named ‘business’ and adds the new row of data to this sheet.
however, when i try to put a custom expression into the ‘Sheet Name’ field in the add row step, I run into this error: Unable to parse range: {{steps.code.$return_value}}!1:1
can you not use path values in the Sheet Name field? or there another way to accomplish this? thanks for any help!
That action uses additionalProps() to dynamically render the column names for you to configure, but it does not work with step references unfortunately. So the Sheet Name changes?
If you aren’t able to hardcode the sheet name, you could export an object in a previous step and select “No” for “Does the first row of the sheet have headers?” prop, and pass the data as an object instead.
Ok, thanks ! Yeah, the sheet name will change depending on the newly created row of data. I essentially want this workflow to filter the rows of data to the appropriate destination sheet every time a new row is added in the source sheet. I’ll try what you’re recommending and see what happens! Much appreciated.
