How to remove duplicates in Google Sheet using service account?

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?

Hello @NJ_98

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