Mein Workflow 6

• •Google Sheets API-Anmeldedaten
• •Anthropic API Key

{
  "meta": {
    "instanceId": "0a70652f43c1b29dd16c35b61a38fd31c8004f58bc7e723bf43262a797407c77"
  },
  "name": "My workflow 6",
  "tags": [],
  "nodes": [
    {
      "id": "326f7ab3-3c5d-4b6e-bb12-9815a9179740",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        580,
        165
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit?usp=drivesdk",
          "cachedResultName": "n8n test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6181d60a-91b4-4068-80ab-e4c8fb6f7eac",
      "name": "Gültige Zeilen filtern",
      "type": "n8n-nodes-base.if",
      "position": [
        800,
        165
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 1,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "8c7d5b8a-4569-4c8f-b5e8-6c5f5e5c5e5c",
              "operator": {
                "type": "string",
                "operation": "notEmpty"
              },
              "leftValue": "={{ $json.name }}",
              "rightValue": ""
            },
            {
              "id": "9d8e6c9b-5670-5d9f-c6f9-7d6g6f6d6f6d",
              "operator": {
                "type": "string",
                "operation": "notEmpty"
              },
              "leftValue": "={{ $json.website }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "36dd234e-d726-418b-b70e-7c39afea91b4",
      "name": "Über Elemente iterieren",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1020,
        165
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
      "name": "KI-Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1272,
        40
      ],
      "parameters": {
        "text": "=You will be provided with company information including:\n\nName: {{ $json.name }}\nDomain: {{ $json.website }}\n\nYour task is to research and extract the following key business metrics for this company:\nRequired Data Points:\n- Name (keep the same as provided)\n- Website (keep the same as provided)\n- Annual revenue (as business_id first, then get the range)\n- Number of employees (range)\n- NAICS code\n\nUse the Explorium tools to:\n1. First use match-business to find the business ID\n2. Then use enrich-businesses-firmographics to get the company details\n\nReturn the data exactly in this format.",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.6
    },
    {
      "id": "94f62314-ab95-4f2c-8f9c-c658a982815e",
      "name": "Anthropic Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        1240,
        220
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "claude-sonnet-4-20250514",
          "cachedResultName": "Claude Sonnet 4"
        },
        "options": {}
      },
      "credentials": {
        "anthropicApi": {
          "id": "zb4GaoxVQ7gIbD2A",
          "name": "Anthropic account 3"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "c5416012-86dd-4b10-8526-ce4147833572",
      "name": "Code - Ausgabe formatieren",
      "type": "n8n-nodes-base.code",
      "position": [
        1680,
        40
      ],
      "parameters": {
        "jsCode": "// Simply pass through the AI output with proper formatting\nreturn {\n  name: $json.output.name || $json.name,\n  website: $json.output.website || $json.website,\n  business_id: $json.output.business_id || '',\n  naics: $json.output.naics || '',\n  number_of_employees_range: $json.output.number_of_employees_range || '',\n  yearly_revenue_range: $json.output.yearly_revenue_range || ''\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "12f2e1b6-48c9-42f6-a4af-9574b486d270",
      "name": "Unternehmenszeile aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1900,
        165
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "website",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "business_id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "business_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "naics",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "naics",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "number_of_employees_range",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "number_of_employees_range",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "yearly_revenue_range",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "yearly_revenue_range",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "name"
          ]
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit?usp=drivesdk",
          "cachedResultName": "n8n test"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "af35ecca-cf6b-4d3a-ab18-61870f7601c4",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -180
      ],
      "parameters": {
        "width": 660,
        "height": 900,
        "content": "# Enrich Company Data from Google Sheets with Explorium MCP\n\nThis workflow automatically enriches company data when new rows are added or when the name/website fields are updated in your Google Sheet.\n\n### Workflow Structure:\n\n**Google Sheets Trigger** → **Filter Valid Rows** → **Loop Over Items**\n                                                          ↓\n                                                      **AI Agent**\n                                                           ↓\n                                                   **Code - Format Output**\n                                                           ↓\n                                                   **Update Company Row**\n                                                           ↓\n                                                   (back to Loop Over Items)\n\n### How the Loop Works:\n1. Loop Over Items splits the batch (size 1)\n2. Sends one item to AI Agent\n3. AI Agent enriches the data\n4. Code formats the output\n5. Google Sheets updates the row\n6. Flow returns to Loop Over Items for next item\n7. When all items are processed, loop ends\n\n### Key Points:\n- Each row is processed individually\n- The loop continues until all rows are done\n- Failed enrichments won't stop other rows\n\n### Testing:\n1. Add multiple rows with company names and websites\n2. Trigger the workflow\n3. Watch each row get processed sequentially\n4. All rows should be updated with enriched data"
      },
      "typeVersion": 1
    },
    {
      "id": "6194c65f-0321-4ddc-8264-168bd04ef05b",
      "name": "Explorium MCP",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        1380,
        220
      ],
      "parameters": {
        "sseEndpoint": "https://mcp.explorium.ai/sse",
        "authentication": "bearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "7uIoZJ2gQQuHHIDb",
          "name": "Bearer Auth MCP"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c4f2e8b5-ac31-4f29-8f7f-cf7e641efbbb",
      "name": "Ausgabe-Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1520,
        220
      ],
      "parameters": {
        "jsonSchemaExample": "{\n    \"name\": \"Microsoft Corporation\",\n    \"website\": \"https://www.microsoft.com\",\n    \"business_id\": \"a34bacf839b923770b2c360eefa26748\",\n    \"naics\": \"511210\",\n    \"number_of_employees_range\": \"10001+\",\n    \"yearly_revenue_range\": \"100B-1T\"\n}"
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {
    "Google Sheets Trigger": [
      {
        "json": {
          "name": "Amazon.com, Inc.",
          "naics": 454110,
          "website": "https://www.amazon.com",
          "row_number": 9,
          "business_id": "8f19793b2671094e63a15ab883d50137",
          "change_type": "updated",
          "yearly_revenue_range": "100B-1T",
          "number_of_employees_range": "10001+"
        }
      },
      {
        "json": {
          "name": "Toyota North America",
          "naics": 336111,
          "website": "https://careers.toyota.com/us/en",
          "row_number": 10,
          "business_id": "9185f3ec501c674c7c788464a36e7fb3",
          "change_type": "updated",
          "yearly_revenue_range": "10B-100B",
          "number_of_employees_range": "10001+"
        }
      },
      {
        "json": {
          "name": "The Coca-Cola Company",
          "naics": 312112,
          "website": "https://www.coca-colacompany.com",
          "row_number": 11,
          "business_id": "26751be1181460baf78db8d5eb7aad39",
          "change_type": "updated",
          "yearly_revenue_range": "10B-100B",
          "number_of_employees_range": "10001+"
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "",
  "connections": {
    "3870bad2-9551-4c1d-93bd-c42c44ce9584": {
      "main": [
        [
          {
            "node": "c5416012-86dd-4b10-8526-ce4147833572",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6194c65f-0321-4ddc-8264-168bd04ef05b": {
      "ai_tool": [
        [
          {
            "node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "c4f2e8b5-ac31-4f29-8f7f-cf7e641efbbb": {
      "ai_outputParser": [
        [
          {
            "node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "36dd234e-d726-418b-b70e-7c39afea91b4": {
      "main": [
        [],
        [
          {
            "node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6181d60a-91b4-4068-80ab-e4c8fb6f7eac": {
      "main": [
        [
          {
            "node": "36dd234e-d726-418b-b70e-7c39afea91b4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "12f2e1b6-48c9-42f6-a4af-9574b486d270": {
      "main": [
        [
          {
            "node": "36dd234e-d726-418b-b70e-7c39afea91b4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "94f62314-ab95-4f2c-8f9c-c658a982815e": {
      "ai_languageModel": [
        [
          {
            "node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "c5416012-86dd-4b10-8526-ce4147833572": {
      "main": [
        [
          {
            "node": "12f2e1b6-48c9-42f6-a4af-9574b486d270",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "326f7ab3-3c5d-4b6e-bb12-9815a9179740": {
      "main": [
        [
          {
            "node": "6181d60a-91b4-4068-80ab-e4c8fb6f7eac",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}