Library quickstart

  • Learn how to build and use an Apps Script library to remove duplicate rows in Google Sheets.

  • Set up the script by creating a new Apps Script project, adding the provided code, and deploying it as a library.

  • Run the script in a Google Sheet by adding the library to your project, calling the removeDuplicates function, and executing the script.

  • Understand the code that retrieves data from the sheet, identifies unique rows, clears the sheet content, and inserts the unique data back into the sheet.

  • Modify the script to remove duplicates based on specific columns instead of entire rows.

Build an Google Apps Script library that you can use to remove duplicate rows in spreadsheet data.

Objectives

  • Set up the script.
  • Run the script.

Prerequisites

To use this sample, you need the following prerequisites:

  • A Google Account (Google Workspace accounts might require administrator approval).
  • A web browser with access to the internet.

Set up the script

To build the library, do the following:

  1. Sign in to your Google Account.
  2. To open the script editor, go to script.google.com.
  3. At the top left, click New project.

  4. Delete any code in the script editor and paste in the following code.

    sheets/removingDuplicates/removingDuplicates.gs
    /**
 * Removes duplicate rows from the current sheet.
 */
function removeDuplicates() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues();
  const uniqueData = {};
  for (const row of data) {
    const key = row.join();
    uniqueData[key] = uniqueData[key] || row