AutomationFlowsData & Sheets › Enrich Google Sheets Contacts with Lusha

Enrich Google Sheets Contacts with Lusha

ByAllan Vaccarizi @growthai on n8n.io

This workflow manually pulls contacts from Google Sheets, enriches each person using the Lusha /v2/person API (via LinkedIn URL or name/company lookup), and writes email, phone, and job details back to the same sheet while marking each row as processed. Runs when executed…

Event trigger★★★★☆ complexity19 nodesGoogle SheetsHTTP Request
Data & Sheets Trigger: Event Nodes: 19 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #16116 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "id": "OhEBji8kzhhhVaYM",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "TEMPLATE - Enrich contacts with Lusha",
  "tags": [
    {
      "id": "rQ0XNJT6fCWftlwj",
      "name": "TEMPLATE",
      "createdAt": "2025-06-30T12:46:45.433Z",
      "updatedAt": "2025-06-30T12:46:45.433Z"
    },
    {
      "id": "4Mxr4w9WUgNX1BSx",
      "name": "Lusha",
      "createdAt": "2026-06-04T12:21:35.630Z",
      "updatedAt": "2026-06-04T12:21:35.630Z"
    },
    {
      "id": "bh8kXzZswR9tktjA",
      "name": "Sheets",
      "createdAt": "2025-06-30T12:24:48.983Z",
      "updatedAt": "2025-06-30T12:24:48.983Z"
    }
  ],
  "nodes": [
    {
      "id": "2860e793-3ec3-402d-bb29-3cbb93dc1615",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        -608
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e76e0648-7d08-4485-b651-4cfb389719b4",
      "name": "Sticky Note16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        -1024
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3a6649d6-fbe9-4304-b4c4-c6e2fa37d562",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "dc429840-3254-4db9-95b6-321f32899146",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "19d3aa6a-8283-454e-afdc-6a5408089189",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "22a5d187-2687-498b-b825-181992472614",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1792,
        -320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b0d45ce7-dd1a-4168-885d-2c3250596be6",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2080,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d4e3e4a3-9d32-40f5-81b8-952ec03bc023",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2352,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a4aa2285-35c4-4d85-a9f5-bb6e317e6c85",
      "name": "When Executed Manually",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        704,
        16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "67cbce8c-3b78-4468-a050-8644dccfac82",
      "name": "Read Contacts from Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        912,
        16
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "13df8583-173f-4477-98cf-f9a64fc4d586",
      "name": "Filter Valid Contacts",
      "type": "n8n-nodes-base.filter",
      "position": [
        1120,
        16
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "f5a3fca0-ee0c-4ceb-b595-229de2814b3e",
      "name": "Loop Over Contacts",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1360,
        16
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "2280e1f4-394e-4d07-a4b5-13eebabb6a78",
      "name": "If LinkedIn URL Present",
      "type": "n8n-nodes-base.if",
      "position": [
        1584,
        16
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "88953b68-b915-4cc7-abf9-ff932c3c3987",
      "name": "Fetch Lusha by Name",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1840,
        80
      ],
      "parameters": {},
      "typeVersion": 4.3,
      "alwaysOutputData": false
    },
    {
      "id": "f36b36c9-af94-41ba-a973-f237fcde14e1",
      "name": "Fetch Lusha by LinkedIn",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1840,
        -64
      ],
      "parameters": {},
      "typeVersion": 4.3,
      "alwaysOutputData": false
    },
    {
      "id": "9b482aef-1836-4c33-a63a-d40cc3cc2b81",
      "name": "Map Contact Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        2400,
        0
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2cbeaf80-a400-403c-bcc8-cd78c87962fa",
      "name": "If Contact Data Found",
      "type": "n8n-nodes-base.if",
      "position": [
        2128,
        16
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "c308ef83-ce20-4684-bca1-bf8695d40e6c",
      "name": "Update Enriched Contact",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2640,
        16
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "3d84d2a0-daf5-4800-bbc4-c6da387c86c6",
      "name": "Update Contact Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2864,
        192
      ],
      "parameters": {},
      "typeVersion": 4.7
    }
  ],
  "active": false,
  "settings": {
    "binaryMode": "separate",
    "executionOrder": "v1"
  },
  "versionId": "e8eedb63-8575-406e-a3cf-dd65005d67c0",
  "connections": {
    "Loop Over Contacts": {
      "main": [
        [],
        [
          {
            "node": "If LinkedIn URL Present",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map Contact Fields": {
      "main": [
        [
          {
            "node": "Update Enriched Contact",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Lusha by Name": {
      "main": [
        [
          {
            "node": "If Contact Data Found",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Valid Contacts": {
      "main": [
        [
          {
            "node": "Loop Over Contacts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If Contact Data Found": {
      "main": [
        [
          {
            "node": "Map Contact Fields",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update Contact Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Contact Status": {
      "main": [
        [
          {
            "node": "Loop Over Contacts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Lusha by LinkedIn": {
      "main": [
        [
          {
            "node": "If Contact Data Found",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If LinkedIn URL Present": {
      "main": [
        [
          {
            "node": "Fetch Lusha by LinkedIn",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Fetch Lusha by Name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Enriched Contact": {
      "main": [
        [
          {
            "node": "Update Contact Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Contacts from Sheets": {
      "main": [
        [
          {
            "node": "Filter Valid Contacts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow manually pulls contacts from Google Sheets, enriches each person using the Lusha /v2/person API (via LinkedIn URL or name/company lookup), and writes email, phone, and job details back to the same sheet while marking each row as processed. Runs when executed…

Source: https://n8n.io/workflows/16116/ — 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.

Data & Sheets

TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.

Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +1
Data & Sheets

This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.

HTTP Request, Gmail, Twilio +3
Data & Sheets

PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.

Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Data & Sheets

The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet

Google Sheets, Google Drive, HTTP Request
Data & Sheets

cdp_router. Uses gmailTrigger, telegramTrigger, googleSheets, httpRequest. Event-driven trigger; 53 nodes.

Gmail Trigger, Telegram Trigger, Google Sheets +4