14 - Domänen-Verkehrs-Anreicher

• •Airtable API Key
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •Google Sheets API-Anmeldedaten

{
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "name": "14 - Domain Traffic Enricher",
  "tags": [],
  "nodes": [
    {
      "id": "541d74fd-8229-442d-8805-3485c0f183ba",
      "name": "🟢 Sheet Trigger: Neue Domain",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -1740,
        60
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID_HERE/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_GOOGLE_SHEET_ID_HERE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID_HERE/edit?usp=drivesdk",
          "cachedResultName": "Companies List"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "YOUR_GOOGLE_SHEETS_CREDENTIAL_ID",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cc51b573-cf22-44ea-8c77-60e12187b348",
      "name": "🧼 Domain-URL bereinigen",
      "type": "n8n-nodes-base.set",
      "position": [
        -1520,
        60
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "domain_cleanup",
              "name": "domain",
              "type": "string",
              "value": "={{ $json.List.replace(/^https?:\\/\\//, '').replace(/^www\\./, '').replace(/\\/$/, '') }}"
            },
            {
              "id": "row_number",
              "name": "rowNumber",
              "type": "number",
              "value": "={{ $json.row_number }}"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "bbd629ed-94fa-4cfd-8274-075890405f6d",
      "name": "🌐 Analyse abrufen (SimilarWeb API)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1300,
        60
      ],
      "parameters": {
        "url": "https://similarweb8.p.rapidapi.com/get-analysis",
        "options": {
          "timeout": 30000
        },
        "sendQuery": true,
        "sendHeaders": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "domain",
              "value": "={{ $json.domain }}"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "X-RapidAPI-Key",
              "value": "YOUR_SIMILARWEB_RAPIDAPI_KEY_HERE"
            },
            {
              "name": "X-RapidAPI-Host",
              "value": "similarweb8.p.rapidapi.com"
            }
          ]
        }
      },
      "typeVersion": 4.1,
      "continueOnFail": true
    },
    {
      "id": "4c68f450-c6c1-4233-af80-527a720114dd",
      "name": "📊 Wichtige Traffic-Kennzahlen extrahieren",
      "type": "n8n-nodes-base.code",
      "position": [
        -1080,
        60
      ],
      "parameters": {
        "jsCode": "// Input: Raw SimilarWeb data in `$json.data`\nconst data = $json.data;\n\nconst output = {\n  domain: data.domain,\n  globalRank: data.global_rank,\n  countryRank: `${data.country_rank.country} - ${data.country_rank.rank}`,\n  categoryRank: `${data.category_rank.category} - ${data.category_rank.rank}`,\n  totalVisits: data.traffic_overview.total_visits,\n  bounceRate: `${(data.traffic_overview.bounce_rate * 100).toFixed(2)}%`,\n  pagesPerVisit: data.traffic_overview.pages_per_visit,\n  avgVisitDuration: data.traffic_overview.avg_visit_duration,\n\n  // Only top 3 traffic sources\n  topTrafficSources: {\n    direct: `${(data.traffic_sources.direct * 100).toFixed(1)}%`,\n    search: `${(data.traffic_sources.search * 100).toFixed(1)}%`,\n    social: `${(data.traffic_sources.social * 100).toFixed(1)}%`\n  },\n\n  // Top 3 countries only\n  topCountries: data.geography.top_countries.slice(0, 3).map(c => `${c.country}: ${(c.share * 100).toFixed(1)}%`),\n\n  deviceSplit: {\n    mobile: `${(data.mobile_vs_desktop.mobile * 100).toFixed(1)}%`,\n    desktop: `${(data.mobile_vs_desktop.desktop * 100).toFixed(1)}%`\n  }\n};\n\nreturn [\n  {\n    json: output\n  }\n];"
      },
      "typeVersion": 2
    },
    {
      "id": "1c94450d-23dd-4a58-a10b-1a976d53e03e",
      "name": "📤 Sheet mit Traffic-Daten aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -860,
        -40
      ],
      "parameters": {
        "columns": {
          "value": {},
          "mappingMode": "defineBelow"
        },
        "options": {},
        "operation": "update",
        "sheetName": "Sheet1",
        "documentId": "YOUR_OUTPUT_GOOGLE_SHEET_ID_HERE"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "YOUR_GOOGLE_SHEETS_CREDENTIAL_ID",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "e4edab91-d07a-4045-96fb-36918cb869ce",
      "name": "📁 Export nach Airtable (Optional)",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -860,
        160
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_AIRTABLE_BASE_ID"
        },
        "table": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_AIRTABLE_TABLE_NAME"
        },
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "create",
        "authentication": "airtableOAuth2Api"
      },
      "credentials": {
        "airtableOAuth2Api": {
          "id": "YOUR_AIRTABLE_CREDENTIAL_ID",
          "name": "Airtable Personal Access Token account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "e6e73f3f-5987-4a01-b5b3-b2e7f5f5c0bd",
      "name": "Notiz",
      "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 the data for enrichment and traffic analysis.*"
      },
      "typeVersion": 1
    },
    {
      "id": "2356c9db-8443-4805-af2c-77b32170637b",
      "name": "Notiz1",
      "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 rate). Then formats this data to extract only key metrics like:\n\nGlobal Rank, Country Rank, Monthly Visits, Avg Visit Duration, Top Traffic Sources, Device Split (Mobile/Desktop)*"
      },
      "typeVersion": 1
    },
    {
      "id": "0de06e71-5a3e-4040-b110-1ebe399fe669",
      "name": "Notiz2",
      "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.*"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "cc51b573-cf22-44ea-8c77-60e12187b348": {
      "main": [
        [
          {
            "node": "bbd629ed-94fa-4cfd-8274-075890405f6d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "541d74fd-8229-442d-8805-3485c0f183ba": {
      "main": [
        [
          {
            "node": "cc51b573-cf22-44ea-8c77-60e12187b348",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4c68f450-c6c1-4233-af80-527a720114dd": {
      "main": [
        [
          {
            "node": "1c94450d-23dd-4a58-a10b-1a976d53e03e",
            "type": "main",
            "index": 0
          },
          {
            "node": "e4edab91-d07a-4045-96fb-36918cb869ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1c94450d-23dd-4a58-a10b-1a976d53e03e": {
      "main": [
        []
      ]
    },
    "bbd629ed-94fa-4cfd-8274-075890405f6d": {
      "main": [
        [
          {
            "node": "4c68f450-c6c1-4233-af80-527a720114dd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}