How we append Google Sheet record in Uipath

[JSR_Techno_Talk_s]

Hi Friends,
I am working with google Sheet, I am able to create a google sheet.
Task :
I have a Data Table , Whenever my bot run i want to append Table record to my Google Sheet

Append Row work for a row only

Please guide me how to achieve this task

[Rahul_Unnikrishnan]

@JSR_Techno_Talk_s

please refer to the below docs.

Activities - Append Row

How do I use this Google append row?

Hi guys I am trying to figure out this append row I want my data to use a new row instead of overwriting one what must go here? [image]

[JSR_Techno_Talk_s]

Same i am looking , insert the record in new row instead of overwriting one

[Rahul_Unnikrishnan]

@JSR_Techno_Talk_s Then you can try as in the post.

[JSR_Techno_Talk_s]

You can Achive by this

1. First Read google Spreadsheet Data - Dt_googleSpredSheetData
   2 .Write into workbook (Temp.xlsx )Dt_googleSpredSheetData
2. Your Actual Data append in (Temp.xlsx )
3. Read (Temp.xlsx ) and Write to google Spreadsheet
4. Delete Temp file

Any better solution let me know