8
n8n Françaisamn8n.com

(G) Chatbot LINE + Google Sheets (comme mémoire)

Avancé

Ceci est unAIworkflow d'automatisation du domainecontenant 17 nœuds.Utilise principalement des nœuds comme Set, Code, Webhook, HttpRequest, GoogleSheets, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Bot de chat LINE avec mémoire Google Sheets et IA Gemini

Prérequis
  • •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API
  • •Clé API Google Gemini

Nœuds utilisés (17)

Set
Code
Webhook
StickyNote
HttpRequest
GoogleSheets
Agent
LmChatGoogleGemini

Catégorie

Intelligence Artificielle
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "[CENSORED]",
  "meta": {
    "instanceId": "[CENSORED]",
    "templateCredsSetupCompleted": true
  },
  "name": "(G) LineChatBot + Google Sheets (as a memory)",
  "tags": [
    {
      "id": "[CENSORED]",
      "name": "Guitar",
      "createdAt": "2025-04-18T08:59:48.308Z",
      "updatedAt": "2025-04-18T08:59:48.308Z"
    }
  ],
  "nodes": [
    {
      "id": "[CENSORED]",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        560,
        -500
      ],
      "webhookId": "[CENSORED]",
      "parameters": {
        "path": "guitarpa",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "[CENSORED]",
      "name": "Agent IA",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        460,
        -220
      ],
      "parameters": {
        "text": "={{ $json.Prompt }}",
        "options": {
          "systemMessage": "=You are a helpful assistant. Your name is \"ลลิตา\". You will help me in everything I need. You will answer based on user language. You are an AI Agent operating in the Thailand time zone (Asia/Bangkok, UTC+7). Today is {{ $now }}."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.8
    },
    {
      "id": "[CENSORED]",
      "name": "Google Gemini Modèle de chat",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        460,
        -20
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.0-flash-001"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "[CENSORED]",
          "name": "Guitar's Gemini ([CENSORED_EMAIL])"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Modifier les champs",
      "type": "n8n-nodes-base.set",
      "position": [
        780,
        -500
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "[CENSORED]",
              "name": "body.events[0].message.text",
              "type": "string",
              "value": "={{ $('Webhook').item.json.body.events[0].message.text }}"
            },
            {
              "id": "[CENSORED]",
              "name": "body.events[0].replyToken",
              "type": "string",
              "value": "={{ $('Webhook').item.json.body.events[0].replyToken }}"
            },
            {
              "id": "[CENSORED]",
              "name": "body.events[0].source.userId",
              "type": "string",
              "value": "={{ $json.body.events[0].source.userId }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "[CENSORED]",
      "name": "HTTP Requête",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1276,
        -220
      ],
      "parameters": {
        "url": "https://api.line.me/v2/bot/message/reply",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n    \"replyToken\": \"{{ $('Edit Fields').item.json.body.events[0].replyToken }}\",\n    \"messages\": [\n        {\n            \"type\": \"text\",\n            \"text\": \"{{ $('AI Agent').item.json.output.replaceAll('\\t', ' ').replaceAll('\\\"', '\\\\\\\"').replaceAll('\\n', '\\\\n').trim() || 'No response available.' }}\"\n        }\n    ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer [CENSORED]"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "[CENSORED]",
      "name": "Obtenir l'historique",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1000,
        -500
      ],
      "parameters": {
        "options": {
          "outputFormatting": {
            "values": {
              "date": "FORMATTED_STRING",
              "general": "UNFORMATTED_VALUE"
            }
          },
          "returnFirstMatch": true,
          "dataLocationOnSheet": {
            "values": {
              "rangeDefinition": "detectAutomatically"
            }
          }
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $('Webhook').item.json.body.events[0].source.userId }}",
              "lookupColumn": "UserID "
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "[CENSORED]",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "[CENSORED]"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "[CENSORED]",
          "name": "[Guitar] Google Sheets ([CENSORED_EMAIL])"
        }
      },
      "notesInFlow": false,
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "[CENSORED]",
      "name": "Préparer l'invite",
      "type": "n8n-nodes-base.set",
      "position": [
        1220,
        -500
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "[CENSORED]",
              "name": "Prompt",
              "type": "string",
              "value": "={{\n  \"คุณคือลลิตา แชทบอทภาษาไทยที่สุภาพและเป็นมิตร ตอบตามบริบทของการสนทนา:\\n\" +\n\n  ($('Get History').item.json.History_Archive_1 || \"\") +\n  (($('Get History').item.json.History_Archive_1) ? \"\\n\" : \"\") +\n\n  ($('Get History').item.json.History_Archive_2 || \"\") +\n  (($('Get History').item.json.History_Archive_2) ? \"\\n\" : \"\") +\n\n  ($('Get History').item.json.History_Archive_3 || \"\") +\n  (($('Get History').item.json.History_Archive_3) ? \"\\n\" : \"\") +\n\n  ($('Get History').item.json.History_Archive_4 || \"\") +\n  (($('Get History').item.json.History_Archive_4) ? \"\\n\" : \"\") +\n\n  ($('Get History').item.json.History || \"\") +\n  (($('Get History').item.json.History) ? \"\\n\" : \"\") +\n\n  \"ผู้ใช้: \" + $('Edit Fields').item.json.body.events[0].message.text + \"\\nลลิตา: \"\n}}\n"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "[CENSORED]",
      "name": "Sauvegarder l'historique",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1056,
        -220
      ],
      "parameters": {
        "columns": {
          "value": {
            "History": "={{ $('Split History').item.json.historyToSave }}",
            "UserID ": "={{ $('Edit Fields').item.json.body.events[0].source.userId }}",
            "LastUpdated": "={{ new Date().toISOString() }}",
            "History_Archive_1": "={{ $('Split History').item.json.historyArchive1 }}",
            "History_Archive_2": "={{ $('Split History').item.json.historyArchive2 }}",
            "History_Archive_3": "={{ $('Split History').item.json.historyArchive3 }}",
            "History_Archive_4": "={{ $('Split History').item.json.historyArchive4 }}"
          },
          "schema": [
            {
              "id": "UserID ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "UserID ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "History",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "History",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LastUpdated",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "LastUpdated",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "History_Archive_1",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "History_Archive_1",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "History_Archive_2",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "History_Archive_2",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "History_Archive_3",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "History_Archive_3",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "History_Archive_4",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "History_Archive_4",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "UserID "
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "[CENSORED]",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "[CENSORED]"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "[CENSORED]",
          "name": "[Guitar] Google Sheets ([CENSORED_EMAIL])"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        -560
      ],
      "parameters": {
        "content": "### Connect to Line Official Account's API"
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        740,
        -560
      ],
      "parameters": {
        "width": 180,
        "content": "Prepare the data"
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -560
      ],
      "parameters": {
        "width": 180,
        "content": "Retrieve chat history"
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        -560
      ],
      "parameters": {
        "width": 180,
        "content": "Give our AI previous chat history"
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        -280
      ],
      "parameters": {
        "content": "Get input with this command.   \"{{ $json.Prompt }}\""
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        780,
        -280
      ],
      "parameters": {
        "width": 180,
        "content": "Split history into small chunks (data cleaning)"
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Diviser l'historique",
      "type": "n8n-nodes-base.code",
      "position": [
        840,
        -220
      ],
      "parameters": {
        "jsCode": "// Get the current history, new message, and response\nlet history = $('Get History').item.json.History || '';\nlet message = $('Edit Fields').item.json.body.events[0].message.text;\nlet response = $json.output;\nlet newExchange = `ผู้ใช้: ${message}\\nลลิตา: ${response}`;\nlet updatedHistory = history + (history ? '\\n' : '') + newExchange;\n\n// Threshold: 70% of Google Sheets cell limit (50,000 characters * 0.7 = 35,000)\nconst threshold = 35000;\nlet historyToSave = updatedHistory;\nlet archive1 = $('Get History').item.json.History_Archive_1 || '';\nlet archive2 = $('Get History').item.json.History_Archive_2 || '';\nlet archive3 = $('Get History').item.json.History_Archive_3 || '';\nlet archive4 = $('Get History').item.json.History_Archive_4 || '';\n\n// If history exceeds threshold, split it\nif (updatedHistory.length > threshold) {\n  // Keep the last 17,500 characters in History (half of threshold for balance)\n  const keepLength = 17500;\n  const archiveChunk = updatedHistory.substring(0, updatedHistory.length - keepLength);\n  historyToSave = updatedHistory.substring(updatedHistory.length - keepLength);\n\n  // Distribute to archive cells, ensuring none exceed 35,000 characters\n  if (archive1.length < threshold) {\n    archive1 = (archive1 ? archive1 + '\\n' : '') + archiveChunk;\n    if (archive1.length > threshold) {\n      const excess = archive1.substring(threshold);\n      archive1 = archive1.substring(0, threshold);\n      if (archive2.length < threshold) {\n        archive2 = (archive2 ? archive2 + '\\n' : '') + excess;\n      }\n    }\n  }\n  if (archive2.length < threshold && archive1.length >= threshold) {\n    archive2 = (archive2 ? archive2 + '\\n' : '') + archiveChunk;\n    if (archive2.length > threshold) {\n      const excess = archive2.substring(threshold);\n      archive2 = archive2.substring(0, threshold);\n      if (archive3.length < threshold) {\n        archive3 = (archive3 ? archive3 + '\\n' : '') + excess;\n      }\n    }\n  }\n  if (archive3.length < threshold && archive2.length >= threshold) {\n    archive3 = (archive3 ? archive3 + '\\n' : '') + archiveChunk;\n    if (archive3.length > threshold) {\n      const excess = archive3.substring(threshold);\n      archive3 = archive3.substring(0, threshold);\n      if (archive4.length < threshold) {\n        archive4 = (archive4 ? archive4 + '\\n' : '') + excess;\n      }\n    }\n  }\n  if (archive4.length < threshold && archive3.length >= threshold) {\n    archive4 = (archive4 ? archive4 + '\\n' : '') + archiveChunk;\n    if (archive4.length > threshold) {\n      archive4 = archive4.substring(0, threshold);\n    }\n  }\n}\n\n// Return the values to update\nreturn [\n  {\n    json: {\n      historyToSave: historyToSave,\n      historyArchive1: archive1,\n      historyArchive2: archive2,\n      historyArchive3: archive3,\n      historyArchive4: archive4,\n      lastUpdated: new Date().toISOString()\n    }\n  }\n];"
      },
      "typeVersion": 2
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1000,
        -280
      ],
      "parameters": {
        "width": 180,
        "content": "Save to Google Sheets"
      },
      "typeVersion": 1
    },
    {
      "id": "[CENSORED]",
      "name": "Note adhésive7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1220,
        -280
      ],
      "parameters": {
        "width": 180,
        "content": "Send it back to Line"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "[CENSORED]",
  "connections": {
    "[CENSORED]": {
      "ai_languageModel": [
        [
          {
            "node": "[CENSORED]",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Intelligence Artificielle

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

AI房地产经纪人：端à端运营automatisation（网络、données、语音）
AI房地产经纪人：端à端运营automatisation（网络、données、语音）
If
Set
Code
+
If
Set
Code
45 NœudsSam Yassine
Ventes
ERPNext AI候选人筛选automatisation
ERPNextdeAI驱动候选人筛选automatisation
If
Set
Code
+
If
Set
Code
39 NœudsAmjid Ali
Finance
Scraper la bibliothèque d'annonces Meta et analyser les publicités vidéo avec Gemini, stocker les données dans Google Sheets
Utiliser Gemini pour analyser les publicités vidéo de la bibliothèque publicitaire Meta, et stocker les résultats dans Google Sheets
Set
Code
Sort
+
Set
Code
Sort
24 NœudsDaniel Setzermann
Intelligence Artificielle
Traitement des flux RSS de LinkedIn avec l'IA
Utiliser Gemini AI et des sources RSS pour automatiser la publication d'actualités LinkedIn
If
Set
Code
+
If
Set
Code
43 NœudsClub de Inteligencia Artificial Politécnico CIAP
Intelligence Artificielle
Publication automatisée de contenu RSS de blog avec GPT-4o, WordPress et LinkedIn
Publication automatisée de contenu RSS en articles de blog avec GPT-4o, WordPress et LinkedIn
If
Set
Code
+
If
Set
Code
40 NœudsImmanuel
Intelligence Artificielle
Construire un assistant de support IT IA intégrant Azure Search, Entra ID et Jira
Construire un assistant IT d'IA intégrant la recherche Azure, Entra ID et Jira
Set
Code
Webhook
+
Set
Code
Webhook
30 NœudsAdam Bertram
Support
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds17
Catégorie1
Types de nœuds8
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
Jakkrapat Ampring

Jakkrapat Ampring

@guitarpmacc

Working as a marketer in a bilingual school in Phuket with no coding background. I am a lazy person so I constantly looking for a way to make me work less. Been learning about AI stuff for around 2 years now.

Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34