I can successfully add a row to google sheets based on a workflow in Pipedream. However, I would like to add a row above the previously added row. Since my sheet has headers, the ideal row would be to insert at row 2 and shift the other rows down 1 row. Is this possible?
Hi @craftmath,
Did you configure the Does the first row of the sheet have headers? prop in the Create single row action?
I believe that should insert the new row below the headers.
I’m sorry, I see what you mean, that would add the row at the bottom, not above.
At this time we don’t have this option in that pre-built action, but if you’re comfortable with Node.js, you can use the Use any Google Sheets API action to build this custom insert row functionality in a step.
Not comfortable with Node.js, but I’m up for a challenge… haha.
The reason I’m looking for this is that each time a new row is added, the original filter that I had set on that google sheet does not acknowledge this “new row” at the bottom. It does not apply the filter to these new items, that is unless I remove the filter and re-add it to the headers.