How to remove duplicates in Google Sheet using service account?

Help StudioX
, , ,
1

Hey all,

So I have a GSuite Application Scope, using service account, to add some data to the last row of the sheet. I also want to remove the duplicates in that sheet. I was able to add the data, but can’t figure out how to remove the duplicates.

PS: Since it’s Gsuite, everything’s happening in the background, so removing duplicates should happen in the background too

Any suggestion?
Thanks

2

Hello @NJ_98

For adding the data to the Google sheet can you use Append Row activity.