使用 AI、Gmail 和 Google Sheets 进行超个性化邮件推广

• •Google 账号和 Gmail API 凭证
• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证
• •OpenAI API Key

{
  "id": "LCSqIlPZdq3OmgH0",
  "meta": {
    "instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
  },
  "name": "使用AI、Gmail和Google Sheets进行超个性化邮件推广",
  "tags": [],
  "nodes": [
    {
      "id": "af621613-d8c3-411e-8f5b-26e08eb27133",
      "name": "获取工作表中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        920
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_SHEET_ID}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{YOUR_GOOGLE_SHEET_ID}/edit#gid=0",
          "cachedResultName": "{YOUR_SHEET_NAME}"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_GOOGLE_DOCUMENT_ID}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{YOUR_GOOGLE_DOCUMENT_ID}/edit?usp=drivesdk",
          "cachedResultName": "n8nEmail"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "cf8bc124-04fd-4930-9040-6fc6ee6f25c4",
      "name": "当点击“执行工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        240,
        920
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "613fd1d4-ec8a-40be-9f31-ef64483acf87",
      "name": "发送个性化邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2700,
        920
      ],
      "webhookId": "{YOUR_WEBHOOK_ID}",
      "parameters": {
        "sendTo": "={{ $('Get row(s) in sheet').item.json['Email ID'] }}",
        "message": "={{ $json.message.content }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "=Re:{{ $('Get row(s) in sheet').item.json.Intent }}"
      },
      "typeVersion": 2.1
    },
    {
      "id": "a40af7f9-b6f3-400e-ab4e-dd775003b733",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        60,
        620
      ],
      "parameters": {
        "color": 5,
        "width": 440,
        "height": 280,
        "content": "### 步骤1：启动对话！🟢📬"
      },
      "typeVersion": 1
    },
    {
      "id": "b6a44211-9973-426f-970e-7cf92ba068cf",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        620,
        1080
      ],
      "parameters": {
        "color": 3,
        "width": 380,
        "height": 480,
        "content": "### 步骤2：表格扫描器已激活！📄🔍"
      },
      "typeVersion": 1
    },
    {
      "id": "742daf1e-e03e-4aa5-a01f-6d7a89e562e9",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1900,
        1120
      ],
      "parameters": {
        "color": 4,
        "width": 420,
        "height": 360,
        "content": "### 步骤4：智能邮件撰写器✍️🤖"
      },
      "typeVersion": 1
    },
    {
      "id": "41dad360-10ee-40f4-9e9b-1f2d490d2545",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2520,
        500
      ],
      "parameters": {
        "color": 6,
        "width": 380,
        "height": 400,
        "content": "### 步骤5：点击发送✉️📨"
      },
      "typeVersion": 1
    },
    {
      "id": "cfb4be86-d24c-4eb5-ab7e-649c851bbadc",
      "name": "向模型发送消息",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1920,
        920
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_OPENAI_MODEL}",
          "cachedResultName": "{YOUR_OPENAI_MODEL_NAME}"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Write a professional and friendly email reply to {{ $('Get row(s) in sheet').item.json['First Name'] }} . Their intent is \"{{ $('Get row(s) in sheet').item.json.Intent }}\". They wrote: \"{{ $('Get row(s) in sheet').item.json['Why They Sent Email'] }}\". Make the response specific to their message and helpful.No need to add the subject line. Generate in HTML formatting.\nThe footer signature should be of the following format\nThanks,\n{{ $json.sendAs[0].displayName }}\n"
            }
          ]
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "e2b7d857-9ebb-4bff-914c-c7c8c4c87de2",
      "name": "HTTP请求",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1320,
        920
      ],
      "parameters": {
        "url": "https://gmail.googleapis.com/gmail/v1/users/me/settings/sendAs",
        "options": {},
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "gmailOAuth2"
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "c9140451-b3db-433e-9fc4-9c7ff088c455",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1100,
        560
      ],
      "parameters": {
        "width": 420,
        "height": 340,
        "content": "### 步骤3：签名同步🖋️📛"
      },
      "typeVersion": 1
    },
    {
      "id": "da2db045-a86c-4735-bc81-b5d69df1b28a",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        0
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 520,
        "content": "## 🛠️ 先决条件"
      },
      "typeVersion": 1
    },
    {
      "id": "50b85307-3566-4b05-b7a7-459864f53362",
      "name": "### 需要帮助？",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2740,
        1120
      ],
      "parameters": {
        "color": 6,
        "width": 420,
        "content": "### 支持"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6da9d4a4-381a-4ecf-bb5d-d92075e7be16",
  "connections": {
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Message a model",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model": {
      "main": [
        [
          {
            "node": "Send Personalized emails",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}