Deduplicate by Key and Value

[momomomonmon]

@PeKA37
Hi, I think the following post is helpful.
It also explains the API Endpoint and Request Body, so if you take a look at it, I think you will find the solution.

Google sheets Scenario

You’ll need to use Google Sheets “Make an API Call” module to call the spreadsheets.batchUpdate endpoint to request for a “DeleteDuplicatesRequest”. Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Rows with identical values but different letter cases, formatting, or formulas are considered to be duplicates. [Screenshot_2024-01-07_040142] You will get something that looks like this (you fill in the GridRange and…