Google sheet Datatable row delete

[ajkv (Ajaykumar)]

i want to delete all (“Completed”) rows.

[Palaniyappan (Palaniyappan P)]

Hi
I hope we dont have a specific activity to delete rows in GSuite and its workbooks directly in GOOGLE SHEETS, rather we can read them and get the value we want with GSuite activities like
https://activities.uipath.com/docs/gsuite-application-scope

we need to use certain click activities to accomplish this buddy
Cheers @ajkv

[Lahiru.Fernando]

Hi @ajkv

I have not tried this activity set… But it has some excel related activities. It does not have a direct activity to delete rows. However, you can use the Read Range activity available in this set and get the data onto a datatable. Then you can use the normal Filter Data Table activity to filter out the completed records. Then do a Write range available here and update the google document

Try it out and see how it goes.
https://go.uipath.com/component/google-gsuite

[ajkv (Ajaykumar)]

Thank You