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 DimensionRange JSON by following the documentation)

1 Like