This topic was automatically generated from Slack. You can find the original thread here.
Hello everyone - I’m working with the Pipedream google sheets integration and am running into this:
I’ve created a new sheet in a previous step, and now I want to add multiple rows to that sheet
I have the sheetID from the create a new sheet step, but when I reference it in the create multiple rows step like the first screen shot I get a “requested entity not found” error
When I copy the value of the sheetID and put that in, it works just fine.
I know what I’m messing up here is really simple, but I can’t see it! I need to be able to inject the ID from a previous step as the sheet I want to create rows in will change.
sure thing, I’d thought to try that as well, but because when I reference the returned sheet id I get an error, I can’t really see what the input values are. Here I tried to force it by entering “Sheet 1” in the Sheet name field
throws and error, and the input looks almost the same. but using the {{steps.create_spreadsheet.$return_value.spreadsheetId}} for the sheetID doesn’t seem to pull in the sheets that live inside that google sheet so that I can select one
Yes, the async options might not work with JS evaluation.
I wonder if the Sheet Name prop is the culprit.
On your working example with a user defined Google Sheet, after you successfully test does the Detailed/Code mode show a specific Sheet Name ID instead of the title?
so you think it may be that evaluating the expression for getting the id from the previous step…… the {{steps.create_spreadsheet.$return_value.spreadsheetId}} part isn’t happening early enough to allow pipedream to reach out to google with that sheetID and get the sheet names from the google sheet?
which is why it throw the “requested entity not found” error. It makes the request to sheets without an ID if an expression is used?
{{steps.create_spreadsheet.$return_value.spreadsheetId}} part isn’t happening early enough to allow pipedream to reach out to google with that sheetID and get the sheet names from the google sheet?
Correct, I don’t believe the JS evaluation is happening while you’re defining the configuration for that step.
I don’t believe the Sheet Name async prop is able to query Google Sheets for Sheet Names because the JS evaluation output isn’t available at the time of configuration.
But, if the Sheet Name title is one in the same, then it doesn’t matter. At execution time the correct value is passed