通过Telegram使用GPT-4和Google表格捕获和组织想法

• •Telegram Bot Token
• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证
• •OpenAI API Key

{
  "nodes": [
    {
      "id": "a1a3b5eb-88c4-4c96-8410-0737c3cdb65d",
      "name": "代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        752,
        768
      ],
      "parameters": {
        "text": "={{ $json.Prompt }}",
        "options": {
          "maxIterations": 50,
          "systemMessage": "=You are an expert Ideation AI Agent specialized in capturing, analyzing, and organizing ideas into my Google Sheet database. Every time I send you an idea, you must:\n\n**PRIMARY TASK:**\nUse the add_row_tool to insert a comprehensive entry into my Notion database with the following fields:\n\n**REQUIRED FIELDS:**\n\n**Idea:** \nWrite a catchy, one-sentence title/name for the idea\nExample: \"Social Media Content Repurposing Agent\"\n\n**Idea Description:** \nWrite 2-3 sentences describing what the idea does, how it works, and its benefits\nExample: \"This AI agent automatically converts long-form blog posts into various social media formats such as Twitter threads, LinkedIn posts, Instagram carousels, and YouTube video outlines. It optimizes the content for each platform's specific audience and best practices, streamlining content distribution for creators and businesses.\"\n\n**Idea Type:** \nChoose EXACTLY one of these 4 options:\n- \"AI Agent\" - for autonomous AI assistants/bots\n- \"Web App\" - for website/browser applications  \n- \"SaaS Platform\" - for paid software services\n- \"Integration/Workflow\" - for tools that connect/automate between systems\n\n**Idea Score:** \nWrite one number as text: \"1\", \"2\", \"3\", \"4\", \"5\", \"6\", \"7\", \"8\", \"9\", or \"10\"\n\n**Category/Domain:** \nChoose EXACTLY one:\n- \"Business & Entrepreneurship\"\n- \"Technology & Software\" \n- \"Personal Productivity\"\n- \"Creative & Design\"\n- \"Health & Wellness\"\n- \"Education & Learning\"\n- \"Finance & Investment\"\n- \"Social & Communication\"\n- \"Entertainment & Media\"\n- \"Automation & Optimization\"\n\n**Priority Level:** \nChoose EXACTLY one: \"High\", \"Medium\", or \"Low\"\n\n**Status:** \nChoose EXACTLY one: \"New\", \"In Progress\", \"Researching\", or \"Implemented\"\n\n**Complexity Level:** \nChoose EXACTLY one: \"Simple\", \"Moderate\", or \"Complex\"\n\n**CRITICAL:** Use the exact text from the options above. Do NOT create variations.\n\n**RESPONSE FORMAT:**\nAfter inserting to database, confirm with: \"✅ Idea captured: [Brief title] - [Type] - Score: [X/10] - Priority: [Level]\""
        },
        "promptType": "define"
      },
      "typeVersion": 1.7
    },
    {
      "id": "c4e5e515-0a3a-412b-b23e-acf5184f5b96",
      "name": "Telegram 触发器",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        32,
        752
      ],
      "webhookId": "5ec782dd-a8ae-4937-8b40-e045d127b118",
      "parameters": {
        "updates": [
          "message"
        ],
        "additionalFields": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "c6dd5ab6-1f9a-4693-b223-782ca6f318f7",
      "name": "MCP 客户端",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        896,
        1008
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6680f1db-fc75-4070-b4d1-7abdafa4fbfc",
      "name": "MCP 服务器触发器",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        1392,
        784
      ],
      "webhookId": "17bd0cba-5dcd-4d8b-abef-c2ba2f7cca87",
      "parameters": {
        "path": "17bd0cba-5dcd-4d8b-abef-c2ba2f7cca87"
      },
      "typeVersion": 1
    },
    {
      "id": "f12815e8-c7e1-4ae0-ba1f-629df23f1835",
      "name": "Telegram1",
      "type": "n8n-nodes-base.telegram",
      "position": [
        272,
        1008
      ],
      "webhookId": "618e9593-9548-433f-985c-dd783a0d3d07",
      "parameters": {
        "fileId": "={{ $json.message.voice.file_id }}",
        "resource": "file",
        "additionalFields": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "8208dceb-6f7e-4eeb-8ba9-4baa5edd9d9c",
      "name": "HTTP 请求",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        1008
      ],
      "parameters": {
        "url": "https://api.elevenlabs.io/v1/speech-to-text",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "multipart-form-data",
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "model_id",
              "value": "scribe_v1"
            },
            {
              "name": "file",
              "parameterType": "formBinaryData",
              "inputDataFieldName": "data"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth"
      },
      "typeVersion": 4.2
    },
    {
      "id": "728a4b8f-2e92-4864-86b1-8e041496424c",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        96,
        944
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "ee163b36-d8ec-4ffb-b302-5360099a424b",
                    "operator": {
                      "type": "string",
                      "operation": "contains"
                    },
                    "leftValue": "={{ $json.message.toJsonString() }}",
                    "rightValue": "text"
                  }
                ]
              }
            },
            {
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "0c4fcbc4-c2ab-414b-b666-30c6cf9a54b3",
                    "operator": {
                      "type": "string",
                      "operation": "contains"
                    },
                    "leftValue": "={{ $json.message.toJsonString() }}",
                    "rightValue": "audio"
                  }
                ]
              }
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3.2
    },
    {
      "id": "60ae5549-bf5b-4395-96fd-ff411e5b3ea2",
      "name": "Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1040,
        768
      ],
      "webhookId": "291a8ef8-2106-4b98-a9ff-7eb9f6e712db",
      "parameters": {
        "text": "={{ $json.output }}",
        "chatId": "={{ $('Telegram Trigger').item.json.message.chat.id }}",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a7cd2622-12f0-48ef-8859-b65df9b240ff",
      "name": "获取简报",
      "type": "n8n-nodes-base.set",
      "position": [
        544,
        768
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "cdfce35f-fc3d-4762-8cdd-8d1dc0646064",
              "name": "Prompt",
              "type": "string",
              "value": "={{ $json.text }}{{ $('Telegram Trigger').item.json.message.text }}{{ $json.candidates[0].content.parts[0].text }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "df24f41b-badd-435e-94f1-5fab711e9585",
      "name": "Azure OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        752,
        1008
      ],
      "parameters": {
        "model": "gpt-4.1-2",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "aa44faf0-4b0e-4c3d-9389-0fd93db7e45b",
      "name": "添加行工具1",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        1424,
        944
      ],
      "parameters": {
        "columns": {
          "value": {
            "Idea ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Idea_', ``, 'string') }}",
            "Status": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Status', ``, 'string') }}",
            "Idea Type": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Idea_Type', ``, 'string') }}",
            "Idea Score": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Idea_Score', ``, 'string') }}",
            "Complexity ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Complexity_', ``, 'string') }}",
            "Priority Level": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Priority_Level', ``, 'string') }}",
            "Category/Domain": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Category_Domain', ``, 'string') }}",
            "Idea Description ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Idea_Description_', ``, 'string') }}"
          },
          "schema": [
            {
              "id": "Idea ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Idea ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Idea Description ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Idea Description ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Idea Type",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Idea Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Idea Score",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Idea Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Category/Domain",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Category/Domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Priority Level",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Priority Level",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Complexity ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Complexity ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xMuQ0-fT9M3_-LFyvyvuCJnXTrqZsfLKqEeUU9u1v7U/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xMuQ0-fT9M3_-LFyvyvuCJnXTrqZsfLKqEeUU9u1v7U",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xMuQ0-fT9M3_-LFyvyvuCJnXTrqZsfLKqEeUU9u1v7U/edit?usp=drivesdk",
          "cachedResultName": "Ideation AI Agent - DB"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "97d0a954-cc10-4e4a-bc55-92730ee9e4a3",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 368,
        "height": 640,
        "content": "## 🤖 AI创意捕捉助手"
      },
      "typeVersion": 1
    },
    {
      "id": "b05013bf-abe4-40b0-a39a-493d68f21447",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        672
      ],
      "parameters": {
        "color": 3,
        "width": 656,
        "height": 496,
        "content": "## ✅ 监听创意输入"
      },
      "typeVersion": 1
    },
    {
      "id": "874a4c1b-a2f9-4a95-bd64-e33fd33e219e",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        672
      ],
      "parameters": {
        "color": 4,
        "width": 544,
        "height": 496,
        "content": "## ✅ 准备创意"
      },
      "typeVersion": 1
    },
    {
      "id": "003d1a3c-823a-4b8f-8397-3de18354ae64",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        672
      ],
      "parameters": {
        "color": 5,
        "width": 544,
        "height": 496,
        "content": "## ✅ 保存创意"
      },
      "typeVersion": 1
    },
    {
      "id": "d00880ee-c86a-46b0-9140-5eab3782ff37",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        0
      ],
      "parameters": {
        "width": 400,
        "height": 640,
        "content": "### **工作原理：**"
      },
      "typeVersion": 1
    },
    {
      "id": "8597d455-3580-41bc-8c26-44f0bb4a3736",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        0
      ],
      "parameters": {
        "width": 400,
        "height": 640,
        "content": "### **要求：**"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Agent": {
      "main": [
        [
          {
            "node": "Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Telegram1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Telegram1": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MCP Client": {
      "ai_tool": [
        [
          {
            "node": "Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "add_row_tool1": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}