Append Row in Google sheets, but descending

Help Studio
, ,
3

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 in the A1 with headers

Regards
Sudharsan