CRM の連絡先を取得するための Telegram ボット
上級
これは自動化ワークフローで、27個のノードを含みます。主にIf, Set, Code, Merge, Cryptoなどのノードを使用。 TelegramとGemini AIを使ってCRM連絡先をキャプチャーし保存
前提条件
- •Telegram Bot Token
- •Google Sheets API認証情報
- •Google Gemini API Key
使用ノード (27)
カテゴリー
-
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "KmdYybT84NNAa1yM",
"meta": {
"instanceId": "fc8c505a7d97c0ad5142b508476a4b135c5d385dc29af946d69365fb9717edee",
"templateCredsSetupCompleted": true
},
"name": "Telegram bot for capturing CRM contacts",
"tags": [
{
"id": "0fVOYNM7WPnd6GTh",
"name": "public",
"createdAt": "2025-10-14T10:25:40.579Z",
"updatedAt": "2025-10-14T10:25:40.579Z"
}
],
"nodes": [
{
"id": "baf521e1-ad2c-40cf-bdd6-78c1872987d7",
"name": "Telegram Trigger",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-720,
-48
],
"webhookId": "054bbadb-2087-44d6-bb77-35b446394037",
"parameters": {
"updates": [
"message"
],
"additionalFields": {
"download": true,
"imageSize": "large"
}
},
"credentials": {
"telegramApi": {
"id": "LeL8GGIOucbE798n",
"name": "n8n_crm_bot"
}
},
"typeVersion": 1.2
},
{
"id": "acd4c00f-ab7d-4c20-925f-7f8e827bbf17",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-832,
368
],
"parameters": {
"width": 816,
"height": 800,
"content": "## Telegram bot for capturing contacts\n\nThis workflow is an AI agent in the form of a Telegram bot. Its main purpose is to **capture contact information and store it in a CRM**. The agent supports multi-modal inputs and can extract contact details from text messages, voice recordings, and images (like photos of business cards).\n\nThe bot guides the user through data collection via a natural conversation, asks clarifying questions for missing information, and summarizes the extracted data for confirmation before saving. It also checks for duplicate contacts by email and gives users the choice to either create a new contact or update an existing one.\n\nFor simplicity, this example uses a Google Sheets document to store collected contacts. It can easily be replaced by a real CRM like HubSpot, Pipedrive, Monday, etc.\n\n### How to use the bot\n\nSend contact details via text or voice, or upload a photo of a business card. The bot will show the extracted information and ask questions when needed. Once the bot confirms saving of the current contact, you can send the next one. Use the `/new` command at any moment to discard the previous conversation and start from scratch.\n\n### Requirements\n1. A Telegram bot [Access Token](https://docs.n8n.io/integrations/builtin/credentials/telegram/)\n2. Google Gemini API key\n3. Google Sheets credentials\n\n### Setup\n1. Create a new Telegram bot (see [n8n docs](https://docs.n8n.io/integrations/builtin/credentials/telegram/#using-api-bot-access-token) and [Telegram bot API docs](https://core.telegram.org/bots/features) for details)\n2. Take webhook URL from the Telegram Trigger node (`WEBHOOK_URL`) and your bot's access token (`TOKEN`) and run `curl -X POST \"https://api.telegram.org/bot{TOKEN}/setWebhook?url={WEBHOOK_URL}\"`\n2. Create a new Google Sheets document with \"Full name\", \"Email\", \"Phone\", \"Company\", \"Job title\" and \"Meeting notes\" columns\n3. Configure parameters in the **parameters** node:\n - Set ID of the Google Sheets document\n - Set sheet name (\"Sheet1\" by default)\n4. Configure Google Sheets credentials for AI Agent's tools: **Search for contact** and **Create new contact** and **Update existing contact**.\n5. Add Google Gemini API key for the models (\"AI Agent\", \"Transcribe audio\", \"Analyze image\" nodes)"
},
"typeVersion": 1
},
{
"id": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
384,
1168
],
"parameters": {
"text": "={{ $json.userMessage }}",
"options": {
"systemMessage": "You are a helpful personal assistant. You are direct and don't talk much.\nYour job is to create and update contacts in the CRM system. User communicates with you via text, audio (transcribed) and images (recognized).\n\nIt is mandatory to extract the following information:\n- first name\n- last name\n- email\n- company name\n\nWhenever possible extract as well:\n- phone number \n- job title\n- meeting notes\n\nYou may ask up to 3 questions about each new contact. Always confirm extracted information using the following format.\n\nExample of confirmation when all mandatory data is extracted, but there are no meeting notes:\n\"\"\"\n✅ First name: {first_name}\n✅ Last name: {last_name}\n✅ Email: {email}\n✅ Company: {company}\n\nDo you have any other info or meeting notes?\n\"\"\"\n\nExample of confirmation when some data is missing:\n\"\"\"\n✅ First name: {first_name}\n❓ Last name:\n✅ Email: {email}\n❓ Company:\n\nDo you know the last name and the company name?\n\"\"\"\n\nExample of confirmation when all mandatory data, as well as some extra data and meeting notes are extracted:\n\"\"\"\n✅ First name: {first_name}\n✅ Last name: {last_name}\n✅ Email: {email}\n✅ Company: {company}\n✅ Title: {job_title}\n✅ Phone: {phone}\n\nDo you have any other info?\n\"\"\"\n\nOnce all the information for a contact is collected, search the CRM for an existing contact by email. If the contact is not found, create a new contact. If the contact exists, ask user whether to create a new contact or update the existing one.\n\nIMPORTANT:\nIf phone number begins with \"+\", prepend it with \"'\" (single quote symbol) when saving. The CRM expects the phone in this format. \n\nUser may send `/new` command which indicates beginning of a fresh chat session. In this case simply confirm that you are waiting for a new contact."
},
"promptType": "define"
},
"typeVersion": 2.2
},
{
"id": "791fd96b-9808-4573-af52-226695245cf5",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
192,
1392
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "0C0iIvVLweHKZMa6",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "c3feefb6-c757-42aa-b78a-af8cc1b8026c",
"name": "テキストメッセージを送信",
"type": "n8n-nodes-base.telegram",
"position": [
1104,
1168
],
"webhookId": "b043688f-41dd-4310-96d6-115cabe763f7",
"parameters": {
"text": "={{ $json.output }}",
"chatId": "={{ $('Telegram Trigger').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "LeL8GGIOucbE798n",
"name": "n8n_crm_bot"
}
},
"typeVersion": 1.2
},
{
"id": "510e5fa0-1ab1-44be-9338-12ceef3474bb",
"name": "sessionIDを取得",
"type": "n8n-nodes-base.dataTable",
"position": [
192,
-208
],
"parameters": {
"limit": 1,
"filters": {
"conditions": [
{
"keyName": "chatID",
"keyValue": "={{ $json.message.chat.id }}"
}
]
},
"matchType": "allConditions",
"operation": "get",
"dataTableId": {
"__rl": true,
"mode": "list",
"value": "Y6od4eTrxRkUbtyC",
"cachedResultUrl": "/projects/ZnaXyIe6Nbrn9Af2/datatables/Y6od4eTrxRkUbtyC",
"cachedResultName": "telegram-crm-example"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "d320aae4-14ec-4682-8b79-3f320ca58c24",
"name": "sessionIDを生成",
"type": "n8n-nodes-base.crypto",
"position": [
752,
-208
],
"parameters": {
"action": "generate",
"dataPropertyName": "sessionID"
},
"typeVersion": 1
},
{
"id": "96f9ff1d-c25a-471e-ab11-ac6985ac61c0",
"name": "行をUPSERT",
"type": "n8n-nodes-base.dataTable",
"position": [
1008,
-208
],
"parameters": {
"columns": {
"value": {
"chatID": "={{ $('Telegram Trigger').item.json.message.chat.id }}",
"sessionID": "={{ $json.sessionID }}"
},
"schema": [
{
"id": "chatID",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "chatID",
"defaultMatch": false
},
{
"id": "sessionID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "sessionID",
"defaultMatch": false
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"sessionID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"filters": {
"conditions": [
{
"keyName": "chatID",
"keyValue": "={{ $('Telegram Trigger').item.json.message.chat.id }}"
}
]
},
"matchType": "allConditions",
"operation": "upsert",
"dataTableId": {
"__rl": true,
"mode": "list",
"value": "Y6od4eTrxRkUbtyC",
"cachedResultUrl": "/projects/ZnaXyIe6Nbrn9Af2/datatables/Y6od4eTrxRkUbtyC",
"cachedResultName": "telegram-crm-example"
}
},
"typeVersion": 1
},
{
"id": "5f7ce514-bccc-414d-8337-1d051cf03538",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-304
],
"parameters": {
"color": 6,
"width": 1024,
"height": 256,
"content": "## Get existing sessionID or create a new one\nsessionID is used to store conversation history"
},
"typeVersion": 1
},
{
"id": "cd95f448-16aa-4746-b9bc-89966dbcd1c6",
"name": "sessionIDなしまたは/newの場合",
"type": "n8n-nodes-base.if",
"position": [
496,
-208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "aa9bdac4-3246-4a92-98ed-695640ff93d7",
"operator": {
"type": "object",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json }}",
"rightValue": ""
},
{
"id": "92c64c2d-5a97-4f07-a98d-b4035930bb56",
"operator": {
"type": "string",
"operation": "notExists",
"singleValue": true
},
"leftValue": "={{ $json.sessionID }}",
"rightValue": ""
},
{
"id": "b4e2e2b1-63de-4c57-9218-27bb29e3f18d",
"operator": {
"type": "string",
"operation": "startsWith"
},
"leftValue": "={{ $('Telegram Trigger').item.json.message.text }}",
"rightValue": "/new"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5281020e-eb31-426c-b123-eb4e1fb0df07",
"name": "Simple Memory",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
336,
1424
],
"parameters": {
"sessionKey": "={{ $('Add sessionID to input').item.json.sessionID }}",
"sessionIdType": "customKey",
"contextWindowLength": 10
},
"typeVersion": 1.3
},
{
"id": "a292b5ef-a1d7-48dd-b806-f6a154a1a8a9",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
432,
192
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "audio input",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c0814978-ad52-4537-bdfb-c83b83955df4",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.message.voice }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "image input",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "cc1fd7ef-c1cf-4682-8cad-65833275ff23",
"operator": {
"type": "array",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.message.photo }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "text input",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "aeff368c-421b-4823-aeec-dc4473d9ff76",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.message.text }}",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {
"fallbackOutput": "extra"
}
},
"typeVersion": 3.3
},
{
"id": "f0f58425-7e6c-4ec7-bd21-849dc6471e1e",
"name": "入力にsessionIDを追加",
"type": "n8n-nodes-base.merge",
"position": [
208,
224
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3.2
},
{
"id": "4661d734-4f58-412f-bb74-9789eb11feb6",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
48
],
"parameters": {
"color": 6,
"width": 992,
"height": 944,
"content": "## Process various types of user messages\n- Transcribe audio\n- Analyse image\n- Prepare text message"
},
"typeVersion": 1
},
{
"id": "532435f7-2ed0-4c4c-a783-cd3e2d7761d0",
"name": "parameters",
"type": "n8n-nodes-base.set",
"position": [
-192,
-48
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "8c23a9c4-8623-41b6-bbe0-e34f0d500611",
"name": "spreadsheet_document_id",
"type": "string",
"value": ""
},
{
"id": "309e133e-faa1-47d3-83f6-77f153da7239",
"name": "sheet_name",
"type": "string",
"value": "Sheet1"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "7ac77e30-faf2-4f88-bdee-0bf3e4fcbbe5",
"name": "新規連絡先を作成",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
656,
1488
],
"parameters": {
"columns": {
"value": {
"Email": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Email__using_to_match_', `Contact's email`, 'string') }}",
"Phone": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Phone', `Contact's phone number`, 'string') }}",
"Company": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Company', `Company name`, 'string') }}",
"Full name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Full_name', `Contact's full name (first name + last name)`, 'string') }}",
"Job title": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Job_title', `Contact's job title`, 'string') }}",
"Meeting notes": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Meeting_notes', `Notes from the meeting with contact`, 'string') }}"
},
"schema": [
{
"id": "Full name",
"type": "string",
"display": true,
"required": false,
"displayName": "Full name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job title",
"type": "string",
"display": true,
"required": false,
"displayName": "Job title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Meeting notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('parameters').item.json.sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('parameters').item.json.spreadsheet_document_id }}"
},
"authentication": "serviceAccount",
"descriptionType": "manual",
"toolDescription": "Create a new contact in CRM"
},
"credentials": {
"googleApi": {
"id": "fwodZhVNzRxPPDoX",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "005acc6f-eb10-47cf-a45f-c8fbe7e0ed01",
"name": "既存連絡先を更新",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
816,
1504
],
"parameters": {
"columns": {
"value": {
"Email": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Email__using_to_match_', `Contact's email`, 'string') }}",
"Phone": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Phone', `Contact's phone number`, 'string') }}",
"Company": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Company', `Company name`, 'string') }}",
"Full name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Full_name', `Contact's full name (first name + last name)`, 'string') }}",
"Job title": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Job_title', `Contact's job title`, 'string') }}",
"Meeting notes": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Meeting_notes', `Notes from the meeting with contact`, 'string') }}"
},
"schema": [
{
"id": "Full name",
"type": "string",
"display": true,
"required": false,
"displayName": "Full name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job title",
"type": "string",
"display": true,
"required": false,
"displayName": "Job title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Meeting notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('parameters').item.json.sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('parameters').item.json.spreadsheet_document_id }}"
},
"authentication": "serviceAccount",
"descriptionType": "manual",
"toolDescription": "Update existing contact in CRM"
},
"credentials": {
"googleApi": {
"id": "fwodZhVNzRxPPDoX",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "f842b387-64bb-4555-95aa-43deedb813cb",
"name": "連絡先を検索",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
496,
1456
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', `Contact's email`, 'string') }}",
"lookupColumn": "Email"
}
]
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('parameters').item.json.sheet_name }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('parameters').item.json.spreadsheet_document_id }}"
},
"authentication": "serviceAccount",
"descriptionType": "manual",
"toolDescription": "Search for an exisitng contact in CRM (by email)"
},
"credentials": {
"googleApi": {
"id": "fwodZhVNzRxPPDoX",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "9fbf58e9-4e04-4cdf-99b9-962cc1659232",
"name": "「入力中...」を送信",
"type": "n8n-nodes-base.telegram",
"position": [
-464,
-256
],
"webhookId": "9e763cc2-de3e-46be-920e-008b9ec3bc5c",
"parameters": {
"chatId": "={{ $('Telegram Trigger').item.json.message.chat.id }}",
"operation": "sendChatAction"
},
"credentials": {
"telegramApi": {
"id": "LeL8GGIOucbE798n",
"name": "n8n_crm_bot"
}
},
"typeVersion": 1.2
},
{
"id": "6f06a5e9-e54d-4333-b720-4234b95d7fd5",
"name": "音声ファイルを取得",
"type": "n8n-nodes-base.telegram",
"position": [
752,
352
],
"webhookId": "d89a5bcf-29c4-47c9-856b-6bd2e05a4af4",
"parameters": {
"fileId": "={{ $json.message.voice.file_id }}",
"resource": "file",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "LeL8GGIOucbE798n",
"name": "n8n_crm_bot"
}
},
"typeVersion": 1.2
},
{
"id": "804bfa01-8a62-46ed-b86b-c3c21776acdf",
"name": "音声を文字起こし",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
960,
352
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "models/gemini-2.5-flash",
"cachedResultName": "models/gemini-2.5-flash"
},
"options": {},
"resource": "audio",
"inputType": "binary"
},
"credentials": {
"googlePalmApi": {
"id": "0C0iIvVLweHKZMa6",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "06564c94-911c-42bc-86a0-9562d02469e4",
"name": "音声文字起こしを処理",
"type": "n8n-nodes-base.code",
"position": [
1168,
352
],
"parameters": {
"jsCode": "let new_items = []\nlet index = 0\nfor (const item of $input.all()) {\n let userMessage = \"<transcribed_audio>\" + item.json.content.parts[0].text + \"</transcribed_audio>\";\n \n new_items.push({\n \"userMessage\": userMessage\n })\n\n index += 1;\n}\n\nreturn new_items;"
},
"typeVersion": 2
},
{
"id": "5b0e9ade-60c3-46a6-a00f-2d7183750fb1",
"name": "画像を分析",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
752,
576
],
"parameters": {
"text": "Extract contact information from this image. Look for the following information:\n- first name\n- last name\n- email\n- phone number\n- company name\n- job title",
"modelId": {
"__rl": true,
"mode": "list",
"value": "models/gemini-2.5-flash",
"cachedResultName": "models/gemini-2.5-flash"
},
"options": {},
"resource": "image",
"simplify": false,
"inputType": "binary",
"operation": "analyze"
},
"credentials": {
"googlePalmApi": {
"id": "0C0iIvVLweHKZMa6",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "192ac754-ad6c-46c6-9e93-12833cb00751",
"name": "抽出データを処理",
"type": "n8n-nodes-base.code",
"position": [
960,
576
],
"parameters": {
"jsCode": "let new_items = []\nlet index = 0\nfor (const item of $input.all()) {\n let userMessage = \"<extracted_image_content>\" + item.json.candidates[0].content.parts[0].text + \"</extracted_image_content>\";\n let text = $('Switch').itemMatching(index).json.message.caption\n if (text) {\n userMessage += \"\\n\" + text;\n }\n \n new_items.push({\n \"userMessage\": userMessage\n })\n\n index += 1;\n}\n\nreturn new_items;"
},
"typeVersion": 2
},
{
"id": "dba4133a-dd92-4a4f-9170-0b14af98a63d",
"name": "テキスト入力を処理",
"type": "n8n-nodes-base.code",
"position": [
752,
784
],
"parameters": {
"jsCode": "let new_items = []\nfor (const item of $input.all()) {\n let userMessage = item.json.message.text;\n \n new_items.push({\n \"userMessage\": userMessage\n })\n}\n\nreturn new_items;"
},
"typeVersion": 2
},
{
"id": "2fce79a3-9119-41cc-835a-fe8fb04af738",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-272,
-160
],
"parameters": {
"color": 5,
"width": 256,
"height": 272,
"content": "## Configure\n➤ set spreadsheet document ID\n➤ set sheet name"
},
"typeVersion": 1
},
{
"id": "085c7e80-bd92-4f6b-ad39-b5a6ee2f13ed",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
128,
1072
],
"parameters": {
"color": 6,
"width": 832,
"height": 608,
"content": "## AI Agent"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d978e1d6-316e-41a6-b579-25d8332e4053",
"connections": {
"a292b5ef-a1d7-48dd-b806-f6a154a1a8a9": {
"main": [
[
{
"node": "6f06a5e9-e54d-4333-b720-4234b95d7fd5",
"type": "main",
"index": 0
}
],
[
{
"node": "5b0e9ade-60c3-46a6-a00f-2d7183750fb1",
"type": "main",
"index": 0
}
],
[
{
"node": "dba4133a-dd92-4a4f-9170-0b14af98a63d",
"type": "main",
"index": 0
}
]
]
},
"62ece471-e4b4-4ed8-ae54-338a6acd02e4": {
"main": [
[
{
"node": "c3feefb6-c757-42aa-b78a-af8cc1b8026c",
"type": "main",
"index": 0
}
]
]
},
"532435f7-2ed0-4c4c-a783-cd3e2d7761d0": {
"main": [
[
{
"node": "f0f58425-7e6c-4ec7-bd21-849dc6471e1e",
"type": "main",
"index": 1
},
{
"node": "510e5fa0-1ab1-44be-9338-12ceef3474bb",
"type": "main",
"index": 0
}
]
]
},
"5b0e9ade-60c3-46a6-a00f-2d7183750fb1": {
"main": [
[
{
"node": "192ac754-ad6c-46c6-9e93-12833cb00751",
"type": "main",
"index": 0
}
]
]
},
"510e5fa0-1ab1-44be-9338-12ceef3474bb": {
"main": [
[
{
"node": "cd95f448-16aa-4746-b9bc-89966dbcd1c6",
"type": "main",
"index": 0
}
]
]
},
"5281020e-eb31-426c-b123-eb4e1fb0df07": {
"ai_memory": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "ai_memory",
"index": 0
}
]
]
},
"96f9ff1d-c25a-471e-ab11-ac6985ac61c0": {
"main": [
[
{
"node": "f0f58425-7e6c-4ec7-bd21-849dc6471e1e",
"type": "main",
"index": 0
}
]
]
},
"6f06a5e9-e54d-4333-b720-4234b95d7fd5": {
"main": [
[
{
"node": "804bfa01-8a62-46ed-b86b-c3c21776acdf",
"type": "main",
"index": 0
}
]
]
},
"baf521e1-ad2c-40cf-bdd6-78c1872987d7": {
"main": [
[
{
"node": "532435f7-2ed0-4c4c-a783-cd3e2d7761d0",
"type": "main",
"index": 0
},
{
"node": "9fbf58e9-4e04-4cdf-99b9-962cc1659232",
"type": "main",
"index": 0
}
]
]
},
"804bfa01-8a62-46ed-b86b-c3c21776acdf": {
"main": [
[
{
"node": "06564c94-911c-42bc-86a0-9562d02469e4",
"type": "main",
"index": 0
}
]
]
},
"7ac77e30-faf2-4f88-bdee-0bf3e4fcbbe5": {
"ai_tool": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "ai_tool",
"index": 0
}
]
]
},
"d320aae4-14ec-4682-8b79-3f320ca58c24": {
"main": [
[
{
"node": "96f9ff1d-c25a-471e-ab11-ac6985ac61c0",
"type": "main",
"index": 0
}
]
]
},
"dba4133a-dd92-4a4f-9170-0b14af98a63d": {
"main": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "main",
"index": 0
}
]
]
},
"f842b387-64bb-4555-95aa-43deedb813cb": {
"ai_tool": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "ai_tool",
"index": 0
}
]
]
},
"f0f58425-7e6c-4ec7-bd21-849dc6471e1e": {
"main": [
[
{
"node": "a292b5ef-a1d7-48dd-b806-f6a154a1a8a9",
"type": "main",
"index": 0
}
]
]
},
"192ac754-ad6c-46c6-9e93-12833cb00751": {
"main": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "main",
"index": 0
}
]
]
},
"cd95f448-16aa-4746-b9bc-89966dbcd1c6": {
"main": [
[
{
"node": "d320aae4-14ec-4682-8b79-3f320ca58c24",
"type": "main",
"index": 0
}
],
[
{
"node": "f0f58425-7e6c-4ec7-bd21-849dc6471e1e",
"type": "main",
"index": 0
}
]
]
},
"005acc6f-eb10-47cf-a45f-c8fbe7e0ed01": {
"ai_tool": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "ai_tool",
"index": 0
}
]
]
},
"791fd96b-9808-4573-af52-226695245cf5": {
"ai_languageModel": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"06564c94-911c-42bc-86a0-9562d02469e4": {
"main": [
[
{
"node": "62ece471-e4b4-4ed8-ae54-338a6acd02e4",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
私のワークフロー
カロリー追跡と食事記録（Telegram、Gemini AI、データスプレッドシート）
If
Set
Code
+
If
Set
Code
73 ノードGerald Denor
コンテンツ作成
音声サポートワークフロー
AI音声コーチとジェネレーター：Telegram、OpenAI、Geminiを活用
If
Set
Code
+
If
Set
Code
22 ノードNanaB
その他
歯科予約
AI駆動の歯科予約システム、Telegram、Googleカレンダー、Googleスプレッドシートと連携
If
Set
Switch
+
If
Set
Switch
53 ノードAziz B
GPT-4駆動のカールドメールワークフロー（完全カスタマイズされた3本のメールフォロー付き）
GPT-4、Mailgun、Supabaseを使ってパーソナライズされたラグディ冷信Seriesを自動化
If
Set
Code
+
If
Set
Code
100 ノードPaul
リードナーチャリング
ペットビューティー公開と予約の自動化
AI、Facebook、Telegram ボットを使ったペットコーディネーションの掲載と予約の自動化
If
Set
Switch
+
If
Set
Switch
36 ノードChristian Moises
AIチャットボット
Gemini、音声・画像生成を使ってマルチモーダルTelegram AIアシスタントを構築
Gemini、音声・画像生成を使ってマルチモーダルTelegramAIアシスタントを構築
If
Set
Code
+
If
Set
Code
95 ノードIniyavan JC
個人の生産性
ワークフロー情報
難易度
上級
ノード数27
カテゴリー-
ノードタイプ15
作成者
Vadim
@coderikI help businesses implement innovative AI/ML solutions, redesign existing systems to cut costs and boost reliability, and conduct applied R&D. I specialize in AI automation, agents, LLMs, Generative AI and Computer Vision. Need help customizing workflows? Just find me on Upwork.
外部リンク
n8n.ioで表示 →
このワークフローを共有