8
n8n 中文网amn8n.com

使用Google Sheets、日历、邮件和Slack自动化绩效评估流程

高级

这是一个HR领域的自动化工作流，包含 16 个节点。主要使用 If, Set, Code, Slack, SplitOut 等节点。 使用Google Sheets、日历、邮件和Slack自动化绩效评估流程

前置要求
  • •Slack Bot Token 或 Webhook URL
  • •Google Sheets API 凭证

使用的节点 (16)

If
Set
Code
Slack
SplitOut
EmailSend
StickyNote
GoogleSheets
GoogleCalendar
ScheduleTrigger

分类

人力资源
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "rPl99EYLVHLCXg0B",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "绩效评估调度与提醒",
  "tags": [],
  "nodes": [
    {
      "id": "ce6f4776-596d-498a-b3f6-2746d2e077ac",
      "name": "每日早上 8 点检查",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1568,
        160
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "4a46b397-1c45-4f1c-9fd2-03922787e2ea",
      "name": "获取评估日程",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1344,
        160
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "ReviewSchedule"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_REVIEW_SPREADSHEET_ID"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "427bb5c4-6675-4a32-b13d-acd17a748a57",
      "name": "筛选即将到来的评估",
      "type": "n8n-nodes-base.code",
      "position": [
        -1152,
        160
      ],
      "parameters": {
        "jsCode": "const items = $input.all();\nconst today = $now.toDate();\nconst threeDaysLater = new Date(today);\nthreeDaysLater.setDate(today.getDate() + 3);\n\nconst upcomingReviews = items.filter(item => {\n  const reviewDate = new Date(item.json.ReviewDate);\n  return reviewDate >= today && reviewDate <= threeDaysLater && item.json.Status !== 'Completed';\n});\n\nconst todayReviews = upcomingReviews.filter(item => {\n  const reviewDate = new Date(item.json.ReviewDate);\n  return reviewDate.toDateString() === today.toDateString();\n});\n\nconst reminderReviews = upcomingReviews.filter(item => {\n  const reviewDate = new Date(item.json.ReviewDate);\n  return reviewDate.toDateString() !== today.toDateString();\n});\n\nreturn {\n  upcomingReviews: upcomingReviews,\n  todayReviews: todayReviews,\n  reminderReviews: reminderReviews\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "86940cc8-365c-4045-b316-58a27f0ca209",
      "name": "已安排评估？",
      "type": "n8n-nodes-base.if",
      "position": [
        -944,
        160
      ],
      "parameters": {
        "conditions": {
          "number": [
            {
              "value1": "={{$json.upcomingReviews.length}}",
              "operation": "larger"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f764fef2-2e57-4797-9252-edfee5648ec5",
      "name": "拆分为项目",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -752,
        160
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "upcomingReviews"
      },
      "typeVersion": 1
    },
    {
      "id": "3e05bca6-7db2-4153-858d-3843e805ee2c",
      "name": "准备评估数据",
      "type": "n8n-nodes-base.set",
      "position": [
        -544,
        160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "calendar_event",
              "name": "calendarEventId",
              "type": "string",
              "value": "={{$json.CalendarEventId}}"
            },
            {
              "id": "employee_name",
              "name": "employeeName",
              "type": "string",
              "value": "={{$json.EmployeeName}}"
            },
            {
              "id": "reviewer_name",
              "name": "reviewerName",
              "type": "string",
              "value": "={{$json.ReviewerName}}"
            },
            {
              "id": "review_date",
              "name": "reviewDate",
              "type": "string",
              "value": "={{$json.ReviewDate}}"
            },
            {
              "id": "review_type",
              "name": "reviewType",
              "type": "string",
              "value": "={{$json.ReviewType}}"
            },
            {
              "id": "employee_email",
              "name": "employeeEmail",
              "type": "string",
              "value": "={{$json.EmployeeEmail}}"
            },
            {
              "id": "reviewer_email",
              "name": "reviewerEmail",
              "type": "string",
              "value": "={{$json.ReviewerEmail}}"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "629584ef-1552-4f7f-af54-93131d0f4ff6",
      "name": "发送电子邮件提醒",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -352,
        64
      ],
      "webhookId": "dc3907f7-78c5-4990-a840-9155b7eb9b33",
      "parameters": {
        "options": {},
        "subject": "=🎯 Performance Review Reminder - {{$json.employeeName}}",
        "toEmail": "={{$json.employeeEmail}}, {{$json.reviewerEmail}}",
        "fromEmail": "hr@yourcompany.com"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "1e20e938-b64e-4c9f-ba21-9aa768446064",
      "name": "更新日历事件",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        -352,
        256
      ],
      "parameters": {
        "end": "2025-10-24T00:00:00",
        "start": "2025-10-16T00:00:00",
        "calendar": "primary",
        "additionalFields": {}
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "6ldLmzzYtaqng4pw",
          "name": "Google Calendar account - test"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "fe4e328e-f85e-400c-97c4-33610d3a0cfe",
      "name": "在 Slack 上通知 HR",
      "type": "n8n-nodes-base.slack",
      "position": [
        -144,
        160
      ],
      "webhookId": "26fb8c97-1e61-43bc-ab08-46b83b156c21",
      "parameters": {
        "text": "=🎯 *Performance Review Reminder Sent*\n\n*Employee:* {{$json.employeeName}}\n*Reviewer:* {{$json.reviewerName}}\n*Review Type:* {{$json.reviewType}}\n*Scheduled Date:* {{$json.reviewDate}}\n\n📧 Reminder emails sent to both parties\n📅 Calendar event updated",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "MQ0fgwuS8AzfwFvy",
          "name": "Slack account - test "
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "ee18e67d-1af3-48e0-b614-95b80fc80da0",
      "name": "更新评估状态",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        160
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "ReviewSchedule"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_REVIEW_SPREADSHEET_ID"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "3a012941-6f69-44f8-ace3-2368a75d76c3",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1600,
        -80
      ],
      "parameters": {
        "color": 4,
        "width": 176,
        "height": 404,
        "content": "## 每日早晨检查"
      },
      "typeVersion": 1
    },
    {
      "id": "46806887-42b2-438c-8b1a-1602abb5ed0d",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1408,
        -80
      ],
      "parameters": {
        "color": 4,
        "width": 192,
        "height": 404,
        "content": "## 获取评估日程"
      },
      "typeVersion": 1
    },
    {
      "id": "d2559dee-a579-4173-ae68-d6cd86f20306",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1184,
        -80
      ],
      "parameters": {
        "color": 4,
        "width": 192,
        "height": 404,
        "content": "## 筛选即将到来的评估"
      },
      "typeVersion": 1
    },
    {
      "id": "318eb680-fba0-4aff-bf42-bf3fbac19020",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -976,
        -80
      ],
      "parameters": {
        "color": 4,
        "width": 192,
        "height": 404,
        "content": "## 验证日程"
      },
      "typeVersion": 1
    },
    {
      "id": "dcfa2a1a-e180-4c48-b55e-259dc81c4bf6",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        -80
      ],
      "parameters": {
        "color": 4,
        "width": 320,
        "height": 404,
        "content": "## 处理每个评估"
      },
      "typeVersion": 1
    },
    {
      "id": "0c5a911d-494f-4097-a102-0dc421af21b6",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        -144
      ],
      "parameters": {
        "color": 4,
        "width": 540,
        "height": 580,
        "content": "## 多渠道通知与跟踪"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "45f2da8b-5c9e-4979-83b5-fa12aa5a3087",
  "connections": {
    "f764fef2-2e57-4797-9252-edfee5648ec5": {
      "main": [
        [
          {
            "node": "3e05bca6-7db2-4153-858d-3843e805ee2c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fe4e328e-f85e-400c-97c4-33610d3a0cfe": {
      "main": [
        [
          {
            "node": "ee18e67d-1af3-48e0-b614-95b80fc80da0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "86940cc8-365c-4045-b316-58a27f0ca209": {
      "main": [
        [
          {
            "node": "f764fef2-2e57-4797-9252-edfee5648ec5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ce6f4776-596d-498a-b3f6-2746d2e077ac": {
      "main": [
        [
          {
            "node": "4a46b397-1c45-4f1c-9fd2-03922787e2ea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4a46b397-1c45-4f1c-9fd2-03922787e2ea": {
      "main": [
        [
          {
            "node": "427bb5c4-6675-4a32-b13d-acd17a748a57",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3e05bca6-7db2-4153-858d-3843e805ee2c": {
      "main": [
        [
          {
            "node": "629584ef-1552-4f7f-af54-93131d0f4ff6",
            "type": "main",
            "index": 0
          },
          {
            "node": "1e20e938-b64e-4c9f-ba21-9aa768446064",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "629584ef-1552-4f7f-af54-93131d0f4ff6": {
      "main": [
        [
          {
            "node": "fe4e328e-f85e-400c-97c4-33610d3a0cfe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1e20e938-b64e-4c9f-ba21-9aa768446064": {
      "main": [
        [
          {
            "node": "fe4e328e-f85e-400c-97c4-33610d3a0cfe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "427bb5c4-6675-4a32-b13d-acd17a748a57": {
      "main": [
        [
          {
            "node": "86940cc8-365c-4045-b316-58a27f0ca209",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

高级 - 人力资源

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

AI候选人筛选与面试安排系统
基于AI的候选人筛选与面试安排（OpenAI GPT与Google套件）
If
Code
Webhook
+
If
Code
Webhook
18 节点Oneclick AI Squad
人力资源
财务薪资自动化与员工工资通知系统
通过GPT-4、Google Sheets、PDF工资单和Slack提醒自动化薪资处理
Code
Slack
Email Send
+
Code
Slack
Email Send
14 节点Oneclick AI Squad
人力资源
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+
If
Set
Code
22 节点Oneclick AI Squad
社交媒体
使用Google Calendar和Gmail提醒的自动化候选人面试跟踪器
使用Google Calendar、Sheets和Gmail警报自动跟踪面试
If
Gmail
Filter
+
If
Gmail
Filter
13 节点Oneclick AI Squad
人力资源
面向财务与会计的 AI 驱动发票提醒与付款追踪器
基于AI的发票提醒与付款追踪器，专为财务与会计设计
If
Set
Code
+
If
Set
Code
35 节点Oneclick AI Squad
发票处理
实时参会者参与度和反馈分析器
使用情绪分析、Google Sheets、Slack和邮件分析活动反馈
If
Set
Slack
+
If
Set
Slack
14 节点Oneclick AI Squad
市场调研
工作流信息
难度等级
高级
节点数量16
分类1
节点类型10
难度说明

适合高级用户，包含 16+ 个节点的复杂工作流

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看 →

分享此工作流

分类

多模态 AI
1540
人工智能
1108
内容创作
695
AI 摘要总结
516
营销
419
AI 聊天机器人
251
工程
241
市场调研
203
杂项
193
其他
176
销售
162
IT 运维
156
文档提取
147
AI RAG 检索增强
146
构建模块
144
社交媒体
137
潜在客户开发
125
个人效率
117
开发运维
111
人力资源
101
客户支持
97
客户培育
87
客户关系管理
82
财务
81
产品
77
客服机器人
76
设计
70
工单管理
67
安全运维
57
发票处理
53
加密货币交易
49
文件管理
39
项目管理
35
内部知识库
32

分类: 34