財務・給与自動化と従業員の給与通知システム
中級
これはHR, AI Summarization分野の自動化ワークフローで、14個のノードを含みます。主にCode, Slack, EmailSend, HttpRequest, GoogleSheetsなどのノードを使用。 GPT-4、Google Sheets、PDF給与明細、Slackリマインダーを使用した給与処理の自動化
前提条件
- •Slack Bot Token または Webhook URL
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "DxYWzfjdkoT4gsJP",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Payroll Automation & Employee Salary Notification System for Finance",
"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での人事部通知",
"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": "## Runs monthly on 28th\n\nAutomated payroll trigger"
},
"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": "## Fetches employee data\n\nRetrieves salary info from sheet"
},
"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 calculates net salary\n\nApplies tax & deductions"
},
"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": "## Structures payslip data\n\nPrepares for distribution"
},
"typeVersion": 1
},
{
"id": "ac826f4e-5b65-4ec9-a825-11158a001151",
"name": "付箋メモ4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
-208
],
"parameters": {
"width": 196,
"height": 580,
"content": "## Records & generates docs\n\nLogs payroll + creates PDF"
},
"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": "## Multi-channel notification\n\nEmployee email + HR Slack alert"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "98d132d3-d691-4de4-a19e-0d1f5b3dfeb0",
"connections": {
"39234bd7-8085-40fc-859a-6f33b7e04299": {
"main": [
[
{
"node": "c4944ba0-64d6-45eb-b1bd-8cd715be4906",
"type": "main",
"index": 0
}
]
]
},
"c4944ba0-64d6-45eb-b1bd-8cd715be4906": {
"main": [
[
{
"node": "b940216a-b05d-4614-baa4-6c066d74ba0d",
"type": "main",
"index": 0
}
]
]
},
"b940216a-b05d-4614-baa4-6c066d74ba0d": {
"main": [
[
{
"node": "4631a9fd-8c74-4c37-8bd8-41ed04ad4a09",
"type": "main",
"index": 0
},
{
"node": "3f324479-109f-4ac7-93ae-0280449bfee3",
"type": "main",
"index": 0
}
]
]
},
"3f324479-109f-4ac7-93ae-0280449bfee3": {
"main": [
[
{
"node": "9f4d32d1-27f7-46c7-b365-635880f02edb",
"type": "main",
"index": 0
}
]
]
},
"4631a9fd-8c74-4c37-8bd8-41ed04ad4a09": {
"main": [
[
{
"node": "9f4d32d1-27f7-46c7-b365-635880f02edb",
"type": "main",
"index": 0
}
]
]
},
"3cb9d411-385c-4aba-889a-dfc0739b4f17": {
"main": [
[
{
"node": "39234bd7-8085-40fc-859a-6f33b7e04299",
"type": "main",
"index": 0
}
]
]
},
"9f4d32d1-27f7-46c7-b365-635880f02edb": {
"main": [
[
{
"node": "e00da244-b83e-4dda-af10-1a3324efd26b",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 人事, AI要約
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
パフォーマンス評価スケジューリングとアラート
Google Sheets、カレンダー、メール、Slackを使ってパフォーマンス評価プロセスを自動化
If
Set
Code
+
If
Set
Code
16 ノードOneclick AI Squad
人事
AI候補者選考・面接スケジュールシステム
AIベースの候補者スクリーニングと面接スケジューリング（OpenAI GPTとGoogleスイート）
If
Code
Webhook
+
If
Code
Webhook
18 ノードOneclick AI Squad
人事
財務専門家向けの自動化された毎日のキャッシュフローと費用レポート
Google Table、Slack、メールを使用した財務チーム向けの毎日のキャッシュフローリポート生成
Code
Merge
Slack
+
Code
Merge
Slack
25 ノードOneclick AI Squad
文書抽出
スマート在庫補充と自動発注
OpenAI予測とERP統合に基づくAI駆動型在庫管理
Code
Filter
Postgres
+
Code
Filter
Postgres
24 ノードOneclick AI Squad
文書抽出
Instagram インフルエンサーの成果物および契約準拠性の自動化
Claude AI と Slack アラートを使って Instagram インフルエンサー契約の合従性を自動化
If
Set
Code
+
If
Set
Code
26 ノードOneclick AI Squad
ソーシャルメディア
AIメール解析で履歴書スクリーニングと候補者検証を自動化
AIとメール解析を使ってリゾームのスクリーニングと候補者検証を自動化
If
Code
Wait
+
If
Code
Wait
14 ノードOneclick AI Squad
人事
ワークフロー情報
難易度
中級
ノード数14
カテゴリー2
ノードタイプ7
作成者
Oneclick AI Squad
@oneclick-aiThe 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で表示 →
このワークフローを共有