每日邮件调度器

Name: 每日邮件调度器
Rating: 4.5 (10 reviews)
Author: Yar Malik (Asfandyar)

初级

这是一个Project Management领域的自动化工作流，包含 4 个节点。主要使用 If, Gmail, GoogleSheets, ManualTrigger 等节点。从 Google Sheets 使用 Gmail 安排每日邮件提醒

前置要求

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

使用的节点 (4)

Gmail

GoogleSheets

ManualTrigger

分类

项目管理

工作流预览

可视化展示节点连接关系，支持缩放和平移

当点击"执行工作流"时

获取表中的行

如果

发送消息

React Flow

导出工作流

复制以下 JSON 配置到 n8n 导入，即可使用此工作流

{
  "id": "Aj0B0tfHgAYgFAZh",
  "meta": {
    "instanceId": "7b35059aff065837b1c7d24142b37474554b08b3370f3096b2e57345690d178e",
    "templateCredsSetupCompleted": true
  },
  "name": "每日邮件调度器",
  "tags": [],
  "nodes": [
    {
      "id": "3f436ab2-5937-4e74-8ee1-601181655406",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -380,
        -100
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a7566e68-2613-4cd8-9307-ecdabb10cb9d",
      "name": "获取表中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        -100
      ],
      "parameters": {
        "options": {},
        "sheetName": "YOUR_SHEET_NAME",
        "documentId": "YOUR_SHEET_ID"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "REDACTED",
          "name": "Google Sheets – Team Account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "e424a6a7-25ac-4258-8ec2-63f25c4ce2cb",
      "name": "如果",
      "type": "n8n-nodes-base.if",
      "position": [
        120,
        -100
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "7e87aee9-3061-4daf-ae3c-0fed5ed1480b",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['Due Date'] }}",
              "rightValue": "={{ $now.format('yyyy-MM-dd') }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "ba1beadf-7a42-4a50-b0e6-8476528ed4dd",
      "name": "发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        340,
        -200
      ],
      "parameters": {
        "sendTo": "={{ $json.Email }}",
        "message": "={{ $json.Body }}",
        "options": {},
        "subject": "={{ $json.Subject }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "REDACTED",
          "name": "Gmail – Notification Account"
        }
      },
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "48622611-63c6-4ded-baa3-ab8eb91fc2af",
  "connections": {
    "If": [
      [
        {
          "node": "Send a message",
          "type": "main",
          "index": 0
        }
      ]
    ],
    "Get row(s) in sheet": [
      [
        {
          "node": "If",
          "type": "main",
          "index": 0
        }
      ]
    ],
    "When clicking ‘Execute workflow’": [
      [
        {
          "node": "Get row(s) in sheet",
          "type": "main",
          "index": 0
        }
      ]
    ]
  }
}

常见问题