{
  "name": "Auto-enrich & sync companies from Google Sheets to HubSpot using GPT-4o-mini",
  "nodes": [
    {
      "id": "6cb9736d-0484-41e5-bb15-1dad740b7ca8",
      "name": "📥 Sheet Trigger - New Company",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -1780,
        80
      ]
    },
    {
      "id": "ffb9fb95-1acf-496f-89d0-f8ee4a8e5281",
      "name": "🧹 Filter: Non-Empty Company Name'",
      "type": "n8n-nodes-base.if",
      "position": [
        -1560,
        80
      ]
    },
    {
      "id": "8a554f66-63ed-432a-a7cf-1eced7e69cfd",
      "name": "🤖 OpenAI Enrichment (GPT-4o-mini)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -1340,
        80
      ]
    },
    {
      "id": "66bd0732-d785-4360-9037-1c111da4b7cb",
      "name": "🧾 Parse Enriched Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -964,
        80
      ]
    },
    {
      "id": "985924aa-dd77-4d2c-9648-26d6b842942d",
      "name": "🔍 HubSpot: Find Company by Domain",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        -744,
        80
      ]
    },
    {
      "id": "bb322fb5-b449-4106-8f39-36c66b742a79",
      "name": "⚖️ Check: Company Exists in HubSpot?",
      "type": "n8n-nodes-base.if",
      "position": [
        -524,
        80
      ]
    },
    {
      "id": "bed544fe-3b79-4cd7-9fc9-d938195f73fd",
      "name": "🏢 Create Company in HubSpot",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        -304,
        155
      ]
    },
    {
      "id": "bf7b2709-51e7-47bb-99f3-9577cd017484",
      "name": "🧰 Prepare Sheet Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -84,
        80
      ]
    },
    {
      "id": "471e239f-294c-42c7-8077-8631efe0212e",
      "name": "📊 Update Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        136,
        80
      ]
    },
    {
      "id": "cc020973-ba65-4d33-8418-0d11e46b5f0a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        -140
      ],
      "parameters": {
        "width": 440,
        "height": 560,
        "content": "## Lead Intake Filter\n\n*This block triggers the workflow from a newly added row in Google Sheets, representing a fresh lead. It then filters out contacts that are incomplete, duplicated, or already en"
      }
    },
    {
      "id": "f7704369-4be3-4505-9dc4-e92115804665",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1380,
        -140
      ],
      "parameters": {
        "width": 580,
        "height": 560,
        "content": "## Company Intelligence via GPT-4o-mini\n\n*This module uses OpenAI to extract rich company insights such as industry, company size, year founded, and a brief summary. The response is parsed into struct"
      }
    },
    {
      "id": "08b3b367-79cc-4d7d-bc1d-65323fa72cb7",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        -140
      ],
      "parameters": {
        "width": 620,
        "height": 560,
        "content": "## CRM Sync: HubSpot Company Management\n\n*Ensures a clean and accurate CRM. First, it checks if the company exists in HubSpot using its domain. If not found, it auto-creates a new entry using enriched"
      }
    },
    {
      "id": "74983ef9-6c90-42f8-95be-b53343030af7",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        -140
      ],
      "parameters": {
        "width": 460,
        "height": 560,
        "content": "## Google Sheets Recordkeeping\n\n*Captures all enriched and CRM-synced companies in a Google Sheet for visibility and operational traceability. Ensures each entry has a consistent structure for review "
      }
    }
  ],
  "connections": {
    "🧰 Prepare Sheet Data": {
      "main": [
        [
          {
            "node": "📊 Update Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Update Google Sheet": {
      "main": [
        []
      ]
    },
    "🧾 Parse Enriched Data": {
      "main": [
        [
          {
            "node": "🔍 HubSpot: Find Company by Domain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🏢 Create Company in HubSpot": {
      "main": [
        [
          {
            "node": "🧰 Prepare Sheet Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 Sheet Trigger - New Company": {
      "main": [
        [
          {
            "node": "🧹 Filter: Non-Empty Company Name'",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔍 HubSpot: Find Company by Domain": {
      "main": [
        [
          {
            "node": "⚖️ Check: Company Exists in HubSpot?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🤖 OpenAI Enrichment (GPT-4o-mini)": {
      "main": [
        [
          {
            "node": "🧾 Parse Enriched Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧹 Filter: Non-Empty Company Name'": {
      "main": [
        [
          {
            "node": "🤖 OpenAI Enrichment (GPT-4o-mini)",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "⚖️ Check: Company Exists in HubSpot?": {
      "main": [
        [
          {
            "node": "🧰 Prepare Sheet Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "🏢 Create Company in HubSpot",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}