This workflow follows the Agent → Emailsend recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "K&S-Media Downloadliste SQL",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-960,
800
],
"id": "65d13e01-6543-4c3e-ba6f-0c62813779f3",
"name": "When clicking \u2018Test workflow\u2019"
},
{
"parameters": {
"url": "https://google.serper.dev/search",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "=Company {{ $('Loop Over Items').first().json.Company }} at {{ $('Loop Over Items').first().json.Address.match(/,\\s*(.*)/)[1] }} {{ $('Loop Over Items').first().json.Country }}\n"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-API-KEY",
"value": "4ff0d5d9bf4ba4ca7779a75c034f12fbf1fd8e92"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2540,
2120
],
"id": "ad71fb8d-9e18-4310-bbba-d303c2d0e342",
"name": "HTTP Request"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1240,
2860
],
"id": "7b14237b-cc37-4dde-9255-e8060ad41b02",
"name": "Loop Over Items"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"name": "Replace Me",
"typeVersion": 1,
"position": [
6120,
2880
],
"id": "55da018a-b0af-4432-8be1-be136b4f753d"
},
{
"parameters": {
"promptType": "define",
"text": "=Company {{ $('Loop Over Items').first().json.Company }} in {{ $('Loop Over Items').first().json['Form-Language'] }} {{ $('Loop Over Items').first().json.Country }} does {{ $json.output }} ",
"options": {
"systemMessage": "Du bist ein hochqualifizierter Firmenklassifizierer und Rechercheur mit Zugriff auf zuverl\u00e4ssige Datenquellen.\nDeine Aufgabe ist es, ein Unternehmen anhand des Firmennamens und einer kurzen T\u00e4tigkeitsbeschreibung kontextbezogen zu bewerten.\n\nZu ber\u00fccksichtigende Branchen\n\nAkustik (Raumakustik, Schalld\u00e4mmung, Beschallungstechnik, Audio)\nB\u00fcro (B\u00fcroplanung, B\u00fcrom\u00f6bel, B\u00fcro\u2011Trennw\u00e4nde, Drucker, Druckerverleih, B\u00fcrost\u00fchle, B\u00fcrotische, B\u00fcro\u2011IT)\nName als Indikator\n\nEgal, ob Dienstleistung, Produkt, Entwicklung, Verkauf, Vermietung oder Beratung \u2013 z\u00e4hlt nur, ob das Hauptgesch\u00e4ft ausschlie\u00dflich oder haupts\u00e4chlich in einer oder beiden dieser Branchen liegt.\n\nEnth\u00e4lt der Firmenname ausschlie\u00dflich Keywords aus Akustik oder B\u00fcrobranche (z.\u00a0B. \u201eB\u00fcroplaner GmbH\u201c, \u201eAkustikmeister GmbH\u201c), wertet das stark f\u00fcr 1.\nVerkn\u00fcpft der Name Zielbranchen mit anderen Bereichen (z.\u00a0B. \u201eAkustik und Fitnessger\u00e4te GmbH\u201c), gilt das als 0.\nFehlen im Namen Treffer, bewerte nur anhand der T\u00e4tigkeitsbeschreibung.\nEntscheidungsregeln\n\n1, wenn Name und/oder jede genannte T\u00e4tigkeit ausschlie\u00dflich oder \u00fcberwiegend zu Akustik und/oder B\u00fcro\u00adbranche geh\u00f6rt.\n0, sobald Name oder mindestens eine T\u00e4tigkeit klar nicht dazugeh\u00f6rt (z.\u00a0B. Schultische, Fu\u00dfballklamotten, Festivaltechnik).\n1, wenn T\u00e4tigkeiten unklar sind, aber eindeutige Keywords aus Zielbranchen vorliegen und der Name nicht widerspricht.\n0, wenn es sich lediglich um einen normalen M\u00f6belh\u00e4ndler ohne spezifischen B\u00fcro\u00adbezug handelt.\nWichtig\n\nVerstehe Zusammenh\u00e4nge: \u201eDruckerverleih\u201c z\u00e4hlt zu B\u00fcrobranche; \u201eSchultische\u201c nicht.\nBeurteile ganzheitlich: Name\u00a0+\u00a0Beschreibung m\u00fcssen passen.\nGib nur den Integer 0 oder 1 zur\u00fcck \u2013 keine Erkl\u00e4rungen, Kommentare oder zus\u00e4tzlichen Text.\nInput\n\u2013 Firmenname\n\u2013 T\u00e4tigkeitsbeschreibung (Liste, z.\u00a0B. \u201eB\u00fcrom\u00f6belverkauf, Druckerverleih, Raumakustik-Planung\u201c)\n\nOutput\n\n0\u00a0oder\u00a01"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.8,
"position": [
3100,
2120
],
"id": "182a4ebf-e459-47fa-88a8-afb1f30ce5c8",
"name": "AI Agent"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1135880709,
"mode": "list",
"cachedResultName": "RowsToDelete",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=1135880709"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"User-IP": "={{ $('Loop Over Items').first().json['User-IP'] }}",
"Date": "={{ $('Loop Over Items').first().json.Date }}",
"Time": "={{ $('Loop Over Items').first().json.Time }}",
"Form-Language": "={{ $('Loop Over Items').first().json['Form-Language'] }}",
"First name": "={{ $('Loop Over Items').first().json['First name'] }}",
"Salutation": "={{ $('Loop Over Items').first().json.Salutation }}",
"Name": "={{ $('Loop Over Items').first().json.Name }}",
"Company": "={{ $('Loop Over Items').first().json.Company }}",
"Address": "={{ $('Loop Over Items').first().json.Address }}",
"Country": "={{ $('Loop Over Items').first().json.Country }}",
"E-Mail": "={{ $('Loop Over Items').first().json['E-Mail'] }}",
"Newsletter": "={{ $('Loop Over Items').first().json.Newsletter }}",
"How did you become attentive on the pCon.planner": "={{ $('Loop Over Items').first().json['How did you become attentive on the pCon.planner'] }}",
"I use the pCon.planner as": "={{ $('Loop Over Items').first().json['I use the pCon.planner as'] }}",
"Version": "={{ $('Loop Over Items').first().json.Version }}",
"Edition": "={{ $('Loop Over Items').first().json.Edition }}",
"branche": "={{ $('AI Agent1').first().json.output }}"
},
"matchingColumns": [
"User-IP"
],
"schema": [
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Time",
"displayName": "Time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "User-IP",
"displayName": "User-IP",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Form-Language",
"displayName": "Form-Language",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Salutation",
"displayName": "Salutation",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "First name",
"displayName": "First name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Company",
"displayName": "Company",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Address",
"displayName": "Address",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Country",
"displayName": "Country",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "E-Mail",
"displayName": "E-Mail",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Newsletter",
"displayName": "Newsletter",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "How did you become attentive on the pCon.planner",
"displayName": "How did you become attentive on the pCon.planner",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "I use the pCon.planner as",
"displayName": "I use the pCon.planner as",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Version",
"displayName": "Version",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Edition",
"displayName": "Edition",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "branche",
"displayName": "branche",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
4900,
2100
],
"id": "ef5f59ea-8eb7-44d4-9dd2-70d53b24c789",
"name": "Google Sheets1",
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"promptType": "define",
"text": "=Company {{ $('Loop Over Items').first().json.Company }} in {{ $('Loop Over Items').first().json['Form-Language'] }} {{ $('Loop Over Items').first().json.Country }}is a {{ $json.knowledgeGraph.type }} {{ $json.organic[0].snippet }} {{ $json.organic[2].snippet }} ",
"options": {
"systemMessage": "Du bist ein hochqualifizierter Firmenklassifizierer und Rechercheur mit Zugriff auf zuverl\u00e4ssige Datenquellen.\nDeine Aufgabe ist es, ein Unternehmen anhand des Firmennamens und einer kurzen T\u00e4tigkeitsbeschreibung pr\u00e4zise zu analysieren.\n\nAnleitung:\n\nNutze sowohl Firmennamen als auch T\u00e4tigkeitsbeschreibung, um die tats\u00e4chlichen Kernt\u00e4tigkeiten zu ermitteln.\nGib so viele der wichtigsten T\u00e4tigkeiten aus, wie tats\u00e4chlich vorhanden sind (mindestens\u00a02, maximal\u00a05).\nFormuliere jede T\u00e4tigkeit als Stichpunkt mit 3\u20135 W\u00f6rtern.\nKeine Branchenbezeichnungen, Einordnungen, Erkl\u00e4rungen oder Zusatzinfos.\nKeine Wiederholungen oder Synonyme.\nDie Ausgabe ist eine durch Kommas getrennte Liste der Stichpunkte.\nBeispielausgaben:\n\n\u201eB\u00fcrom\u00f6belverkauf, Festivalorganisation, H\u00f6rger\u00e4teanpassung, Grafikdesign, Immobilienvermittlung\u201c\n\u201eH\u00f6rger\u00e4teberatung, Schalld\u00e4mmungssysteme, Konferenzmikrofontechnik\u201c\n\u201eErgonomische B\u00fcrost\u00fchle, Akustikdeckenmontage, Schulm\u00f6belproduktion\u201c"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.8,
"position": [
2740,
2120
],
"id": "b41e76bf-a23e-4f8b-b61c-083f3f3f896f",
"name": "AI Agent1"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "df41ef12-68ad-48d2-9ab4-6a7423818213",
"leftValue": "={{ $('AI Agent').first().json.output }}",
"rightValue": "1",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
3680,
2120
],
"id": "c93c0e84-46d6-4f7f-b65a-2023b18bc6be",
"name": "If1"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 211066673,
"mode": "list",
"cachedResultName": "Tabellenblatt1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=211066673"
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
960,
2860
],
"id": "333f92a5-577f-4a60-bf83-e0d9d385461f",
"name": "Google Sheets3",
"alwaysOutputData": false,
"executeOnce": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "# Is critical branche",
"height": 2220,
"width": 6680,
"color": 3
},
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
1660
],
"typeVersion": 1,
"id": "f44180d0-5884-4930-bde5-30a55cff5d7c",
"name": "Sticky Note1"
},
{
"parameters": {
"url": "https://google.serper.dev/search",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "={{ $('Loop Over Items3').first().json.Company }} at {{ $('Loop Over Items3').first().json.Address.match(/,\\s*(.*)/)[1] }} telefonnummer {{ $('Loop Over Items3').first().json.Country }}\n"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-API-KEY",
"value": "4ff0d5d9bf4ba4ca7779a75c034f12fbf1fd8e92"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3280,
4040
],
"id": "cf634ade-2915-42eb-b5b0-f0c145c8864f",
"name": "HTTP Request1"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1240,
4260
],
"id": "8fe686e2-7b55-41fb-ab49-5e5b4b2e68a3",
"name": "Loop Over Items3"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"name": "Replace Me3",
"typeVersion": 1,
"position": [
6620,
4240
],
"id": "a7737cea-a8f3-4595-a7d5-9ef4e82d55f8"
},
{
"parameters": {
"model": {
"__rl": true,
"value": "gpt-4o-mini",
"mode": "list",
"cachedResultName": "gpt-4o-mini"
},
"options": {
"temperature": 0
}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1.2,
"position": [
3880,
4800
],
"id": "3b1a02f2-c342-479b-a7a2-afa31939b504",
"name": "OpenAI Chat Model1",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 211066673,
"mode": "list",
"cachedResultName": "Tabellenblatt1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=211066673"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"row_number": "={{ $('Loop Over Items3').first().json.row_number}}",
"CompanyPhone": "={{ JSON.stringify($('AI Agent4').first().json.output) }}"
},
"matchingColumns": [
"row_number"
],
"schema": [
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Time",
"displayName": "Time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "User-IP",
"displayName": "User-IP",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Form-Language",
"displayName": "Form-Language",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Salutation",
"displayName": "Salutation",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "First name",
"displayName": "First name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Company",
"displayName": "Company",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Address",
"displayName": "Address",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Country",
"displayName": "Country",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "E-Mail",
"displayName": "E-Mail",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Newsletter",
"displayName": "Newsletter",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "How did you become attentive on the pCon.planner",
"displayName": "How did you become attentive on the pCon.planner",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "I use the pCon.planner as",
"displayName": "I use the pCon.planner as",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Version",
"displayName": "Version",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Edition",
"displayName": "Edition",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "CompanyPhone",
"displayName": "CompanyPhone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
5100,
4420
],
"id": "31d3aba1-357a-48e3-8081-b972ad917340",
"name": "Google Sheets9",
"executeOnce": true,
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"promptType": "define",
"text": "={{ $json.answerBox.title }} {{ $json.answerBox.answer }};;; {{ $json.organic[0].title }}{{ $json.organic[0].snippet }};;;{{ $json.organic[2].title }}{{ $json.organic[2].snippet }};;;{{ $json.organic[3].title }}{{ $json.organic[3].snippet }};;;",
"options": {
"systemMessage": "=Du bist ein spezialisierter Filter f\u00fcr Telefonnummern von Firmen. Deine Aufgabe ist es, die Telefonnummer der Firma {{ $('Loop Over Items3').first().json.Company }} in {{ $('Loop Over Items3')?.first()?.json.Address && $('Loop Over Items3')?.first()?.json.Address.match(/,\\s*(.*)/) ? $('Loop Over Items3')?.first()?.json.Address.match(/,\\s*(.*)/)[1] : '' }}\n {{ $('Loop Over Items3').first().json.Country }} aus den gegebenen Suchergebnissen zu extrahieren. \n\n## Regeln:\n1. Die Suchergebnisse sind durch `;;;` getrennt.\n2. Gib nur die Telefonnummer aus dem ersten Ergebnis zur\u00fcck, falls sie vorhanden ist. Falls im ersten Ergebnis keine g\u00fcltige Telefonnummer enthalten ist, suche im zweiten.\n3. Stelle sicher, dass die gefundene Telefonnummer auch wirklich der Firma {{ $('Loop Over Items3').item.json.Company }} in {{ $('Loop Over Items3')?.item?.json.Address && $('Loop Over Items3')?.item?.json.Address.match(/,\\s*(.*)/) ? $('Loop Over Items3')?.item?.json.Address.match(/,\\s*(.*)/)[1] : '' }}\n {{ $('Loop Over Items3').item.json.Country }} zugeordnet ist. Achte besonders darauf, dass die Telefonnummer aus einer verl\u00e4sslichen Quelle stammt und der Firma zugeordnet werden kann.\n4. Wenn keine g\u00fcltige Telefonnummer gefunden wird, gib none zur\u00fcck.\n\nGib nur die Telefonnummer zur\u00fcck mit zwei einzigen kurzen worten das beschreibt wo du sie gefunden hast und zu wem sie geh\u00f6rt. Wenn du dazu keine Information hast schreibe \"allgemein\". Keine weiteren Informationen. z.B.\nAnna Schuhmann: +49 44040033003\nallgemein: 40400404\n\nwenn du keine passende Telefonnummer findest gebe nur none zurr\u00fcck und sonst nichts "
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.8,
"position": [
3620,
4040
],
"id": "acfef92d-8704-4396-94e5-d8e640cce987",
"name": "AI Agent3",
"onError": "continueRegularOutput"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "df41ef12-68ad-48d2-9ab4-6a7423818213",
"leftValue": "={{ $json.output }}",
"rightValue": "none",
"operator": {
"type": "string",
"operation": "notEquals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
4180,
4040
],
"id": "b5be9a8b-826f-401f-bad3-c52af77479c8",
"name": "If3"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 211066673,
"mode": "list",
"cachedResultName": "Tabellenblatt1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=211066673"
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
960,
4280
],
"id": "d1707245-a661-4505-8a78-035e57b7d76a",
"name": "Google Sheets11",
"executeOnce": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "# Find company phonenumber\n",
"height": 1220,
"width": 6700,
"color": 6
},
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
3860
],
"typeVersion": 1,
"id": "92d5df79-5c8e-462e-a931-59af4a56dc7f",
"name": "Sticky Note4"
},
{
"parameters": {
"promptType": "define",
"text": "={{ $('Code1').first().json.cleanedText }}\n",
"options": {
"systemMessage": "=Suche hier die telefonnummer raus und Gib nur die Telefonnummer zur\u00fcck mit zwei einzigen kurzen worten das beschreibt wo du sie gefunden hast und zu wem sie geh\u00f6rt. Wenn du dazu keine Information hast schreibe \"allgemein\". Keine weiteren Informationen. z.B.\nAnna Schuhmann: +49 44040033003\nallgemein: 40400404\n\nwenn du keine passende Telefonnummer findest gebe nur none zurr\u00fcck und sonst nichts "
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.8,
"position": [
4140,
4300
],
"id": "11332c7f-8c56-425d-b550-3b587fe0a4f8",
"name": "AI Agent4",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "df41ef12-68ad-48d2-9ab4-6a7423818213",
"leftValue": "={{ $json.output }}",
"rightValue": "none",
"operator": {
"type": "string",
"operation": "notEquals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
4620,
4300
],
"id": "d51b1429-bf82-43fe-bb25-fd9e9451d7ea",
"name": "If4"
},
{
"parameters": {
"url": "={{ $('Loop Over Items3').first().json['E-Mail'] ? \"http://www.\" + $('Loop Over Items3').first().json['E-Mail'].split(\"@\")[1] : '' }}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3240,
4320
],
"id": "7b52b03d-f18d-4203-a4d7-a994498192e1",
"name": "HTTP Request3",
"alwaysOutputData": true,
"onError": "continueRegularOutput"
},
{
"parameters": {
"url": "={{ $('Loop Over Items3').first().json['E-Mail'] ? \"http://www.\" + $('Loop Over Items3').first().json['E-Mail'].split(\"@\")[1] + \"/impressum\" : '' }}\n",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3460,
4320
],
"id": "0a61d027-6db1-4589-95b0-24db29daaa26",
"name": "HTTP Request2",
"alwaysOutputData": true,
"onError": "continueRegularOutput"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6c478565-ae01-4b2d-878f-b2f53ce7d86a",
"leftValue": "={{ $('Loop Over Items3').first().json['E-Mail'].toString() }}",
"rightValue": "^[\\w\\.-]+@(gmail|t\\-online|cloud|ooglemail|test|googlemail|yahoo|ymail|rocketmail|hotmail|outlook|live|msn|icloud|me|mac|aol|mail|zoho|gmx|web|t-online|freenet|email|arcor|vodafone|alice|versanet|kabelmail|online|ewetel|protonmail|proton|tutanota|posteo|runbox|mailfence|startmail|fastmail|hushmail|mailbox|bluewin|sunrise|swissonline|hispeed|laposte|libero|tin|seznam|mail\\.ru|yandex|inbox\\.ru|bk\\.ru|list\\.ru|qq|126|163|sina|naver|daum|gawab|cox|comcast|bellsouth|verizon|berlin|aon|inode|chello|utanet|tele2|eduhi|liwest|netcologne|example|seml|mailinator|pm|clonemailsieure|anonymous|duck)\\.[a-zA-Z]{2,}$",
"operator": {
"type": "string",
"operation": "regex"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
2660,
4260
],
"id": "0fb96c92-663c-4be9-b25d-90996840c08c",
"name": "isEmailPrivat1"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"name": "Replace Me4",
"typeVersion": 1,
"position": [
6960,
7120
],
"id": "b2eeb359-9d19-4fcd-96b7-cdb45b43cabe"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 211066673,
"mode": "list",
"cachedResultName": "Tabellenblatt1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=211066673"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
860,
7140
],
"id": "40d7864e-4095-43d3-8e6d-f4802722e9b9",
"name": "Google Sheets15",
"alwaysOutputData": false,
"executeOnce": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6c478565-ae01-4b2d-878f-b2f53ce7d86a",
"leftValue": "={{ $('Loop Over Items4').first().json.CompanyPhone }}",
"rightValue": "\"allgemein: allgemein\"",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
2720,
7140
],
"id": "d917621e-7ce4-4628-86d1-cca4443cd2c5",
"name": "isEmailPrivat2"
},
{
"parameters": {
"options": {
"reset": false
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1140,
7140
],
"id": "e250de8c-a571-45c7-a89a-d6dbf9e3ce4f",
"name": "Loop Over Items4"
},
{
"parameters": {
"url": "https://google.serper.dev/search",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "={{ \n $('Loop Over Items').first().json['E-Mail'] \n ? $('Loop Over Items').first().json['E-Mail'].split(\"@\")[1] \n : '' \n}} {{ (() => {\n const raw = $('Loop Over Items').first().json?.Address || '';\n const match = raw.match(/\\b\\d{5}\\b/);\n return match ? match[0] : '';\n })() \n}} {{ $('Loop Over Items').first().json.Country }}\n"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "X-API-KEY",
"value": "4ff0d5d9bf4ba4ca7779a75c034f12fbf1fd8e92"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2880,
2460
],
"id": "7f9d8b44-c107-4834-b1e8-ad74f0055f74",
"name": "HTTP Request6"
},
{
"parameters": {
"promptType": "define",
"text": "=Company {{ \n $('Loop Over Items').first().json['E-Mail'] \n ? $('Loop Over Items').first().json['E-Mail'].split(\"@\")[1] \n : '' \n}} in {{ $('Loop Over Items').first().json['Form-Language'] }} {{ $('Loop Over Items').first().json.Country }} does {{ $json.output }} ",
"options": {
"systemMessage": "Du bist ein hochqualifizierter Firmenklassifizierer und Rechercheur mit Zugriff auf zuverl\u00e4ssige Datenquellen.\nDeine Aufgabe ist es, ein Unternehmen anhand des Firmennamens und einer kurzen T\u00e4tigkeitsbeschreibung kontextbezogen zu bewerten.\n\nZu ber\u00fccksichtigende Branchen\n\nAkustik (Raumakustik, Schalld\u00e4mmung, Beschallungstechnik, Audio)\nB\u00fcro (B\u00fcroplanung, B\u00fcrom\u00f6bel, B\u00fcro\u2011Trennw\u00e4nde, Drucker, Druckerverleih, B\u00fcrost\u00fchle, B\u00fcrotische, B\u00fcro\u2011IT)\nName als Indikator\n\nEgal, ob Dienstleistung, Produkt, Entwicklung, Verkauf, Vermietung oder Beratung \u2013 z\u00e4hlt nur, ob das Hauptgesch\u00e4ft ausschlie\u00dflich oder haupts\u00e4chlich in einer oder beiden dieser Branchen liegt.\n\nEnth\u00e4lt der Firmenname ausschlie\u00dflich Keywords aus Akustik oder B\u00fcrobranche (z.\u00a0B. \u201eB\u00fcroplaner GmbH\u201c, \u201eAkustikmeister GmbH\u201c), wertet das stark f\u00fcr 1.\nVerkn\u00fcpft der Name Zielbranchen mit anderen Bereichen (z.\u00a0B. \u201eAkustik und Fitnessger\u00e4te GmbH\u201c), gilt das als 0.\nFehlen im Namen Treffer, bewerte nur anhand der T\u00e4tigkeitsbeschreibung.\nEntscheidungsregeln\n\n1, wenn Name und/oder jede genannte T\u00e4tigkeit ausschlie\u00dflich oder \u00fcberwiegend zu Akustik und/oder B\u00fcro\u00adbranche geh\u00f6rt.\n0, sobald Name oder mindestens eine T\u00e4tigkeit klar nicht dazugeh\u00f6rt (z.\u00a0B. Schultische, Fu\u00dfballklamotten, Festivaltechnik).\n1, wenn T\u00e4tigkeiten unklar sind, aber eindeutige Keywords aus Zielbranchen vorliegen und der Name nicht widerspricht.\n0, wenn es sich lediglich um einen normalen M\u00f6belh\u00e4ndler ohne spezifischen B\u00fcro\u00adbezug handelt.\nWichtig\n\nVerstehe Zusammenh\u00e4nge: \u201eDruckerverleih\u201c z\u00e4hlt zu B\u00fcrobranche; \u201eSchultische\u201c nicht.\nBeurteile ganzheitlich: Name\u00a0+\u00a0Beschreibung m\u00fcssen passen.\nGib nur den Integer 0 oder 1 zur\u00fcck \u2013 keine Erkl\u00e4rungen, Kommentare oder zus\u00e4tzlichen Text.\nInput\n\u2013 Firmenname\n\u2013 T\u00e4tigkeitsbeschreibung (Liste, z.\u00a0B. \u201eB\u00fcrom\u00f6belverkauf, Druckerverleih, Raumakustik-Planung\u201c)\n\nOutput\n\n0\u00a0oder\u00a01"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.8,
"position": [
3440,
2460
],
"id": "f87b43c3-863f-42ba-8db8-a6d42e2652fe",
"name": "AI Agent2"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1135880709,
"mode": "list",
"cachedResultName": "RowsToDelete",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=1135880709"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"User-IP": "={{ $('Loop Over Items').first().json['User-IP'] }}",
"Date": "={{ $('Loop Over Items').first().json.Date }}",
"Time": "={{ $('Loop Over Items').first().json.Time }}",
"Form-Language": "={{ $('Loop Over Items').first().json['Form-Language'] }}",
"First name": "={{ $('Loop Over Items').first().json['First name'] }}",
"Salutation": "={{ $('Loop Over Items').first().json.Salutation }}",
"Name": "={{ $('Loop Over Items').first().json.Name }}",
"Company": "={{ $('Loop Over Items').first().json.Company }}",
"Address": "={{ $('Loop Over Items').first().json.Address }}",
"Country": "={{ $('Loop Over Items').first().json.Country }}",
"E-Mail": "={{ $('Loop Over Items').first().json['E-Mail'] }}",
"Newsletter": "={{ $('Loop Over Items').first().json.Newsletter }}",
"How did you become attentive on the pCon.planner": "={{ $('Loop Over Items').first().json['How did you become attentive on the pCon.planner'] }}",
"I use the pCon.planner as": "={{ $('Loop Over Items').first().json['I use the pCon.planner as'] }}",
"Version": "={{ $('Loop Over Items').first().json.Version }}",
"Edition": "={{ $('Loop Over Items').first().json.Edition }}",
"branche": "={{ $('AI Agent9').first().json.output }}"
},
"matchingColumns": [
"User-IP"
],
"schema": [
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Time",
"displayName": "Time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "User-IP",
"displayName": "User-IP",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Form-Language",
"displayName": "Form-Language",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Salutation",
"displayName": "Salutation",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "First name",
"displayName": "First name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Company",
"displayName": "Company",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Address",
"displayName": "Address",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Country",
"displayName": "Country",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "E-Mail",
"displayName": "E-Mail",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Newsletter",
"displayName": "Newsletter",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "How did you become attentive on the pCon.planner",
"displayName": "How did you become attentive on the pCon.planner",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "I use the pCon.planner as",
"displayName": "I use the pCon.planner as",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Version",
"displayName": "Version",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Edition",
"displayName": "Edition",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "branche",
"displayName": "branche",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
5280,
2460
],
"id": "b0723a9c-4f81-4079-845f-97225e006a00",
"name": "Google Sheets14",
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"promptType": "define",
"text": "=Company {{ \n $('Loop Over Items').first().json['E-Mail'] \n ? $('Loop Over Items').first().json['E-Mail'].split(\"@\")[1] \n : '' \n}} in {{ $('Loop Over Items').first().json['Form-Language'] }} {{ $('Loop Over Items').first().json.Country }}is a {{ $json.knowledgeGraph.type }} {{ $json.organic[0].snippet }} {{ $json.organic[2].snippet }} ",
"options": {
"systemMessage": "Du bist ein hochqualifizierter Firmenklassifizierer und Rechercheur mit Zugriff auf zuverl\u00e4ssige Datenquellen.\nDeine Aufgabe ist es, ein Unternehmen anhand des Firmennamens und einer kurzen T\u00e4tigkeitsbeschreibung pr\u00e4zise zu analysieren.\n\nAnleitung:\n\nNutze sowohl Firmennamen als auch T\u00e4tigkeitsbeschreibung, um die tats\u00e4chlichen Kernt\u00e4tigkeiten zu ermitteln.\nGib so viele der wichtigsten T\u00e4tigkeiten aus, wie tats\u00e4chlich vorhanden sind (mindestens\u00a02, maximal\u00a05).\nFormuliere jede T\u00e4tigkeit als Stichpunkt mit 3\u20135 W\u00f6rtern.\nKeine Branchenbezeichnungen, Einordnungen, Erkl\u00e4rungen oder Zusatzinfos.\nKeine Wiederholungen oder Synonyme.\nDie Ausgabe ist eine durch Kommas getrennte Liste der Stichpunkte.\nBeispielausgaben:\n\n\u201eB\u00fcrom\u00f6belverkauf, Festivalorganisation, H\u00f6rger\u00e4teanpassung, Grafikdesign, Immobilienvermittlung\u201c\n\u201eH\u00f6rger\u00e4teberatung, Schalld\u00e4mmungssysteme, Konferenzmikrofontechnik\u201c\n\u201eErgonomische B\u00fcrost\u00fchle, Akustikdeckenmontage, Schulm\u00f6belproduktion\u201c"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.8,
"position": [
3080,
2460
],
"id": "67e7f9e0-e434-427e-9fc4-c8a20c5668a2",
"name": "AI Agent9"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "df41ef12-68ad-48d2-9ab4-6a7423818213",
"leftValue": "={{ $('AI Agent2').first().json.output }}",
"rightValue": "1",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
3780,
2460
],
"id": "25f17e42-b286-40f3-b48c-b1e8350f34b1",
"name": "If9"
},
{
"parameters": {
"model": {
"__rl": true,
"value": "gpt-4o-mini",
"mode": "list",
"cachedResultName": "gpt-4o-mini"
},
"options": {
"temperature": 0
}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1.2,
"position": [
3940,
6980
],
"id": "1adad5f7-e909-4e62-bf23-24da50e9633c",
"name": "OpenAI Chat Model3",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI",
"mode": "list",
"cachedResultName": "K&S-Automation-Test",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 211066673,
"mode": "list",
"cachedResultName": "Tabellenblatt1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-pxibGJvkT5mVrD1Mb1Xj-0Bt56ZXj8pQST5LNq4pTI/edit#gid=211066673"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"row_number": "={{ $('Loop Over Items4').first().json.row_number}}",
"CompanyPhone": "={{ JSON.stringify($('AI Agent10').first().json.output) }}"
},
"matchingColumns": [
"row_number"
],
"schema": [
{
"id": "Date",
"displayName": "Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Time",
"displayName": "Time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "User-IP",
"displayName": "User-IP",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Form-Language",
"displayName": "Form-Language",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Salutation",
"displayName": "Salutation",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "First name",
"displayName": "First name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Name",
"displayName": "Name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Company",
"displayName": "Company",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Address",
"displayName": "Address",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Country",
"displayName": "Country",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "E-Mail",
"displayName": "E-Mail",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Newsletter",
"displayName": "Newsletter",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "How did you become attentive on the pCon.planner",
"displayName": "How did you become attentive on the pCon.planner",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "I use the pCon.planner as",
"displayName": "I use the pCon.planner as",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Version",
"displayName": "Version",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Edition",
"displayName": "Edition",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "CompanyPhone",
"displayName": "CompanyPhone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApiimapopenAiApismtp
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow streamlines the extraction and processing of download lists from K&S Media into a SQL-compatible format, saving hours of manual data handling for marketing teams or content managers dealing with bulk media files. It automates fetching lists via HTTP requests, intelligently categorising entries using an AI agent powered by OpenAI, and exporting the refined data to Google Sheets for easy review and database import. The key step involves the AI-driven loop that analyses and cleans each item in the list, ensuring accuracy without constant oversight.
Use this workflow when you need to regularly pull and organise K&S Media download lists for inventory tracking or campaign planning, especially if your team handles high volumes of files. Avoid it for one-off tasks or non-media sources, as the 97-node complexity suits recurring, event-driven automation rather than simple queries. Common variations include adding email notifications for completion or integrating IMAP to trigger from incoming alerts.
About this workflow
K&S-Media Downloadliste SQL. Uses httpRequest, agent, googleSheets, lmChatOpenAi. Event-driven trigger; 97 nodes.
Source: https://github.com/denred-594/n8n/blob/430ecac6da8d404147ff14f7e80e18f788844c78/local-ai-packaged/n8n/backup/workflows/K_S_Media_Downloadliste_SQL.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Door-to-door HVAC companies seeking automated lead capture and appointment scheduling.
Form Trigger, Google Sheets, Agent +7
Accounting and bookkeeping firms needing automated invoice creation and payment reminders.
Stripe Trigger, Agent, OpenAI Chat +6
Ce template permet de transformer un document (PDF, TXT, DocX...) en post LinkedIn engageant, prêt à être publié ou validé par email, le tout avec l’aide d’une IA spécialisée en copywriting LinkedIn.
Form Trigger, Agent, OpenAI Chat +5
🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.
OpenAI, HTTP Request, Form Trigger +7
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.
@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9