LinkedIn-Ideen generieren

• •Telegram Bot Token
• •Google Sheets API-Anmeldedaten
• •OpenAI API Key

{
  "id": "sKnOz9WV5ZdJIZ2k",
  "meta": {
    "instanceId": "dadbebf780c99cf3658a428c5f6f25fbfe1554e05ad8991fa23e46dc89caf8a5",
    "templateCredsSetupCompleted": true
  },
  "name": "Generate LinkedIn Ideas",
  "tags": [],
  "nodes": [
    {
      "id": "d876c18a-aa3c-42ea-8cba-aff8b36bb2ec",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "f49bbcde-f09c-4799-a3de-7823e50fae0b",
      "name": "OpenAI-Chat-Modell",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        912,
        224
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {
          "topP": 0.9,
          "temperature": 1,
          "presencePenalty": 0.8,
          "frequencyPenalty": 0.3
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "sFcKYLVJ2pi4YEZD",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "25888890-2ac4-4363-a2b8-325302e53c99",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1040,
        224
      ],
      "parameters": {
        "jsonSchemaExample": "[{\n    \"idea\": \"Lovable's $4B Moment: Vibe Coding Goes Big\",\n    \"details\": \"Lovable, a Swedish AI startup specializing in 'vibe coding', just scored funding offers valuing it at over $4 billion after showing rapid growth—$100 million ARR and 10 million projects built—highlighting how natural-language app building is capturing serious investor attention. This signals that vibe coding is no longer fringe—it’s a headline trend reshaping how we build software in 2025.\",\n    \"style\": \"Trend Analysis\",\n    \"image\": \"A futuristic startup office glowing with neon lights, where developers use holographic keyboards and AI assistants generate entire apps from voice commands. A giant $4B valuation sign hovers above the scene to symbolize investor hype.\"\n  }]"
      },
      "typeVersion": 1.3
    },
    {
      "id": "91a1b4be-c03e-45f1-aab3-5c55236f67ff",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1824,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "id": "==ROW()-1",
            "idea": "={{ $('Code').item.json.idea }}",
            "image": "=",
            "style": "={{ $('Code').item.json.style }}",
            "output": "={{ $json.output.post }}",
            "status": "New",
            "details": "={{ $('Code').item.json.details }}",
            "imagePrompt": "={{ $('Code').item.json.image }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "idea",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "idea",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "details",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "details",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "style",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "style",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "output",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "output",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "imagePrompt",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "imagePrompt",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "image",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "image",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "hOdMSPcSq8CGboQ6",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7,
      "alwaysOutputData": false
    },
    {
      "id": "f7bf234c-7b90-45cf-b454-ad246042e960",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        1248,
        0
      ],
      "parameters": {
        "jsCode": "return $input.first().json.output.flat(1)"
      },
      "typeVersion": 2
    },
    {
      "id": "c22f0a87-85dc-4d6a-89ef-41212a3b2e24",
      "name": "Message a model",
      "type": "n8n-nodes-base.perplexity",
      "position": [
        672,
        0
      ],
      "parameters": {
        "model": "sonar-pro",
        "options": {},
        "messages": {
          "message": [
            {
              "role": "system",
              "content": "=You are an AI content researcher and strategist. Your job is to identify fresh, non-obvious ideas for LinkedIn posts at the intersection of Generative AI, AI agents, vibe coding, automation, no-code tools and product management.\n\nThese ideas should help professionals stay ahead of the curve, think differently, or take action. Your job is not just to summarize trends — it’s to remix, combine, and provoke.\n\nSearch across a wide range of sources (Reddit, Hacker News, Twitter/X, TechCrunch, FT, Axios, arXiv, personal blogs, and indie tools). Look for:\n- Real-world frictions or bottlenecks\n- Emerging tools and automations people are starting to use\n- “Top X” style insights\n- Signals of shifting norms in how people work, code, or build\n\nAvoid repeating or closely mirroring the following recent search results:\n- {{ $('Limit').all()[0].json.idea }}\n- {{ $('Limit').all()[1].json.idea }}\n- {{ $('Limit').all()[2].json.idea }}\n- {{ $('Limit').all()[3].json.idea }}\n- {{ $('Limit').all()[4].json.idea }}\n\nGenerate 3 LinkedIn-style post ideas. You can include posts that are:\n- Tactical: “Top X tools,” “How I automated Y,” “Why you should try this workflow”\n- Strategic: “What this trend means,” “Why most people miss this,” “What we’re not talking about”\n- Visual/Philosophical: “Weird UI trends,” “What ‘vibe coding’ actually means”\n\nFor each idea, return a structured JSON object with the following format:\n{\n  \"idea\": \"Clickbait headline that would grab attention on LinkedIn. A bold, intriguing, or contrarian sentence that grabs attention.\",\n  \"details\": \"4–6 sentence post draft explaining the insight, why it matters now, and what the professional takeaway is. Highlight any opportunity, risk, or shift in mindset.\",\n  \"style\": \"One of: [Hot take, Provocative, Explainer, Practical Tips, Hot take, Personal Insight, Provocative, Framework, Case Study].\n  \"image\": \"A GPT-image-1 visual prompt describing a creative image to accompany the post. Be specific and detailed, describe the mood and atmosphere, use descriptive adjectives, consider perspective and composition, specify lighting and time of day, specify the style or theme. Do not overload the prompt.\n}\n\nReturn the final output as a JSON array of 3 objects.\nDo not return article summaries or plain news.\nBe bold. Cross disciplines. Surprise me."
            },
            {
              "content": "Do a new search"
            }
          ]
        },
        "requestOptions": {}
      },
      "credentials": {
        "perplexityApi": {
          "id": "UICCRIWLA2hAi25Y",
          "name": "Perplexity account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "bfd24297-5345-44ec-ae53-ebbd6ab62377",
      "name": "Send a text message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2048,
        0
      ],
      "webhookId": "1066a503-8c59-4dee-8ed7-c2b3bde039aa",
      "parameters": {
        "text": "New ideas for LinkedIn have been generated!",
        "chatId": "1516391222",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {},
      "executeOnce": true,
      "typeVersion": 1.2
    },
    {
      "id": "64e63f93-dd9c-4971-8db9-14d215f77964",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1552,
        224
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\"post\": \"\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "c4518e27-cc07-44f0-9dfc-defb186fc2ee",
      "name": "Post Generator",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1472,
        0
      ],
      "parameters": {
        "text": "=Generate a post based on this:\nIdea: {{ $json.idea }}\nDetails: {{ $json.details }}\nStyle: {{ $json.style }}\n\nYour output must always be in the following JSON format:\n{ \"post\": \"\" }",
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "=You are an expert LinkedIn content writer for tech and startup professionals.\nYour job is to turn raw ideas about Generative AI, automation, and emerging tech culture into scroll-stopping, human, original posts for LinkedIn that feel human, unpolished and worth reading, like they were written by a real person with a sharp brain and a strong opinion.\n\nYour tone should be thoughtful, curious, and informal — like someone reflecting out loud, sharing something they noticed, or offering a bold take. No corporate speak.\n\nGiven an idea, some details and a style, write a LinkedIn post that:\n- Starts with a scroll-stopping, clickbaity , catchy and bold hook — an intriguing or contrarian sentence that grabs attention and makes you want to click \"see more\"\n- Is click-baity and generates an emotion on the reader\n- Is made up of short paragraphs (1–2 lines max each — keep it skimmable)\n- Feels like it was written by a human who thinks deeply, who is raw and flawed and messy, not an AI trying to summarize things\n- Has voice: real human tone, like someone reflecting out loud or texting a smart friend\n- Includes emotion — frustration, awe, curiosity, skepticism, joy, etc.\n- Uses a varied format and post length: things like short paragraphs, lists, emojis, bold statements, rhetorical questions, etc. are all viable\n- Breaks the structure if needed — lists, line breaks, emojis, sentence fragments\n- Delivers value — either an original insight, clear framework, opinion, lesson learned, or cultural observation\n- Shares a clear POV — not a summary, not neutral, but a real take\n- Ends with a soft CTA (a question, opinion, or open-ended line to spark engagement)\n\nAlso:\n- Do not write long blocks of text.\n- Avoid robotic or over-polished phrasing.\n- Let it feel casual, smart, and maybe even a bit messy.\n- Each post should feel like it was written in 3 minutes by someone with a sharp POV.\n- Do not make it sound safe or over-polished.\n- Do not write like a content marketer.\n\nThe voice should sometimes feel raw and messy, like someone wrote it fast because they had something worth saying."
            }
          ]
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.7
    },
    {
      "id": "0a5a5942-0fd4-484b-a215-10d88913f456",
      "name": "Idea Parser",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        896,
        0
      ],
      "parameters": {
        "text": "={{ $json.choices[0].message.content }}",
        "batching": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.7
    },
    {
      "id": "60e5ed21-49e6-47c9-8d00-cdb62a1a5c97",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        0
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "hOdMSPcSq8CGboQ6",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "c35fe905-d818-4540-91b2-bffcaf49a59b",
      "name": "Begrenzen",
      "type": "n8n-nodes-base.limit",
      "position": [
        448,
        0
      ],
      "parameters": {
        "keep": "lastItems",
        "maxItems": 5
      },
      "typeVersion": 1
    },
    {
      "id": "8b9f9e4a-8f63-4a35-aee2-d14459b2d5e7",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        -128
      ],
      "parameters": {
        "width": 672,
        "height": 288,
        "content": "## Trigger daily\n\nThe workflow triggers on a daily basis and gets the last 3 posts that were generated."
      },
      "typeVersion": 1
    },
    {
      "id": "21cd2941-0b9e-4f73-a015-5fb26bf8f920",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        -128
      ],
      "parameters": {
        "width": 768,
        "height": 528,
        "content": "## Search for ideas\n\nIt then uses Perpexlity to find ideas based on the niche selected and parses them into a structured output"
      },
      "typeVersion": 1
    },
    {
      "id": "28241419-68e0-4cf2-a857-65c91da0156e",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        -128
      ],
      "parameters": {
        "width": 768,
        "height": 528,
        "content": "## Create and save ideas\n\nFinally, the workflow creates the ideas with an image prompt to generate later, saves them to Google Sheets and sends a notification via Telegram"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "timezone": "Europe/Lisbon",
    "callerPolicy": "workflowsFromSameOwner",
    "errorWorkflow": "Egdhew5Scau0oU43",
    "executionOrder": "v1"
  },
  "versionId": "0e9fad64-2b28-458a-ad7f-c8f3f7ca5b61",
  "connections": {
    "f7bf234c-7b90-45cf-b454-ad246042e960": {
      "main": [
        [
          {
            "node": "c4518e27-cc07-44f0-9dfc-defb186fc2ee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "c22f0a87-85dc-4d6a-89ef-41212a3b2e24",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0a5a5942-0fd4-484b-a215-10d88913f456": {
      "main": [
        [
          {
            "node": "f7bf234c-7b90-45cf-b454-ad246042e960",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c4518e27-cc07-44f0-9dfc-defb186fc2ee": {
      "main": [
        [
          {
            "node": "91a1b4be-c03e-45f1-aab3-5c55236f67ff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c22f0a87-85dc-4d6a-89ef-41212a3b2e24": {
      "main": [
        [
          {
            "node": "0a5a5942-0fd4-484b-a215-10d88913f456",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "60e5ed21-49e6-47c9-8d00-cdb62a1a5c97",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "0a5a5942-0fd4-484b-a215-10d88913f456",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "c4518e27-cc07-44f0-9dfc-defb186fc2ee",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "91a1b4be-c03e-45f1-aab3-5c55236f67ff": {
      "main": [
        [
          {
            "node": "bfd24297-5345-44ec-ae53-ebbd6ab62377",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "60e5ed21-49e6-47c9-8d00-cdb62a1a5c97": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "25888890-2ac4-4363-a2b8-325302e53c99": {
      "ai_outputParser": [
        [
          {
            "node": "0a5a5942-0fd4-484b-a215-10d88913f456",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "64e63f93-dd9c-4971-8db9-14d215f77964": {
      "ai_outputParser": [
        [
          {
            "node": "c4518e27-cc07-44f0-9dfc-defb186fc2ee",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}