8
n8n 中文网amn8n.com

财务薪资自动化与员工工资通知系统

中级

这是一个HR, AI Summarization领域的自动化工作流，包含 14 个节点。主要使用 Code, Slack, EmailSend, HttpRequest, GoogleSheets 等节点。 通过GPT-4、Google Sheets、PDF工资单和Slack提醒自动化薪资处理

前置要求
  • •Slack Bot Token 或 Webhook URL
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (14)

Code
Slack
EmailSend
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger

分类

人力资源
AI 摘要总结
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "DxYWzfjdkoT4gsJP",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "财务薪资自动化与员工工资通知系统",
  "tags": [],
  "nodes": [
    {
      "id": "3cb9d411-385c-4aba-889a-dfc0739b4f17",
      "name": "月度薪资触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1296,
        96
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "monthDays"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "39234bd7-8085-40fc-859a-6f33b7e04299",
      "name": "获取员工数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1088,
        96
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Employees"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_EMPLOYEE_SPREADSHEET_ID"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "c4944ba0-64d6-45eb-b1bd-8cd715be4906",
      "name": "AI计算工资",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -896,
        96
      ],
      "parameters": {
        "url": "https://api.openai.com/v1/chat/completions",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "model",
              "value": "gpt-4"
            },
            {
              "name": "messages",
              "value": "=[{\"role\":\"system\",\"content\":\"Calculate net salary with deductions (tax, insurance, provident fund). Return JSON format.\"},{\"role\":\"user\",\"content\":\"Employee: {{$json.Name}}, Base Salary: {{$json.BaseSalary}}, Allowances: {{$json.Allowances}}, Deductions: {{$json.Deductions}}\"}]"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "b940216a-b05d-4614-baa4-6c066d74ba0d",
      "name": "格式化工资单数据",
      "type": "n8n-nodes-base.code",
      "position": [
        -688,
        96
      ],
      "parameters": {
        "jsCode": "const response = JSON.parse($input.item.json.choices[0].message.content);\nconst employee = $input.first().json;\n\nreturn {\n  employeeName: employee.Name,\n  employeeEmail: employee.Email,\n  employeeId: employee.EmployeeId,\n  baseSalary: employee.BaseSalary,\n  allowances: employee.Allowances || 0,\n  deductions: response.totalDeductions || 0,\n  netSalary: response.netSalary,\n  taxDeducted: response.tax || 0,\n  month: $now.format('MMMM YYYY'),\n  paymentDate: $now.format('YYYY-MM-DD')\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "4631a9fd-8c74-4c37-8bd8-41ed04ad4a09",
      "name": "记录到工资表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -496,
        -16
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Payroll"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_PAYROLL_SPREADSHEET_ID"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "3f324479-109f-4ac7-93ae-0280449bfee3",
      "name": "生成PDF工资单",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -496,
        192
      ],
      "parameters": {
        "url": "https://api.pdfmonkey.io/api/v1/documents",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "document",
              "value": "={\"template_id\":\"YOUR_TEMPLATE_ID\",\"payload\":{\"name\":\"{{$json.employeeName}}\",\"employee_id\":\"{{$json.employeeId}}\",\"month\":\"{{$json.month}}\",\"base_salary\":{{$json.baseSalary}},\"allowances\":{{$json.allowances}},\"deductions\":{{$json.deductions}},\"net_salary\":{{$json.netSalary}}}}"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "9f4d32d1-27f7-46c7-b365-635880f02edb",
      "name": "通过邮件发送工资单给员工",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -288,
        96
      ],
      "webhookId": "fe11436a-b668-4150-83cb-aa5d8383b7c8",
      "parameters": {
        "options": {
          "attachments": "payslip_{{$json.employeeId}}_{{$json.month}}.pdf"
        },
        "subject": "=💰 Salary Credited - {{$json.month}}",
        "toEmail": "={{$json.employeeEmail}}",
        "fromEmail": "payroll@yourcompany.com"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "e00da244-b83e-4dda-af10-1a3324efd26b",
      "name": "在Slack上通知HR",
      "type": "n8n-nodes-base.slack",
      "position": [
        -96,
        96
      ],
      "webhookId": "bb2bbe41-bb2d-44e3-bba1-8f66f1890895",
      "parameters": {
        "text": "=✅ *Payroll Processed*\n\n*Employee:* {{$json.employeeName}} ({{$json.employeeId}})\n*Month:* {{$json.month}}\n*Net Salary:* ₹{{$json.netSalary}}\n*Status:* Payment notification sent",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "credentials": {
        "slackApi": {
          "id": "MQ0fgwuS8AzfwFvy",
          "name": "Slack account - test "
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "4d930483-8b0c-4a0c-a2f4-a7b0ff078e42",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1328,
        -112
      ],
      "parameters": {
        "color": 3,
        "width": 164,
        "height": 388,
        "content": "## 每月28日运行"
      },
      "typeVersion": 1
    },
    {
      "id": "17061c8c-052e-4ca4-8127-d04b2e58c8bb",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -112
      ],
      "parameters": {
        "color": 4,
        "width": 164,
        "height": 388,
        "content": "## 获取员工数据"
      },
      "typeVersion": 1
    },
    {
      "id": "3a70d888-a681-4e60-a3af-c584d14a717c",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -944,
        -112
      ],
      "parameters": {
        "color": 2,
        "width": 180,
        "height": 388,
        "content": "## AI计算净工资"
      },
      "typeVersion": 1
    },
    {
      "id": "274935a9-a136-491a-8414-929f4a1a5923",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -736,
        -112
      ],
      "parameters": {
        "color": 6,
        "width": 180,
        "height": 388,
        "content": "## 构建工资单数据"
      },
      "typeVersion": 1
    },
    {
      "id": "ac826f4e-5b65-4ec9-a825-11158a001151",
      "name": "便签说明4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -208
      ],
      "parameters": {
        "width": 196,
        "height": 580,
        "content": "## 记录和生成文档"
      },
      "typeVersion": 1
    },
    {
      "id": "7671884f-e6bc-4355-96fd-da5c65b17ff6",
      "name": "便签说明5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        -112
      ],
      "parameters": {
        "color": 5,
        "width": 356,
        "height": 452,
        "content": "## 多渠道通知"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "98d132d3-d691-4de4-a19e-0d1f5b3dfeb0",
  "connections": {
    "Get Employee Data": {
      "main": [
        [
          {
            "node": "AI Calculate Salary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Calculate Salary": {
      "main": [
        [
          {
            "node": "Format Payslip Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Payslip Data": {
      "main": [
        [
          {
            "node": "Log to Payroll Sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate PDF Payslip",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate PDF Payslip": {
      "main": [
        [
          {
            "node": "Email Payslip to Employee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Payroll Sheet": {
      "main": [
        [
          {
            "node": "Email Payslip to Employee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monthly Payroll Trigger": {
      "main": [
        [
          {
            "node": "Get Employee Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Payslip to Employee": {
      "main": [
        [
          {
            "node": "Notify HR on Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 人力资源, AI 摘要总结

需要付费吗？

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

相关工作流推荐

AI驱动的税务截止日期提醒与合规警报（会计用）
使用GPT-4、Google Sheets和Slack的税务截止日期管理与合规警报
If
Code
Slack
+5
19 节点Oneclick AI Squad
文档提取
绩效评估调度与提醒
使用Google Sheets、日历、邮件和Slack自动化绩效评估流程
If
Set
Code
+7
16 节点Oneclick AI Squad
人力资源
员工考勤追踪器（含每日摘要）
使用 Google Sheets 分析、邮件报告和 Slack 警报跟踪员工考勤
If
Code
Slack
+4
15 节点Oneclick AI Squad
人力资源
AI候选人筛选与面试安排系统
基于AI的候选人筛选与面试安排（OpenAI GPT与Google套件）
If
Code
Webhook
+6
18 节点Oneclick AI Squad
人力资源
面向财务专业人士的自动化每日现金流与费用报告
使用Google表格、Slack和邮件为财务团队生成每日现金流报告
Code
Merge
Slack
+7
25 节点Oneclick AI Squad
文档提取
实时银行交易监控和会计团队警报系统
监控银行交易并为会计团队提供多通道告警
If
Code
Merge
+6
32 节点Oneclick AI Squad
文档提取
工作流信息
难度等级
中级
节点数量14
分类2
节点类型7
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
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 查看 →

分享此工作流