How to read data from specific row onwards in google spreadsheet

[Sagar_Chaudhari]

I want to read the data from google spreadsheet from 4th row till last and append to another spreadsheet. How can i read from 4th row and append

[vrdabberu (Varunraj Dabberu)]

Hi @Sagar_Chaudhari

Try giving the below in Range within double quotes by opening the Advanced Editor.

Sheet1!A4:Z

Regards

[ashokkarale]

@Sagar_Chaudhari,

Use https://docs.uipath.com/activities/other/latest/productivity/gsuite-read-range activity and provide the range from 4th row.

For Appending follow this solution.

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…

Thanks,
Ashok

Thanks,
Ashok

[vrdabberu (Varunraj Dabberu)]

Hi @Sagar_Chaudhari

Check the below image:

If you have headers in 4th row then keep Has Headers as True or click on False.

Regards

[Sagar_Chaudhari]

It has worked. Thank you

[vrdabberu (Varunraj Dabberu)]

Hi @Sagar_Chaudhari

Glad to be helped.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…

Regards