AI-Chat-Assistent: Automatisches Speichern lokaler Unternehmensdaten in Airtable mit Dumpling AI + GPT-4o

Name: AI-Chat-Assistent: Automatisches Speichern lokaler Unternehmensdaten in Airtable mit Dumpling AI + GPT-4o
Rating: 4.5 (10 reviews)
Author: Yang

Fortgeschritten

Dies ist ein Sales, AI, Marketing-Bereich Automatisierungsworkflow mit 8 Nodes. Hauptsächlich werden AirtableTool, Agent, ChatTrigger, LmChatOpenAi, ToolHttpRequest und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. AI-Chat-Assistent: Automatisches Speichern lokaler Geschäftsdaten in Airtable mit Dumpling AI + GPT-4o

Voraussetzungen

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

Verwendete Nodes (8)

Kategorie

Vertrieb

Künstliche Intelligenz

Marketing

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Wenn Chat-Nachricht empfangen

Nachrichten-Agent

Agent zur lokalen Unternehmenssuche

Letzte 10 Nachrichten verfolgen

KI-Aufgaben mit Dumpling + GPT + Speicher weiterleiten

Eingabe mit GPT-4o Mini verarbeiten

Unternehmensergebnisse speichern

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "MyJ84ASqWdHGYuy0",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "AI Chat Agent: Dumpling AI + GPT-4o to Auto-Save Local Business Data to Airtable",
  "tags": [
    {
      "id": "TlcNkmb96fUfZ2eA",
      "name": "Tutorials",
      "createdAt": "2025-04-15T17:02:00.249Z",
      "updatedAt": "2025-04-15T17:02:00.249Z"
    }
  ],
  "nodes": [
    {
      "id": "1617006d-20d8-44da-8410-1fbbd6bc317e",
      "name": "Wenn Chat-Nachricht empfangen",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -480,
        -40
      ],
      "webhookId": "13e55a07-d144-403b-b465-2a539501b207",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "ccb3073d-4c39-44bf-bd7f-05a6ae0550cb",
      "name": "Notizzettel",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        -220
      ],
      "parameters": {
        "width": 660,
        "height": 900,
        "content": "#### 🧠 Workflow Purpose\nAn interactive chat assistant that listens for incoming messages, processes them with AI, and uses Dumpling AI to fetch external information or complete tasks — with memory tracking.\n\n## 🔄 Workflow Steps\n\n### 1. Chat Trigger\n- Listens for chat messages (e.g., from a web app or messaging platform).\n\n### 2. OpenAI Chat Model\n- Processes the user's input using GPT-4o mini.\n\n### 3. Simple Memory Buffer\n- Keeps context from the last 10 exchanges to maintain a conversational flow.\n\n### 4. DumplingAI- News Agent and Local Business Finder Agent\n- Makes an external API call to Dumpling AI’s agent endpoint to search or generate responses based on user intent.\n\n### 5. AI Agent Node\n- Connects all components: language model, memory, and external tools.\n\n### 6. Airtable Tool – Dynamic Business Data Storage\n\n-This Airtable node auto-populates and updates a “Local Business” table using data returned from Dumpling AI’s Local Business Finder Agent. It maps essential fields such as:\n\n\n## ⚙️ Notes\n- Dumpling AI agent ID is pre-configured.\n- JSON response from Dumpling is parsed as usable data.\n- You can add routing or fallback logic based on Dumpling's results.\n\n##### 💡 Tip\nTo customize it for a specific domain (e.g., real estate, restaurant finder, course assistant), adjust the agent prompt or plug in a domain-specific tool module.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "266e0454-5133-4287-a449-2eb1d3d00485",
      "name": "Nachrichten-Agent",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        -20,
        180
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/agents/generate-completion",
        "method": "POST",
        "jsonBody": "={\n  \"messages\": [\n    {\n      \"role\": \"user\",\n      \"content\":\"{{ $json.chatInput}}\"\n    }\n  ],\n  \"agentId\": \"\",\n  \"parseJson\": \"True\"\n  }",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "optimizeResponse": true
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "xamyMqCpAech5BeT",
          "name": "Header Auth account"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "b3d834d7-eeb5-4ce8-bb45-2d6b58f8c0a9",
      "name": "Agent zur lokalen Unternehmenssuche",
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest",
      "position": [
        100,
        180
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/agents/generate-completion",
        "method": "POST",
        "jsonBody": "={\n  \"messages\": [\n    {\n      \"role\": \"user\",\n      \"content\":\"{{ $json.chatInput}}\"\n    }\n  ],\n  \"agentId\": \"\",\n  \"parseJson\": \"false\"\n  }",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "optimizeResponse": true
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "xamyMqCpAech5BeT",
          "name": "Header Auth account"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "bc75a2b5-8d99-487a-a9fc-12045b555207",
      "name": "Letzte 10 Nachrichten verfolgen",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -160,
        180
      ],
      "parameters": {
        "contextWindowLength": 10
      },
      "typeVersion": 1.3
    },
    {
      "id": "0eb2b921-360e-4043-8a2f-301d10113dfc",
      "name": "KI-Aufgaben mit Dumpling + GPT + Speicher weiterleiten",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -108,
        -40
      ],
      "parameters": {
        "options": {
          "systemMessage": "You are a helpful assistant\nUse the Local Business Finder Agent HTTP request tool to find local business\n\nUse the News agent HTTP request tool to get get news\n\nUse the Create and update Airtable tool to send results from the Local Business Finder Agent HTTP request tool"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "948fafa9-6b4c-4656-b27f-ce5b1eb0d363",
      "name": "Eingabe mit GPT-4o Mini verarbeiten",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -320,
        180
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "gY2Jp4ypzmjcwwV6",
          "name": "n8n free OpenAI API credits"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "4a07cedd-f40e-4123-a894-c53da751263f",
      "name": "Unternehmensergebnisse speichern",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        240,
        180
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC",
          "cachedResultName": "Testing n8n"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC/tblgxhdRFc2fGLV9o",
          "cachedResultName": "Local business"
        },
        "columns": {
          "value": {
            "id": "=",
            "Rating": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Rating', ``, 'number') }}",
            "Address": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Address', ``, 'string') }}",
            "Website": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Website', ``, 'string') }}",
            "Category": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Category', ``, 'string') }}",
            "Phone Number": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Phone_Number', ``, 'string') }}",
            "Total Reviews": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Total_Reviews', ``, 'number') }}",
            "Name of Restaurant": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Name_of_Restaurant', ``, 'string') }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "id",
              "defaultMatch": true
            },
            {
              "id": "Name of Restaurant",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Name of Restaurant",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Rating",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Rating",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Total Reviews",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Total Reviews",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Address",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone Number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Phone Number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Category",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Category",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "upsert"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "H8PVkBgUPCcUhhRC",
          "name": "Airtable Personal Access Token account"
        }
      },
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "57c6329e-df0b-4eb4-9837-643c7de85e5e",
  "connections": {
    "266e0454-5133-4287-a449-2eb1d3d00485": {
      "ai_tool": [
        [
          {
            "node": "0eb2b921-360e-4043-8a2f-301d10113dfc",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "4a07cedd-f40e-4123-a894-c53da751263f": {
      "ai_tool": [
        [
          {
            "node": "0eb2b921-360e-4043-8a2f-301d10113dfc",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "bc75a2b5-8d99-487a-a9fc-12045b555207": {
      "ai_memory": [
        [
          {
            "node": "0eb2b921-360e-4043-8a2f-301d10113dfc",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "1617006d-20d8-44da-8410-1fbbd6bc317e": {
      "main": [
        [
          {
            "node": "0eb2b921-360e-4043-8a2f-301d10113dfc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b3d834d7-eeb5-4ce8-bb45-2d6b58f8c0a9": {
      "ai_tool": [
        [
          {
            "node": "0eb2b921-360e-4043-8a2f-301d10113dfc",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "948fafa9-6b4c-4656-b27f-ce5b1eb0d363": {
      "ai_languageModel": [
        [
          {
            "node": "0eb2b921-360e-4043-8a2f-301d10113dfc",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "0eb2b921-360e-4043-8a2f-301d10113dfc": {
      "main": [
        []
      ]
    }
  }
}

Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Vertrieb, Künstliche Intelligenz, Marketing

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.