Delete duplicate values in Google Sheets
Removes duplicate records from an existing Google Sheets spreadsheet.
You will provide the column letter where you want to remove the duplicates from, and the entire row where the duplicated values are located will be deleted.
Common use cases
- Data and Content Manipulation
Application
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | URL of the Google Sheets spreadsheet | URL | Yes | https://drive.google.com/sheet/1Fy55AyJu9 |
| Column letters | Duplicates will be removed from the column letters specified | List of Text | Yes | C2 |
| Sheet Name | Spreadsheet (tab) name where to remove duplicates | Text | No | tab2 |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data Library. These variables in the Data Library are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
- N/A
Statuses
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the duplicate values were successfully deleted in Google Sheets |
| Unsuccessful | This status is selected in the event of the following scenarios:- Fail to login to account- Application site is down- The Google Sheets spreadsheet link does not exist- Fail to login to account |
Requirements
- The provided Link to the Sheet must have editing permissions.
- All Drives and Sheets need to be shared with:
googlewrkbots@wrk.com