Instagram-Kommentare mit KlickTipp und benutzerdefinierten privaten Nachrichten in Leads umwandeln

• •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •Google Sheets API-Anmeldedaten

{
  "meta": {
    "instanceId": "95b3ab5a70ab1c8c1906357a367f1b236ef12a1409406fd992f60255f0f95f85",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "17b4422b-47fc-4d28-9906-762cb3f71049",
      "name": "Auf neue Instagram Kommentare hören",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -304,
        0
      ],
      "webhookId": "7dc782c9-e042-4b43-9b59-f0b7705d8cc8",
      "parameters": {
        "path": "7dc782c9-e042-4b43-9b59-f0b7705d8cc8",
        "options": {},
        "responseMode": "responseNode"
      },
      "typeVersion": 2.1
    },
    {
      "id": "2152d1c1-f620-4478-bb57-94c42743cbaa",
      "name": "Erste Validierung prüfen",
      "type": "n8n-nodes-base.switch",
      "notes": "This node checks whether there is a first validation challenge that needs to be responded to.",
      "position": [
        -96,
        0
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Initial Webhook verification",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "d6bafaef-109a-46b8-8053-86a3e3ed04fa",
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.query['hub.verify_token'] }}",
                    "rightValue": "KlickTipp"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Processing branch after setup",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "7c17fb98-6811-49b7-b423-59c329f222d1",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "",
                    "rightValue": ""
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {}
      },
      "notesInFlow": true,
      "typeVersion": 3.2
    },
    {
      "id": "5c2c6595-0057-4921-abc8-ef1d57ebc8bf",
      "name": "Validierungsaufforderung",
      "type": "n8n-nodes-base.respondToWebhook",
      "notes": "This node responds to the webhook when you setup the subscription inside the meta app and sends back the value for the challenge.",
      "position": [
        128,
        -144
      ],
      "parameters": {
        "options": {},
        "respondWith": "text",
        "responseBody": "={{ $json.query['hub.challenge'] }}"
      },
      "notesInFlow": true,
      "typeVersion": 1.4
    },
    {
      "id": "07b31569-056b-4ac1-afdf-fde4bf07bf82",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -272
      ],
      "parameters": {
        "color": 7,
        "width": 704,
        "height": 544,
        "content": "## 1. Data reception\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e843796f-20d8-4f56-9d84-7ade490a0c5f",
      "name": "DM-Formular an Benutzer",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "This node sends out a DM to a user in Instagram in order to prompt a form submission.",
      "position": [
        624,
        0
      ],
      "parameters": {
        "url": "https://graph.instagram.com/v21.0/me/messages",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "message",
              "value": "={\"text\":\"Hallo {{ $json.body.entry[0].changes[0].value.from.username }} 👋*, danke für deinen Kommentar! 🎉  Damit wir dir dein kostenloses Freebie zuschicken können, musst Du Dich einmal kurz über folgendes Formular einmal eintragen:\\n\\nhttps://form.jotform.com/252682338805059?instagram_username={{ $json.body.entry[0].changes[0].value.from.username }}\\n\\nMit der Angabe erklärst du dich einverstanden, dass wir dich per E-Mail zu Werbezwecken kontaktieren dürfen (z. B. Tipps, Angebote und Infos rund um [Thema]).  \\nDeine Daten behandeln wir natürlich vertraulich und du kannst dich jederzeit über einen Link in der E-Mail abmelden.\"}"
            },
            {
              "name": "recipient",
              "value": "={\"id\":\"{{ $json.body.entry[0].changes[0].value.from.id }}\"}"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "GkguVYubbVGSDPut",
          "name": "Instagram"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "e0217fec-a444-4c64-8ab4-93b7ef90fa6d",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        -272
      ],
      "parameters": {
        "color": 7,
        "width": 480,
        "height": 544,
        "content": "## 2. Validate and send message"
      },
      "typeVersion": 1
    },
    {
      "id": "85cc1544-caf3-4e47-b01c-9f282d0b8a8d",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        304
      ],
      "parameters": {
        "width": 1072,
        "height": 1360,
        "content": "## **Community Node Disclaimer**\nThis workflow uses **KlickTipp community nodes**, available for **self-hosted n8n instances only**.\n\n---\n\n## **Who’s it for**\nMarketing teams, agencies, and content creators who want to **turn Instagram post comments into automated conversations** — capturing leads, sending personalized DMs, and enriching contacts in **KlickTipp** without manual work.\n\n---\n\n## **How it works**\nThis workflow automates engagement between **Instagram users** and your **marketing funnel**.  \nIt listens for **new Instagram comments**, validates the **Meta webhook**, and sends **personalized DMs** with form links. The workflow then stores and syncs user data for tagging and enrichment in KlickTipp.  \n\nWhen a new comment appears, it:\n\n- Validates the webhook setup via the Meta `hub.challenge`  \n- Captures the commenter’s username and ID  \n- Sends a personalized DM with a form link for lead capture  \n- Stores the data in **Google Sheets** for tracking  \n- Updates or tags the contact in **KlickTipp**  \n\nThe result: every Instagram comment turns into a structured, tagged lead for your marketing automation.\n\n---\n\n## **How to set up**\nConnect accounts for **Meta (Instagram)**, **Google Sheets**, and **KlickTipp**.  \nSet up your **Meta App webhook** for Instagram comments, using your workflow’s webhook URL and verify token (e.g., `KlickTipp`).  \nCreate a Google Sheet as a matching table with the columns:  \n- `Instagram username`  \n- `Instagram ID`  \nAuthenticate KlickTipp with API credentials and ensure your subscriber fields are configured.  \nTest by commenting on a connected Instagram post to trigger the workflow.  \n\n💡 **Pro Tip:** Customize the DM to include your brand’s tone and lead form link for higher engagement.\n\n---\n\n## **Requirements**\n- Meta (Instagram) Business Account  \n- Facebook Graph API with `pages_messaging` permission  \n- Google Sheets OAuth connection  \n- KlickTipp account with API access  \n\n---\n\n## **How to customize**\n- Replace the default form link with your own **JotForm** or landing page URL.  \n- Adjust DM content to fit your tone and campaign messaging.  \n- Add logic to send different DMs based on comment keywords.  \n- Integrate with **KlickTipp tags** for automatic segmentation.  \n- Expand the workflow to handle **repeat commenters** or trigger follow-ups.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7c5ffb38-938a-4067-9a88-54a8ba021905",
      "name": "Enthält Kommentar Keyword?",
      "type": "n8n-nodes-base.if",
      "notes": "This node checks if the comment included the intended keyword.",
      "position": [
        384,
        16
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "bf80e26f-bfe8-4c1f-8fad-1ef649e458a9",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.body.entry[0].changes[0].value.text }}",
              "rightValue": "keyword"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "7d26c483-faf2-4f09-af42-497aadb35ef4",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        -272
      ],
      "parameters": {
        "color": 7,
        "width": 656,
        "height": 544,
        "content": "## 3. Save data"
      },
      "typeVersion": 1
    },
    {
      "id": "6f5b0980-f3b6-42e0-9b25-a4475656d2a2",
      "name": "Eintrag in Matching-Tabelle suchen",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "This node checks if there is an entry in the matching table for this username.",
      "position": [
        864,
        0
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $('Listen to new Instagram comments').item.json.body.entry[0].changes[0].value.from.username }}",
              "lookupColumn": "Instagram username"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "https://docs.google.com/spreadsheets/d/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit?gid=0#gid=0"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "9lfEu8fQ2DymUZeD",
          "name": "MW account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.7
    },
    {
      "id": "a0ff0eac-81ee-45de-9a42-a287af2b2161",
      "name": "Existiert Eintrag?",
      "type": "n8n-nodes-base.if",
      "notes": "This node checks whether the entry already exists in the matching table.",
      "position": [
        1056,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "21c3a512-9c5e-4b69-9747-b071c3a0f93d",
              "operator": {
                "type": "number",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.row_number }}",
              "rightValue": ""
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "184ab01a-d072-41cb-88d2-72147b41539a",
      "name": "Eintrag zu Matching-Tabelle hinzufügen",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "This node adds an entry to the matching table.",
      "position": [
        1280,
        96
      ],
      "parameters": {
        "columns": {
          "value": {
            "Instagram username": "={{ $('Listen to new Instagram comments').item.json.body.entry[0].changes[0].value.from.username }}",
            "Instagram ID comment payload": "={{ $('Listen to new Instagram comments').item.json.body.entry[0].changes[0].value.from.id }}"
          },
          "schema": [
            {
              "id": "Instagram username",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Instagram username",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Instagram ID comment payload",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Instagram ID comment payload",
              "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/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "https://docs.google.com/spreadsheets/d/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit?gid=0#gid=0"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "9lfEu8fQ2DymUZeD",
          "name": "MW account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.7
    }
  ],
  "pinData": {
    "Listen to new Instagram comments": [
      {
        "body": {
          "entry": [
            {
              "id": "0",
              "time": 1758907014,
              "changes": [
                {
                  "field": "comments",
                  "value": {
                    "id": "17865799348123123",
                    "from": {
                      "id": "2213136375123123",
                      "username": "username"
                    },
                    "text": "This is an example - keyword.",
                    "media": {
                      "id": "123123123",
                      "media_product_type": "FEED"
                    },
                    "parent_id": "1231231234"
                  }
                }
              ]
            }
          ],
          "object": "instagram"
        },
        "query": {},
        "params": {},
        "headers": {
          "host": "n8n-test-u24934.vm.elestio.app",
          "accept": "*/*",
          "x-real-ip": "31.13.115.2",
          "connection": "close",
          "user-agent": "Webhooks/1.0 (https://fb.me/webhooks)",
          "content-type": "application/json",
          "content-length": "308",
          "x-forwarded-for": "31.13.115.2",
          "x-hub-signature": "sha1=145d5d032cb43396fbf6644642fa5fc8757fa4b0",
          "x-forwarded-port": "443",
          "x-forwarded-proto": "https",
          "x-hub-signature-256": "sha256=0af8f7d1656dd2403a1aa0eb27179078cbf60e4ac8c3c111e2fd993791221c79"
        },
        "webhookUrl": "https://n8n-test-u24934.vm.elestio.app/webhook-test/7dc782c9-e042-4b43-9b59-f0b7705d8cc8",
        "executionMode": "test"
      }
    ]
  },
  "connections": {
    "e843796f-20d8-4f56-9d84-7ade490a0c5f": {
      "main": [
        [
          {
            "node": "6f5b0980-f3b6-42e0-9b25-a4475656d2a2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a0ff0eac-81ee-45de-9a42-a287af2b2161": {
      "main": [
        [],
        [
          {
            "node": "184ab01a-d072-41cb-88d2-72147b41539a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5c2c6595-0057-4921-abc8-ef1d57ebc8bf": {
      "main": [
        []
      ]
    },
    "2152d1c1-f620-4478-bb57-94c42743cbaa": {
      "main": [
        [
          {
            "node": "5c2c6595-0057-4921-abc8-ef1d57ebc8bf",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "7c5ffb38-938a-4067-9a88-54a8ba021905",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7c5ffb38-938a-4067-9a88-54a8ba021905": {
      "main": [
        [
          {
            "node": "e843796f-20d8-4f56-9d84-7ade490a0c5f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "17b4422b-47fc-4d28-9906-762cb3f71049": {
      "main": [
        [
          {
            "node": "2152d1c1-f620-4478-bb57-94c42743cbaa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6f5b0980-f3b6-42e0-9b25-a4475656d2a2": {
      "main": [
        [
          {
            "node": "a0ff0eac-81ee-45de-9a42-a287af2b2161",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}