{
  "name": "Enrich company data in Google Sheets with CompanyEnrich",
  "nodes": [
    {
      "id": "119d5185-c721-487e-8c80-2e9e58d64ae1",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -160,
        464
      ]
    },
    {
      "id": "f5c70be0-e7fb-41be-afd9-c3cfe240654c",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        80,
        464
      ]
    },
    {
      "id": "0770a814-ee02-4d74-a6b2-27c67260fb9d",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        288,
        464
      ]
    },
    {
      "id": "546d1aea-ee02-42fa-92b7-f98c26dd4b04",
      "name": "Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        -176
      ],
      "parameters": {
        "width": 596,
        "height": 516,
        "content": "## 🚀 Company Enrichment Workflow\n\nThis workflow automatically populates your Google Sheet with firmographic data based on a company's domain name.\n\n## How it works\n1. **Reads** domains from Google She"
      }
    },
    {
      "id": "0b47b632-46a9-4c60-aef6-5a8e8760843b",
      "name": "Input Group",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        368
      ],
      "parameters": {
        "width": 600,
        "height": 240,
        "content": "## 1. Input & Validation\nRetrieves data from your spreadsheet and filters out processed rows to save API credits."
      }
    },
    {
      "id": "ac8b9957-adb9-4697-8e21-5c63f0e00e94",
      "name": "Enrich Group",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        208
      ],
      "parameters": {
        "width": 750,
        "height": 460,
        "content": "## 2. Enrichment & Update\nLoops through domains, fetches data, flattens the JSON structure (e.g. `location.city.name` → `location_city_name`), and updates matching columns in Google Sheets."
      }
    },
    {
      "id": "baf18175-5574-4dac-80ae-131c49136049",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        544,
        464
      ]
    },
    {
      "id": "2802e920-0eef-4d36-b60c-08b9b5bfb02b",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        784,
        304
      ]
    },
    {
      "id": "3b4bf5ca-b508-4fb3-bec8-751f672e38c7",
      "name": "Data Cleaning (JS)",
      "type": "n8n-nodes-base.code",
      "position": [
        960,
        480
      ]
    },
    {
      "id": "f1721f7b-8f22-4183-9142-6541745b3c53",
      "name": "Fetch Company Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        752,
        480
      ]
    }
  ],
  "connections": {
    "Filter": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Fetch Company Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Cleaning (JS)": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Company Data": {
      "main": [
        [
          {
            "node": "Data Cleaning (JS)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}