使用Google Sheet和Gmail实现电商生日折扣邮件自动化

• •Google 账号和 Gmail API 凭证
• •Google Sheets API 凭证

{
  "id": "YvShKs1XBbEEboRO",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae",
    "templateCredsSetupCompleted": true
  },
  "name": "工作流说明：使用 Google Sheet 和 Gmail 实现的电子商务自动化生日折扣",
  "tags": [],
  "nodes": [
    {
      "id": "ce1fb25e-decc-4943-ae7c-cb16d6377344",
      "name": "每日计划",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        224,
        224
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6ec3e314-e7d2-4548-936e-07d47a62e400",
      "name": "获取客户数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        464,
        224
      ],
      "parameters": {
        "operation": "getAll",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": null,
          "name": "YOUR_GOOGLE_SHEETS_CREDENTIAL"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "fdce0115-b0c4-4660-81aa-87f83075bf09",
      "name": "是他们的生日吗？",
      "type": "n8n-nodes-base.if",
      "position": [
        704,
        224
      ],
      "parameters": {
        "conditions": {
          "boolean": [
            {
              "value1": "={{ $json.birthday }}",
              "value2": "={{ $now.toFormat('MM-dd') }}"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "62332fbf-d069-46e3-a19e-0d6c45bd588f",
      "name": "生成折扣码",
      "type": "n8n-nodes-base.function",
      "position": [
        944,
        224
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b93688ae-975a-4278-9fa6-015ab3e9b7d9",
      "name": "发送生日邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1184,
        224
      ],
      "parameters": {
        "message": "Hi {{ $json.name }},\n\nHappy Birthday! We wanted to celebrate you with a special gift.\n\nHere is your unique discount code for 20% off your next order:\n\n{{ $json.discountCode }}\n\nEnjoy your day!\n\nBest regards,\nYour E-commerce Team",
        "subject": "Happy Birthday! Here's a gift from us!",
        "additionalFields": {}
      },
      "credentials": {
        "gmailOAuth2": {
          "id": null,
          "name": "YOUR_GMAIL_CREDENTIAL"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "b6f9b241-4f67-47d5-8c26-5a13b1587567",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        176
      ],
      "parameters": {
        "color": 3,
        "width": 1232,
        "height": 224,
        "content": "## 流程"
      },
      "typeVersion": 1
    },
    {
      "id": "89f14e7e-81a3-4206-b7e4-09cac5daf811",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        448
      ],
      "parameters": {
        "color": 4,
        "width": 1232,
        "height": 1072,
        "content": "# ⚙ 工作流说明：电子商务自动化生日折扣"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "55533bfd-b195-447d-987c-7f248288c5ae",
  "connections": {
    "ce1fb25e-decc-4943-ae7c-cb16d6377344": {
      "main": [
        [
          {
            "node": "6ec3e314-e7d2-4548-936e-07d47a62e400",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6ec3e314-e7d2-4548-936e-07d47a62e400": {
      "main": [
        [
          {
            "node": "fdce0115-b0c4-4660-81aa-87f83075bf09",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fdce0115-b0c4-4660-81aa-87f83075bf09": {
      "main": [
        [
          {
            "node": "62332fbf-d069-46e3-a19e-0d6c45bd588f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "62332fbf-d069-46e3-a19e-0d6c45bd588f": {
      "main": [
        [
          {
            "node": "b93688ae-975a-4278-9fa6-015ab3e9b7d9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}