This topic was automatically generated from Slack. You can find the original thread here.
Google sheets “Update row” issue
We use Pipedream connect.
First you as a user select an account. Then you select “spreadsheet”. then you select “worksheet”
Then you have 2 more props left - “row number” and “Does the first row of the sheet have headers?”
In my opinion, row number, which I want to edit → does not affect the second prop at all, right?
But if “row number” is left empty, or has an invalid value (for example for random string, but generally empty string is a common case) → if you select “Does the first row of the sheet have headers?” to TRUE → it does not fetch data.
Only if “row number” is set to a valid integer (for example “1”) only then data can be fetched
Can you please make it possible to fetch “Does the first row of the sheet have headers?” data even if “row number” is empty or not valid?
P.S. quick description why it can be invalid → just like on Pipedream platform you can select the previos step result like {{trigger.result.data…}} → this is not an integer right? But it works. We hope to have same thing in Pipedream connect
