自动保存Instagram潜在客户到Google表格

• •HTTP Webhook 端点（n8n 会自动生成）
• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "7da8c35d-17c2-4aff-9d1c-b1d6efaf78e8",
      "name": "设置说明",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        272
      ],
      "parameters": {
        "width": 712,
        "height": 508,
        "content": "📋 **需要设置：**"
      },
      "typeVersion": 1
    },
    {
      "id": "10f48b95-3f43-4bda-be11-115dabc5d4ca",
      "name": "Instagram潜在客户Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        672,
        624
      ],
      "webhookId": "instagram-leads-webhook",
      "parameters": {
        "path": "instagram-leads",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 1
    },
    {
      "id": "a9544025-af6c-427a-985b-c16b286c4be2",
      "name": "标准化潜在客户数据",
      "type": "n8n-nodes-base.code",
      "position": [
        880,
        624
      ],
      "parameters": {
        "jsCode": "// Normalize Instagram lead data\nconst body = $input.first().json.body || $input.first().json;\n\n// Common Instagram lead fields - adapt based on your form structure\nconst normalizedData = {\n  name: body.name || body.full_name || body.firstName + ' ' + body.lastName || 'Unknown',\n  email: body.email || body.email_address || '',\n  phone: body.phone || body.phone_number || '',\n  message: body.message || body.comments || '',\n  source: 'Instagram',\n  timestamp: new Date().toISOString(),\n  raw_data: JSON.stringify(body)\n};\n\nconsole.log('Normalized Instagram Lead Data:', normalizedData);\n\nreturn {\n  json: normalizedData\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "bf561879-cf2f-43d7-b118-6906c8030e35",
      "name": "保存到 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1072,
        624
      ],
      "parameters": {
        "options": {
          "useAppend": true
        },
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_GOOGLE_SHEET_ID"
        }
      },
      "typeVersion": 4
    }
  ],
  "pinData": {},
  "connections": {
    "Normalize Lead Data": {
      "main": [
        [
          {
            "node": "Save to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Instagram Lead Webhook": {
      "main": [
        [
          {
            "node": "Normalize Lead Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}