{
  "name": "Automate company data enrichment with HubSpot, Sona & Google Sheets",
  "nodes": [
    {
      "id": "cfff738f-c6dc-48cc-8471-035903590453",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        -32
      ],
      "parameters": {
        "width": 560,
        "height": 736,
        "content": "# Enrich Companies from Google Sheets to HubSpot with Sona\n\n## ✅ Setup Requirements\n\n**Before running this workflow, you need:**\n\n1. **Google Sheets** with a column named `Website Domain`\n   - Add com"
      }
    },
    {
      "id": "6f320dee-168e-4ec6-b1f9-3b50cceb390a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        -32
      ],
      "parameters": {
        "width": 496,
        "height": 448,
        "content": "## 📥 Step 1: Get Company List\n\n**What happens here:**\n- Reads company domains from Google Sheets\n- Aggregates all domains into a single array\n- Prepares data for batch processing"
      }
    },
    {
      "id": "048d6f42-3aeb-44ae-aba2-be2bbfada1c2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        -32
      ],
      "parameters": {
        "width": 496,
        "height": 448,
        "content": "## ⚙️ Step 2: Setup HubSpot Fields\n\n**What happens here:**\n- Creates custom Sona fields in HubSpot CRM\n- Defines all enrichment data fields"
      }
    },
    {
      "id": "47214215-00ee-4f77-be3e-c44d1c8a2575",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        432
      ],
      "parameters": {
        "width": 496,
        "height": 1024,
        "content": "## 🔄 Step 3: Prepare for Processing\n\n**What happens here:**\n- Converts aggregated domains into individual items\n- Splits data for batch loop processing\n- Ready for enrichment"
      }
    },
    {
      "id": "5b1eaf38-0ff8-4bc3-9f34-092f352f2908",
      "name": "Sona Enrich",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        256,
        816
      ]
    },
    {
      "id": "3c3eed25-c652-426a-8e8e-0c84186dc08f",
      "name": "Get Company List from Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -368,
        224
      ]
    },
    {
      "id": "4026e26d-34d8-406b-9278-63a681970b89",
      "name": "Start",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -544,
        224
      ]
    },
    {
      "id": "5226d23c-6153-43e0-9528-553be5f93370",
      "name": "Create HubSpot Company",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        48,
        1024
      ]
    },
    {
      "id": "1756dfb9-4bb2-413a-a971-dcbb347cf334",
      "name": "Create Custom HubSpot Fields",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        128,
        240
      ]
    },
    {
      "id": "d7de0fcb-152e-4c98-8f95-06fcf47ccfa7",
      "name": "Prepare Data for Loop",
      "type": "n8n-nodes-base.set",
      "position": [
        -528,
        640
      ]
    },
    {
      "id": "416d66cf-fbbb-4f12-a31c-d42add3c7b13",
      "name": "Split Companies and AI Output into Items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -304,
        640
      ]
    },
    {
      "id": "b47353dd-9594-45ec-a192-e5eae43b550b",
      "name": "End",
      "type": "n8n-nodes-base.noOp",
      "position": [
        256,
        672
      ]
    },
    {
      "id": "c2cfba98-f310-4f13-8849-2a128f895f50",
      "name": "Loop Through Companies",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        16,
        688
      ]
    },
    {
      "id": "85017b94-98ac-4ad5-96a3-1d18012b6c37",
      "name": "Format Custom Properties",
      "type": "n8n-nodes-base.code",
      "position": [
        256,
        1024
      ]
    },
    {
      "id": "04db3a1f-5d45-4e63-9a8b-127d840c80c0",
      "name": "Update Company with AI Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        64,
        1248
      ]
    },
    {
      "id": "9a555a02-3b9e-44f3-8614-e0c00a074c81",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -208,
        224
      ]
    },
    {
      "id": "0e167f30-9400-4eb1-b2e1-2b6384a0c61e",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        432
      ],
      "parameters": {
        "width": 496,
        "height": 1024,
        "content": "## 🔍 Step 4: Enrich & Sync to HubSpot\n\n**What happens here:**\n- Loops through each company domain\n- Calls Sona API for enrichment data\n- Creates company in HubSpot with standard fields\n- Formats and u"
      }
    },
    {
      "id": "ab47d484-f381-41a1-9d14-5239e9711278",
      "name": "Wait 2 seconds",
      "type": "n8n-nodes-base.wait",
      "position": [
        272,
        1248
      ]
    }
  ],
  "connections": {
    "Start": {
      "main": [
        [
          {
            "node": "Get Company List from Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Create Custom HubSpot Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sona Enrich": {
      "main": [
        [
          {
            "node": "Create HubSpot Company",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 2 seconds": {
      "main": [
        [
          {
            "node": "Loop Through Companies",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Data for Loop": {
      "main": [
        [
          {
            "node": "Split Companies and AI Output into Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create HubSpot Company": {
      "main": [
        [
          {
            "node": "Format Custom Properties",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Through Companies": {
      "main": [
        [
          {
            "node": "End",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sona Enrich",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Custom Properties": {
      "main": [
        [
          {
            "node": "Update Company with AI Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Company List from Sheet": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Company with AI Data": {
      "main": [
        [
          {
            "node": "Wait 2 seconds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Custom HubSpot Fields": {
      "main": [
        [
          {
            "node": "Prepare Data for Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Companies and AI Output into Items": {
      "main": [
        [
          {
            "node": "Loop Through Companies",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}