search

PipedreamHQ / pipedream

Connect APIs, remarkably fast. Free for developers.
https://pipedream.com
Other
8.63k stars 5.27k forks source link

[ACTION] Google Sheets Insert new Row at X #12803

Open cwuensche opened 3 weeks ago

cwuensche commented 3 weeks ago

Is there a specific app this action is for? Google Sheets

Currently the "Add Single Row" action simply appends a new row to the end. Is there a way to update that action or create a new one that lets you consistently add a new row at line "X"? A useful case this would be for is that the spreadsheet has header columns in the first row, and then you want the latest data to be inserted on Line 2 while the rest of the data shifts down a single row.

SinBin10 commented 3 weeks ago

Hello @cwuensche , you can click on any row and then go to insert > rows > here you will find two options insert a row below or above. You can select the option relevant to you. For the use case you specified, you can click on row 2 and click insert a row above that way the rest of the data will shift down a single row.

I believe this solves your query. However there is a way to insert more than 1 row at once. If you want I can talk about that as well.

cwuensche commented 3 weeks ago

Hello @cwuensche , you can click on any row and then go to insert > rows > here you will find two options insert a row below or above. You can select the option relevant to you. For the use case you specified, you can click on row 2 and click insert a row above that way the rest of the data will shift down a single row.

I believe this solves your query. However there is a way to insert more than 1 row at once. If you want I can talk about that as well.

Hi @SinBin10, Are you referring to inserting the rows from within the Google Spreadsheet website/app itself? I desire to do this programmatically.

sakshiagarwal99 commented 3 weeks ago

Hey @cwuensche Have you looked here? https://developers.google.com/sheets/api/samples/rowcolumn#insert-row-column https://developers.google.com/sheets/api/samples/rowcolumn#move-row-column

cwuensche commented 3 weeks ago

Hey @cwuensche Have you looked here? https://developers.google.com/sheets/api/samples/rowcolumn#insert-row-column https://developers.google.com/sheets/api/samples/rowcolumn#move-row-column

Hi @sakshiagarwal99, Yes, thank you for pointing me to those urls. I am working on implementing them into my Pipedream workflow. I'm still hoping someone at Pipedream will still modify/create something like this though into the existing Google Sheet actions or create a new action :)

vunguyenhung commented 3 weeks ago

Thanks for raising this @cwuensche. I'll add this to Pipedream component backlog.