{
  "name": "Enrich domains with SimilarWeb traffic analytics in Google Sheets & Airtable",
  "nodes": [
    {
      "id": "541d74fd-8229-442d-8805-3485c0f183ba",
      "name": "🟢 Sheet Trigger: New Domain",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -1740,
        60
      ]
    },
    {
      "id": "cc51b573-cf22-44ea-8c77-60e12187b348",
      "name": "🧼 Clean Domain URL",
      "type": "n8n-nodes-base.set",
      "position": [
        -1520,
        60
      ]
    },
    {
      "id": "bbd629ed-94fa-4cfd-8274-075890405f6d",
      "name": "🌐 Fetch Analysis (SimilarWeb API)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1300,
        60
      ]
    },
    {
      "id": "4c68f450-c6c1-4233-af80-527a720114dd",
      "name": "📊 Extract Key Traffic Metrics",
      "type": "n8n-nodes-base.code",
      "position": [
        -1080,
        60
      ]
    },
    {
      "id": "1c94450d-23dd-4a58-a10b-1a976d53e03e",
      "name": "📤 Update Sheet with Traffic Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -860,
        -40
      ]
    },
    {
      "id": "e4edab91-d07a-4045-96fb-36918cb869ce",
      "name": "📁 Export to Airtable (Optional)",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -860,
        160
      ]
    },
    {
      "id": "e6e73f3f-5987-4a01-b5b3-b2e7f5f5c0bd",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1780,
        -200
      ],
      "parameters": {
        "width": 400,
        "height": 540,
        "content": "## 🧾 Trigger Sheet | 🛠️ Set Sheet Data\n\n**Purpose:**\n\n*Fetches site URLs from the connected Google Sheet and structures each row into a clean format with keys like domain, rowNumber, etc., preparing t"
      }
    },
    {
      "id": "2356c9db-8443-4805-af2c-77b32170637b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        -320
      ],
      "parameters": {
        "width": 420,
        "height": 660,
        "content": "## 🌍 Similarweb HTTP Request | 🛠️ Set Formatted Similarweb Response\n\n**Purpose:**\n\n*Fetches web traffic and engagement insights from Similarweb for each domain (e.g. global rank, total visits, bounce "
      }
    },
    {
      "id": "0de06e71-5a3e-4040-b110-1ebe399fe669",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -920,
        -320
      ],
      "parameters": {
        "width": 200,
        "height": 660,
        "content": "## 🧾 Send to Sheet\n\n**Purpose:**\n\n*Appends the enriched and filtered lead data back to a new Google Sheet or another destination sheet for further use.*"
      }
    }
  ],
  "connections": {
    "🧼 Clean Domain URL": {
      "main": [
        [
          {
            "node": "🌐 Fetch Analysis (SimilarWeb API)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🟢 Sheet Trigger: New Domain": {
      "main": [
        [
          {
            "node": "🧼 Clean Domain URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Extract Key Traffic Metrics": {
      "main": [
        [
          {
            "node": "📤 Update Sheet with Traffic Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "📁 Export to Airtable (Optional)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📤 Update Sheet with Traffic Data": {
      "main": [
        []
      ]
    },
    "🌐 Fetch Analysis (SimilarWeb API)": {
      "main": [
        [
          {
            "node": "📊 Extract Key Traffic Metrics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}