sheets_find_duplicates
Identify duplicate rows in a Google Sheets range by comparing specified columns. Specify the spreadsheet, range, and optional column indices to detect repeated data.
Instructions
Finds duplicate rows in a range based on specified columns
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range to search (first row treated as headers) | |
| columns | No | 0-based column indices to check for duplicates (default: all columns) | |
| spreadsheet_id | Yes | The ID of the spreadsheet |