自动Instagram潜在客户丰富化

• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证
• •Facebook Graph API 凭证
• •OpenAI API Key

{
  "meta": {
    "instanceId": "95b3ab5a70ab1c8c1906357a367f1b236ef12a1409406fd992f60255f0f95f85",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "ad57cc04-508b-494a-9cf9-fbd7bb8f2b7b",
      "name": "监听来自 Instagram DM 的提交",
      "type": "n8n-nodes-base.jotFormTrigger",
      "notes": "This node listens to the submissions of the form that was sent to the instagram user via DM after commenting our post.",
      "position": [
        -160,
        -32
      ],
      "webhookId": "86f7fa29-8c8d-47e8-a2e6-5857aceac1b5",
      "parameters": {
        "form": "252682338805059"
      },
      "credentials": {
        "jotFormApi": {
          "id": "EkncJAiUJ2qy5sxK",
          "name": "Integrations JotForm account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "4abccb8b-e942-4b40-8139-063c95537ad1",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        944,
        112
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"Insights\": \"This Instagram profile belongs to a niche film-photography enthusiast with a clear focus on analog shooting (Praktica MTL 50) and a strong visual aesthetic. With 293 followers, 49 posts and a high follow-to-follower ratio (781 follows vs 293 followers), the user is likely a hobbyist who actively seeks inspiration and community rather than a mass-market influencer. Key actionable insights for email marketing:\\n\\n1. **Interest & Content Focus** – Film photography, vintage gear, film stock, darkroom techniques, creative storytelling. Emails should feature gear reviews, film stock news, tutorials, and behind-the-lens stories.\\n\\n2. **Demographic & Psychographic** – Likely 20-35 years old, creative professionals or students, values authenticity, craftsmanship, and artistic expression. Motivated by community, learning opportunities, and exclusive deals.\\n\\n3. **Tone & Messaging Style** – Warm, slightly nostalgic, supportive, and aspirational. Use imagery-rich copy, analog metaphors, and a conversational voice that mirrors the user’s bio and captions.\\n\\n4. **Segmentation Opportunities** – Create a “Film-Photography Enthusiast” segment: those who follow similar accounts, engage with film-related content, or have shown interest in analog gear. Offer early access to film stock bundles, workshop invites, and discount codes for film-related accessories.\\n\\n5. **Email Topics & CTAs** – “New Film Stock Arrivals for Analog Lovers”, “Step-by-Step Darkroom Guide”, “Join Our Monthly Film-Photography Challenge”, “Exclusive Discount on Praktica-Compatible Lenses”. Each email should end with a clear CTA to join a community forum, download a free guide, or purchase gear.\\n\\n6. **Frequency & Timing** – Moderate cadence (2-3 emails/month) to avoid overwhelming a niche audience. Send during evenings or weekends when hobbyists are most likely to engage.\\n\\n7. **Cross-Channel Strategy** – Use Instagram stories and posts to tease email content, encouraging followers to sign up for the newsletter for deeper dives and special offers.\\n\\nBy aligning email content with the user’s passion for film photography and fostering a sense of community, you can increase engagement, conversion, and loyalty within this niche segment.\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "5718f77d-b929-46b2-85ba-12ac7690eef2",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        832,
        80
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "gUQSrwcXp7sofl9v",
          "name": "OpenAi Integration Account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a1aa8068-9705-4bd3-b499-0d0748e42561",
      "name": "生成洞察",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "notes": "This AI Agent generates marketing insights from the instagram profile information.",
      "position": [
        768,
        -48
      ],
      "parameters": {
        "text": "=Analyze this instagram user and provide actionable insights about the user that would be useful for targeting in email marketing campaigns. Focus on interests, demographics, tone, and potential motivators that could inform segmentation and personalized messaging.\n\nBio:\n{{ $json.business_discovery.biography }}\n\nFollowers count:\n{{ $json.business_discovery.followers_count }}\n\nFollows count:\n{{ $json.business_discovery.follows_count }}\n\nMedia count:\n{{ $json.business_discovery.media_count }}\n\nProfile image:\n{{ $json.business_discovery.profile_picture_url }}",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "bc985b69-18c1-4f54-a3f4-576372b24a26",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        -144
      ],
      "parameters": {
        "color": 7,
        "width": 496,
        "height": 656,
        "content": "## 1. 数据接收"
      },
      "typeVersion": 1
    },
    {
      "id": "1354f78c-1f3a-4210-a077-f38af721c993",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        256,
        -144
      ],
      "parameters": {
        "color": 7,
        "width": 816,
        "height": 656,
        "content": "## 2. 数据丰富"
      },
      "typeVersion": 1
    },
    {
      "id": "b807e058-b7f3-47f1-b681-8c02532462e3",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        -144
      ],
      "parameters": {
        "color": 7,
        "width": 352,
        "height": 656,
        "content": "## 3. 保存数据"
      },
      "typeVersion": 1
    },
    {
      "id": "e46e14a8-ac09-40d4-ac4a-fcac68a0c1b0",
      "name": "个人资料类型检查",
      "type": "n8n-nodes-base.switch",
      "position": [
        480,
        -32
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Professional profile",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "9a3e40e3-f14d-44fd-9e08-02e41368f081",
                    "operator": {
                      "type": "string",
                      "operation": "exists",
                      "singleValue": true
                    },
                    "leftValue": "={{ $json.business_discovery.id }}",
                    "rightValue": ""
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Personal profile",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "f54ffba0-9c50-4f1b-af7d-8a8bd4163c82",
                    "operator": {
                      "type": "number",
                      "operation": "exists",
                      "singleValue": true
                    },
                    "leftValue": "={{ $json.statusCode }}",
                    "rightValue": ""
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "811b41e1-705e-44fa-afb9-202cd04ffdca",
      "name": "使用用户洞察订阅联系人",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "notes": "This node subscribes the instagram user to KlickTipp with the enriched data.",
      "position": [
        1168,
        -48
      ],
      "parameters": {
        "email": "={{ $('Listen to submission from Instagram DM').item.json.Email }}",
        "tagId": "13614965",
        "fields": {
          "dataFields": [
            {
              "fieldId": "fieldFirstName",
              "fieldValue": "={{ $('Listen to submission from Instagram DM').item.json.Name.first }}"
            },
            {
              "fieldId": "fieldLastName",
              "fieldValue": "={{ $('Listen to submission from Instagram DM').item.json.Name.last }}"
            },
            {
              "fieldId": "field224100",
              "fieldValue": "={{ $('Listen to submission from Instagram DM').item.json.instagram_username }}"
            },
            {
              "fieldId": "field224125",
              "fieldValue": "={{ $('Get user profile').item.json.business_discovery.biography }}"
            },
            {
              "fieldId": "field224101",
              "fieldValue": "={{ $json.output.Insights }}"
            },
            {
              "fieldId": "field224126",
              "fieldValue": "={{ $('Get user profile').item.json.business_discovery.followers_count }}"
            },
            {
              "fieldId": "field224127",
              "fieldValue": "={{ $('Get user profile').item.json.business_discovery.follows_count }}"
            },
            {
              "fieldId": "field224128",
              "fieldValue": "={{ $('Get user profile').item.json.business_discovery.media_count }}"
            },
            {
              "fieldId": "field224129",
              "fieldValue": "={{ $('Look for entry in matching table').item.json['Instagram ID comment payload'] }}"
            }
          ]
        },
        "listId": "358895",
        "resource": "subscriber",
        "operation": "subscribe"
      },
      "notesInFlow": true,
      "typeVersion": 3
    },
    {
      "id": "55aff71d-7014-40c9-a61a-ab47a295af95",
      "name": "使用用户名订阅联系人",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "notes": "This node subscribes the instagram user to KlickTipp with the enriched data.",
      "position": [
        1168,
        288
      ],
      "parameters": {
        "email": "={{ $('Listen to submission from Instagram DM').item.json.Email }}",
        "tagId": "13659866",
        "fields": {
          "dataFields": [
            {
              "fieldId": "fieldFirstName",
              "fieldValue": "={{ $('Listen to submission from Instagram DM').item.json.Name.first }}"
            },
            {
              "fieldId": "fieldLastName",
              "fieldValue": "={{ $('Listen to submission from Instagram DM').item.json.Name.last }}"
            },
            {
              "fieldId": "field224100",
              "fieldValue": "={{ $('Listen to submission from Instagram DM').item.json.instagram_username }}"
            },
            {
              "fieldId": "field224129",
              "fieldValue": "={{ $('Look for entry in matching table').item.json['Instagram ID comment payload'] }}"
            }
          ]
        },
        "listId": "358895",
        "resource": "subscriber",
        "operation": "subscribe"
      },
      "notesInFlow": true,
      "typeVersion": 3
    },
    {
      "id": "8f84e109-b2a9-4433-97a1-0e1b31f3a24c",
      "name": "获取用户个人资料",
      "type": "n8n-nodes-base.facebookGraphApi",
      "notes": "This node gets the instagram profile using the username from the form submission.",
      "onError": "continueRegularOutput",
      "position": [
        304,
        -32
      ],
      "parameters": {
        "node": "17841465090245583",
        "options": {
          "fields": {
            "field": [
              {
                "name": "=business_discovery.username({{ $json.instagram_username }}){id,username,name,biography,followers_count,follows_count,media_count,profile_picture_url}"
              }
            ]
          }
        },
        "graphApiVersion": "v23.0"
      },
      "credentials": {
        "facebookGraphApi": {
          "id": "8p3fSuRcgPe70Tji",
          "name": "Facebook Graph account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "d2c7ce02-2bd6-4dc9-8a4a-949ad75d26fe",
      "name": "在匹配表中查找条目",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "This node checks if there is an entry in the matching table for this username.",
      "position": [
        80,
        -32
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.instagram_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": "8afaf202-2345-4c31-a3dc-d729831fd17b",
      "name": "KlickTipp 触发器",
      "type": "n8n-nodes-klicktipp.klicktippTrigger",
      "position": [
        384,
        1120
      ],
      "webhookId": "0db528b9-9b47-443e-bef8-c778cdaeed0f",
      "parameters": {},
      "credentials": {
        "klickTippApi": {
          "id": "fysNIl2Ak3rBr8Wb",
          "name": "Ricardo's KlickTipp account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3eece678-ae5f-4bd2-badb-44e5b6d3e367",
      "name": "向用户发送个性化 DM",
      "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": [
        864,
        1120
      ],
      "parameters": {
        "url": "https://graph.instagram.com/v21.0/me/messages",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "message",
              "value": "={\"text\":\"Hallo {{ $json.CustomFieldFirstName }} 👋*. Das ist eine persönliche Nachricht.\"}"
            },
            {
              "name": "recipient",
              "value": "={\"id\":\"2213136375820874\"}"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "iIttas5W2ZkPdnYY",
          "name": "Instagram"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "32b77aa6-8537-4846-8fa1-09d2aedcff66",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        224,
        944
      ],
      "parameters": {
        "color": 7,
        "width": 464,
        "height": 384,
        "content": "## 1. 数据接收"
      },
      "typeVersion": 1
    },
    {
      "id": "ec847335-fe6b-4188-a41c-c03ef7c10b74",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        704,
        944
      ],
      "parameters": {
        "color": 7,
        "width": 448,
        "height": 384,
        "content": "## 2. 发送消息"
      },
      "typeVersion": 1
    },
    {
      "id": "9d1c5086-53c7-4435-8c2c-e3618181bb26",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        -608
      ],
      "parameters": {
        "width": 624,
        "height": 448,
        "content": "## 1. 数据接收"
      },
      "typeVersion": 1
    },
    {
      "id": "0e9a6018-8ec2-49bf-ad9f-f5e7faa8c653",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        256,
        -608
      ],
      "parameters": {
        "width": 816,
        "height": 448,
        "content": "## 2. 数据丰富"
      },
      "typeVersion": 1
    },
    {
      "id": "6a0e566f-477b-4ca8-bb1c-61fad66be52b",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        -608
      ],
      "parameters": {
        "width": 624,
        "height": 448,
        "content": "## 3. 保存数据"
      },
      "typeVersion": 1
    },
    {
      "id": "39b134d9-2043-4c6d-889f-a92556c02b95",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        576
      ],
      "parameters": {
        "width": 752,
        "height": 352,
        "content": "## 1. DM 消息流"
      },
      "typeVersion": 1
    },
    {
      "id": "317a58da-2510-4816-8302-bb0462a0a17b",
      "name": "便签 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        320
      ],
      "parameters": {
        "color": 3,
        "content": "⚠️ **API 权限提醒**"
      },
      "typeVersion": 1
    },
    {
      "id": "839e89b9-a1da-4c57-887d-72ac59474d16",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1552,
        -240
      ],
      "parameters": {
        "color": 7,
        "width": 1072,
        "height": 1296,
        "content": "## **社区节点免责声明**"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {
    "Get user profile": [
      {
        "id": "17841423758904419",
        "business_discovery": {
          "id": "17841489230657124",
          "name": "the child of the sun",
          "username": "username",
          "biography": "Capturing life on film 🎞",
          "media_count": 49,
          "follows_count": 783,
          "followers_count": 293,
          "profile_picture_url": "https://iamalinktoanimage.com"
        }
      }
    ],
    "Generate Insights": [
      {
        "output": {
          "Insights": "The Instagram user appears to be an individual with a passion for analog photography, specifically using the Praktica MTL 50 camera. This is evident from the bio which states \"Capturing life on film 🎞 Praktica MTL 50 📷.\" The use of film suggests an interest in vintage or classic photography techniques rather than digital, which can be a strong preference and lifestyle indicator.\n\nDemographics: With 293 followers and 782 following, the user is likely an enthusiast or hobbyist photographer who engages actively with similar accounts. The relatively modest media count of 49 posts supports that the account is maintained regularly but not excessively, pointing to a more genuine and personal style rather than commercial.\n\nTone: The bio and content likely convey a creative, nostalgic, and authentic tone, appealing to audiences interested in artistic expression, creativity, and possibly retro or vintage culture.\n\nInterests and Motivators for Email Marketing:\n1. Analog and Vintage Photography: Highlight offers on film, camera accessories, vintage camera gear, developing kits, and workshops.\n2. Creativity and Art: Promotions of photographic prints, exhibitions, creative courses, and community events.\n3. Authentic Experiences: Messaging that emphasizes manual, personal, and authentic photographic processes.\n4. Community and Learning: Invitations to join clubs, forums, or online groups related to analog photography.\n\nSegmentation Strategy: Segment this user into a \"Creative Analog Photography Enthusiast\" group for targeted campaigns emphasizing quality, authenticity, and vintage appeal. Messaging should be personalized, reflecting the passion for film photography and the artistry involved, using a warm, inspiring tone. Email content could include tips, tutorials, product recommendations, and stories about film photography culture."
        }
      }
    ],
    "Listen to submission from Instagram DM": [
      {
        "Name": {
          "last": "Klünter",
          "first": "Ricardo"
        },
        "Email": "ricardo@example.de",
        "instagram_username": "username"
      }
    ]
  },
  "connections": {
    "Get user profile": {
      "main": [
        [
          {
            "node": "Profile type check",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Insights": {
      "main": [
        [
          {
            "node": "Subscribe contact with user insights",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "KlickTipp Trigger": {
      "main": [
        [
          {
            "node": "Send personalized DM to user",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Generate Insights",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Profile type check": {
      "main": [
        [
          {
            "node": "Generate Insights",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Subscribe contact with username",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Generate Insights",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Look for entry in matching table": {
      "main": [
        [
          {
            "node": "Get user profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Listen to submission from Instagram DM": {
      "main": [
        [
          {
            "node": "Look for entry in matching table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}