8
n8n 中文网amn8n.com

绩效评估调度与提醒

高级

这是一个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": {
    "Split Into Items": {
      "main": [
        [
          {
            "node": "Prepare Review Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notify HR on Slack": {
      "main": [
        [
          {
            "node": "Update Review Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reviews Scheduled?": {
      "main": [
        [
          {
            "node": "Split Into Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Check at 8 AM": {
      "main": [
        [
          {
            "node": "Get Review Schedule",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Review Schedule": {
      "main": [
        [
          {
            "node": "Filter Upcoming Reviews",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Review Data": {
      "main": [
        [
          {
            "node": "Send Email Reminder",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update Calendar Event",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Reminder": {
      "main": [
        [
          {
            "node": "Notify HR on Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Calendar Event": {
      "main": [
        [
          {
            "node": "Notify HR on Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Upcoming Reviews": {
      "main": [
        [
          {
            "node": "Reviews Scheduled?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 人力资源

需要付费吗？

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

相关工作流推荐

员工考勤追踪器（含每日摘要）
使用 Google Sheets 分析、邮件报告和 Slack 警报跟踪员工考勤
If
Code
Slack
+4
15 节点Oneclick AI Squad
人力资源
AI候选人筛选与面试安排系统
基于AI的候选人筛选与面试安排（OpenAI GPT与Google套件）
If
Code
Webhook
+6
18 节点Oneclick AI Squad
人力资源
财务薪资自动化与员工工资通知系统
通过GPT-4、Google Sheets、PDF工资单和Slack提醒自动化薪资处理
Code
Slack
Email Send
+4
14 节点Oneclick AI Squad
人力资源
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
实时银行交易监控和会计团队警报系统
监控银行交易并为会计团队提供多通道告警
If
Code
Merge
+6
32 节点Oneclick AI Squad
文档提取
AI驱动的税务截止日期提醒与合规警报（会计用）
使用GPT-4、Google Sheets和Slack的税务截止日期管理与合规警报
If
Code
Slack
+5
19 节点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 查看 →

分享此工作流