Ideen mit GPT-4 und Google Tabellen über Telegram erfassen und organisieren

• •Telegram Bot Token
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •Google Sheets API-Anmeldedaten
• •OpenAI API Key

{
  "nodes": [
    {
      "id": "a1a3b5eb-88c4-4c96-8410-0737c3cdb65d",
      "name": "Agent",
      "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-Trigger",
      "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 Client",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        896,
        1008
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6680f1db-fc75-4070-b4d1-7abdafa4fbfc",
      "name": "MCP Server Trigger",
      "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-Anfrage",
      "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": "Schalter",
      "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": "Edit Fields",
      "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-Chat-Modell",
      "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": "add_row_tool1",
      "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": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 368,
        "height": 640,
        "content": "## 🤖 AI Idea Capture Agent\n\nThis n8n template creates an intelligent **Ideation Agent** 🤖 that captures your ideas from text and voice notes sent via Telegram. The assistant automatically transcribes your voice memos, analyzes the content, and organizes it into a structured Google Sheet database. It's the perfect workflow for capturing inspiration whenever it strikes, just by talking or typing 💡.\n\n### **Use Cases:**\n*   🗣️ **Text-Based Capture:** Send any idea as a simple text message to your Telegram bot for instant processing.\n*   🎙️ **Voice-to-Idea:** Record voice notes on the go. The workflow transcribes them into text and categorizes them automatically.\n*   📂 **Automated Organization:** The AI agent intelligently structures each idea with a title, description, score, category, and priority level without any manual effort.\n*   📊 **Centralized Database:** Build a comprehensive and well-organized library of all your ideas in Google Sheets, making it easy to search, review, and act upon them.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b05013bf-abe4-40b0-a39a-493d68f21447",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        672
      ],
      "parameters": {
        "color": 3,
        "width": 656,
        "height": 496,
        "content": "## ✅ Listening for Ideas"
      },
      "typeVersion": 1
    },
    {
      "id": "874a4c1b-a2f9-4a95-bd64-e33fd33e219e",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        672
      ],
      "parameters": {
        "color": 4,
        "width": 544,
        "height": 496,
        "content": "## ✅ Prepare the Idea"
      },
      "typeVersion": 1
    },
    {
      "id": "003d1a3c-823a-4b8f-8397-3de18354ae64",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        672
      ],
      "parameters": {
        "color": 5,
        "width": 544,
        "height": 496,
        "content": "## ✅ Save the Idea"
      },
      "typeVersion": 1
    },
    {
      "id": "d00880ee-c86a-46b0-9140-5eab3782ff37",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        0
      ],
      "parameters": {
        "width": 400,
        "height": 640,
        "content": "### **How it works:**\n1.  **Multi-Modal Input:** The workflow starts with a `Telegram Trigger` that listens for incoming text messages and voice notes.\n2.  **Content-Based Routing:** A `Switch` node detects the message type. Text messages are sent directly for processing, while audio files are routed for transcription.\n3.  **Voice Transcription:** Voice messages are sent to the **ElevenLabs API**, which accurately converts the speech into text.\n4.  **Unified Input:** Both the original text and the transcribed audio are passed to the AI Agent in a consistent format.\n5.  **AI Analysis & Structuring:** An `AI Agent`, powered by a large language model, receives the text. It follows a detailed system prompt to analyze the idea and structure it into predefined fields: Idea, Idea Description, Idea Type, Score, Category, Priority, Status, and Complexity.\n6.  **Data Storage:** The agent uses the **Google Sheets Tool** (`add_row_tool`) to seamlessly add the fully structured idea as a new row in your designated spreadsheet.\n7.  **Instant Confirmation:** Once the idea is saved, the workflow sends a confirmation message back to you on Telegram, summarizing the captured idea.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8597d455-3580-41bc-8c26-44f0bb4a3736",
      "name": "Haftnotiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        0
      ],
      "parameters": {
        "width": 400,
        "height": 640,
        "content": "### **Requirements:**\n*   🌐 A **Telegram Bot API** token.\n*   🤖 An **AI provider** with API access (the template uses Azure OpenAI, but can be adapted).\n*   🗣️ An **ElevenLabs API** key for voice-to-text transcription.\n*   📝 **Google Sheets API** credentials to connect to your database.\n\n### **Customizing this workflow:**\n*   ✏️ **Modify Categories:** To change the available `Idea Type`, `Category/Domain`, or `Priority Level` options, simply edit the list within the `Agent` node's system prompt.\n*   🔄 **Swap LLM:** You can easily change the AI model by replacing the `Azure OpenAI Chat Model` node with another one, such as the standard OpenAI node or a local AI model.\n*   🔗 **Change Database:** To save ideas to a different platform, just replace the `add_row_tool1` (Google Sheets Tool) with a tool for another service like Notion, Airtable, or a database.\n"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "a1a3b5eb-88c4-4c96-8410-0737c3cdb65d": {
      "main": [
        [
          {
            "node": "60ae5549-bf5b-4395-96fd-ff411e5b3ea2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "a7cd2622-12f0-48ef-8859-b65df9b240ff",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "f12815e8-c7e1-4ae0-ba1f-629df23f1835",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f12815e8-c7e1-4ae0-ba1f-629df23f1835": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c6dd5ab6-1f9a-4693-b223-782ca6f318f7": {
      "ai_tool": [
        [
          {
            "node": "a1a3b5eb-88c4-4c96-8410-0737c3cdb65d",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "a7cd2622-12f0-48ef-8859-b65df9b240ff": {
      "main": [
        [
          {
            "node": "a1a3b5eb-88c4-4c96-8410-0737c3cdb65d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "a7cd2622-12f0-48ef-8859-b65df9b240ff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aa44faf0-4b0e-4c3d-9389-0fd93db7e45b": {
      "ai_tool": [
        [
          {
            "node": "6680f1db-fc75-4070-b4d1-7abdafa4fbfc",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "a1a3b5eb-88c4-4c96-8410-0737c3cdb65d",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}