Append Range - Google Sheets

[sam.willson]

Hi all,

I’m having some issues appending a range in Google Sheets. I have an existing set of data in a Google Sheet, and I’m trying to read a range from a different Google Sheet (with the same table layout structure) and add it to the end of my current table, but it keeps overwriting when using the Write Range function. There doesn’t appear to be an Append Row/Append Range function, so I’m wondering if anyone will be able to advise?

Thanks in advance,
Sam

[Sudharsan_Ka]

HI @sam.willson

Check with the steps in this thread

Append Row in Google sheets, but descending

HI @Ruxandra_Zamfir Have you tried like this Use read range and read the gsheet and store them in a variable DT1 Use a build datatable Add the rows in that table and At last sort the datatable and then Use write range and disable write headers and give the cell as “A”+(DT1.ROws.Count+1).Tostring [image] If you need to sort the whole sheet after appending the rows try this After appending all the rows read them and store them in a datatable Now Sort the datatable and use write range and i…

Regards
Sudharsan

[sam.willson]

Thank you, that’s great!