Skip to main content
All CollectionsWrk Action LibraryGoogle Sheets
Delete duplicate values in Google Sheets
Delete duplicate values in Google Sheets
Wrk Product avatar
Written by Wrk Product
Updated over a week ago

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

Did this answer your question?