Remove Duplicate Entries & Update Google Sheets Based on Profile Urls

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "id": "oxYmbI9hB9C1NxBI",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Remove duplicates and update sheets",
  "tags": [],
  "nodes": [
    {
      "id": "e8958d20-2df7-43d6-bc74-8f75a16e26bd",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1cb867bb-34ce-40ee-84ff-b820647880bd",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        208,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 778504646,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Kb2MV9Py1dWSp4fAoTDkIl1ha3j61CkgN7MalT5b4gU/edit#gid=778504646",
          "cachedResultName": "With Email/Unused"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Kb2MV9Py1dWSp4fAoTDkIl1ha3j61CkgN7MalT5b4gU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Kb2MV9Py1dWSp4fAoTDkIl1ha3j61CkgN7MalT5b4gU/edit?usp=drivesdk",
          "cachedResultName": "Digital Marketing Agencies"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "dc50164c-fc97-48e4-9ec2-827ed2fab61a",
      "name": "Remove Duplicates",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        416,
        0
      ],
      "parameters": {
        "compare": "selectedFields",
        "options": {},
        "fieldsToCompare": "profileUrl"
      },
      "typeVersion": 2
    },
    {
      "id": "15128df4-acbd-4870-bea8-a8f803affdb8",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        624,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "73466e09-7cfb-4a36-be1d-0488bab1ae3e",
      "name": "Update file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        832,
        0
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "list",
          "value": "1Kb2MV9Py1dWSp4fAoTDkIl1ha3j61CkgN7MalT5b4gU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Kb2MV9Py1dWSp4fAoTDkIl1ha3j61CkgN7MalT5b4gU/edit?usp=drivesdk",
          "cachedResultName": "Digital Marketing Agencies"
        },
        "options": {},
        "operation": "update",
        "changeFileContent": true
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "f438e7a8-49f7-4ea0-bde0-00f6763ab304",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        144,
        -112
      ],
      "parameters": {
        "width": 464,
        "height": 368,
        "content": "## Remove Duplicates from Google Sheets"
      },
      "typeVersion": 1
    },
    {
      "id": "02604404-a5c6-4a0f-82c9-b51ea2e6c263",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        -128
      ],
      "parameters": {
        "color": 4,
        "width": 400,
        "height": 368,
        "content": "## Download data as a CSV and update the Google sheets"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "fcb99e52-702c-4928-b3a8-e2b8843d67ea",
  "connections": {
    "Convert to File": {
      "main": [
        [
          {
            "node": "Update file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• googleDriveOAuth2Api
• googleSheetsOAuth2Api

About this workflow

How it Works

Source: https://n8n.io/workflows/8132/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.