8
n8n 中文网amn8n.com

员工时间追踪系统(含GPT-4o报告和Gmail通知)

高级

这是一个HR, AI Summarization领域的自动化工作流,包含 33 个节点。主要使用 If, Set, Gmail, Switch, Webhook 等节点。 员工时间追踪系统,包含GPT-4o报告和Gmail通知功能

前置要求
  • Google 账号和 Gmail API 凭证
  • HTTP Webhook 端点(n8n 会自动生成)
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "5935d23fce125caa8ab93af824f47776e317d824634bf7b68a810b49a4038f0a",
    "templateId": "2447",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "70424282-dcce-4f1a-aba0-af0e7947a4fd",
      "name": "设置休息时长",
      "type": "n8n-nodes-base.set",
      "position": [
        1664,
        912
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9261c98a-3099-4409-b697-8c28f6ec0c06",
              "name": "break_duration",
              "type": "number",
              "value": "={{ $('Webhook - Track Time').item.json.body.duration }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "875f1969-4958-4450-87a5-aad1f65b3a9d",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        736,
        912
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Start",
              "conditions": {
                "options": {
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.body.method }}",
                    "rightValue": "start"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Break",
              "conditions": {
                "options": {
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "6ddd1f12-a0d8-42df-9776-dff0f44ba82c",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.body.method }}",
                    "rightValue": "break"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "End",
              "conditions": {
                "options": {
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "61550dac-65a2-4e4b-99a8-4df4a357cec0",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.body.method }}",
                    "rightValue": "end"
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3.1
    },
    {
      "id": "8cbdbe7f-3c32-48bb-bce6-80b918a7c31e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        240
      ],
      "parameters": {
        "width": 1407,
        "height": 470,
        "content": "## 开始"
      },
      "typeVersion": 1
    },
    {
      "id": "e930da00-916b-4767-a34e-b985d97090ca",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        752
      ],
      "parameters": {
        "width": 1407,
        "height": 597,
        "content": "## 休息"
      },
      "typeVersion": 1
    },
    {
      "id": "6b77fcde-e3ed-4cfa-bd89-9d1cc6660591",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        1392
      ],
      "parameters": {
        "width": 1407,
        "height": 628,
        "content": "## 结束"
      },
      "typeVersion": 1
    },
    {
      "id": "85b40d37-3a55-4346-8c94-60eb2f8b6dba",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        240
      ],
      "parameters": {
        "color": 4,
        "width": 538.9177312302156,
        "height": 1760.750302860566,
        "content": "## 等待"
      },
      "typeVersion": 1
    },
    {
      "id": "bfe988d1-81c5-4c70-affd-220cfc5016da",
      "name": "响应 Webhook",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        3120,
        1008
      ],
      "parameters": {
        "options": {},
        "respondWith": "text",
        "responseBody": "={{ $json.message }}"
      },
      "typeVersion": 1.1
    },
    {
      "id": "585efbae-ec10-4ef4-90a0-7bad55b4a150",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2432,
        240
      ],
      "parameters": {
        "color": 4,
        "width": 415.1572200385813,
        "height": 1766.1026447605514,
        "content": "## 响应"
      },
      "typeVersion": 1
    },
    {
      "id": "b75485ce-d365-4743-a4ee-e16799e12c24",
      "name": "Webhook - 跟踪时间",
      "type": "n8n-nodes-base.webhook",
      "position": [
        512,
        928
      ],
      "webhookId": "752a7723-87b6-470f-a7d3-f627f6457e39",
      "parameters": {
        "path": "track-time",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    },
    {
      "id": "aca3ed81-1dbd-4439-8e00-41d63e8d9317",
      "name": "条件判断1",
      "type": "n8n-nodes-base.if",
      "position": [
        1408,
        928
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c3da335c-90d9-4ac0-b470-dc91fd73bfe3",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.start }}",
              "rightValue": "={{ $today }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "5041890d-630e-4814-85f0-e02d3f7d0a95",
      "name": "获取行数据",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        1136,
        928
      ],
      "parameters": {
        "operation": "get",
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "09233c72-63c8-48b3-9dee-2463b12b395e",
      "name": "更新行数据",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        1968,
        912
      ],
      "parameters": {
        "columns": {
          "value": {
            "break": "={{ $('Webhook - Track Time').item.json.body.duration }}",
            "start": "={{ $today }}",
            "Employee": "={{ $('Webhook - Track Time').item.json.headers.id }}"
          },
          "schema": [
            {
              "id": "Employee",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Employee",
              "defaultMatch": false
            },
            {
              "id": "start",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "start",
              "defaultMatch": false
            },
            {
              "id": "end",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "end",
              "defaultMatch": false
            },
            {
              "id": "break",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "break",
              "defaultMatch": false
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "filters": {
          "conditions": [
            {
              "keyName": "start",
              "keyValue": "={{ $today }}"
            }
          ]
        },
        "options": {},
        "operation": "update",
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6f21b44e-3c08-482e-8540-c879d8cb338f",
      "name": "错误",
      "type": "n8n-nodes-base.set",
      "position": [
        2592,
        1184
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "419d7570-d1ce-44b1-814c-7757da92a188",
              "name": "message",
              "type": "string",
              "value": "=ERROR"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "9a549bad-dab1-4909-8cbc-66888ec29289",
      "name": "插入行",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        1712,
        512
      ],
      "parameters": {
        "columns": {
          "value": {
            "start": "={{ $today }}",
            "Employee": "={{ $('Webhook - Track Time').item.json.headers.id }}"
          },
          "schema": [
            {
              "id": "Employee",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Employee",
              "defaultMatch": false
            },
            {
              "id": "start",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "start",
              "defaultMatch": false
            },
            {
              "id": "end",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "end",
              "defaultMatch": false
            },
            {
              "id": "break",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "break",
              "defaultMatch": false
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6d37fe25-3479-496f-bf5c-00027c5fdc60",
      "name": "如果",
      "type": "n8n-nodes-base.if",
      "position": [
        1440,
        1552
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c3da335c-90d9-4ac0-b470-dc91fd73bfe3",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.start }}",
              "rightValue": "={{ $today }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "65726b45-9052-44a5-ab3e-b81faf34959a",
      "name": "获取行数据2",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        1184,
        1536
      ],
      "parameters": {
        "operation": "get",
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f9c58330-acef-4eb4-9561-2d350f74f7e5",
      "name": "更新行数据1",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2016,
        1536
      ],
      "parameters": {
        "columns": {
          "value": {
            "end": "={{ $now }}",
            "break": "={{ $('Get row(s)2').item.json.break }}",
            "start": "={{ $today }}",
            "Employee": "={{ $('Webhook - Track Time').item.json.headers.id }}"
          },
          "schema": [
            {
              "id": "Employee",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Employee",
              "defaultMatch": false
            },
            {
              "id": "start",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "start",
              "defaultMatch": false
            },
            {
              "id": "end",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "end",
              "defaultMatch": false
            },
            {
              "id": "break",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "break",
              "defaultMatch": false
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "filters": {
          "conditions": [
            {
              "keyName": "start",
              "keyValue": "={{ $today }}"
            }
          ]
        },
        "options": {},
        "operation": "update",
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "51e7d283-9d69-4730-9f39-81b76bee57aa",
      "name": "错误1",
      "type": "n8n-nodes-base.set",
      "position": [
        2608,
        1776
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "419d7570-d1ce-44b1-814c-7757da92a188",
              "name": "message",
              "type": "string",
              "value": "=ERROR"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4ee9a3bf-7173-47de-a35f-9de4eaa2c562",
      "name": "结束",
      "type": "n8n-nodes-base.set",
      "position": [
        1744,
        1520
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9261c98a-3099-4409-b697-8c28f6ec0c06",
              "name": "end",
              "type": "string",
              "value": "={{ $now }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "69235db6-08a2-4480-89f5-bd5ccd42067b",
      "name": "向模型发送消息",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        960,
        2224
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Analyze the time tracking for last month and provide me with a summary\n\n\n{{ $json }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "sGgf9jkDln4JRKOD",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "952f2882-0b34-4408-8b09-4f3b2a70d661",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        2144
      ],
      "parameters": {
        "width": 1184,
        "height": 352,
        "content": "## 月度汇总"
      },
      "typeVersion": 1
    },
    {
      "id": "a0133c1e-4092-4e90-9171-f09902e6abac",
      "name": "向模型1发送消息",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        2272,
        2224
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=IF I HAVEN'T CLOCKED IN TODAY, REMIND ME BY EMAIL\n\n{{ $json }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "sGgf9jkDln4JRKOD",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "a12ac5bc-c39e-4f1c-bca5-727c57a65829",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1696,
        2144
      ],
      "parameters": {
        "width": 1184,
        "height": 352,
        "content": "## 打卡提醒"
      },
      "typeVersion": 1
    },
    {
      "id": "16933a63-4e27-4931-b576-2bba8efb2828",
      "name": "分析时间记录",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2000,
        2224
      ],
      "parameters": {
        "operation": "get",
        "returnAll": true,
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1e5a685f-bd1b-435e-b443-67548be0c845",
      "name": "分析整月数据",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        688,
        2224
      ],
      "parameters": {
        "operation": "get",
        "returnAll": true,
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "P4XPPCTMQJ4pWSU8",
          "cachedResultUrl": "/projects/XY9UVd698UhQGydX/datatables/P4XPPCTMQJ4pWSU8",
          "cachedResultName": "schedule"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5c02e825-e86d-4ef2-98ab-903892ec553f",
      "name": "每日执行",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1792,
        2224
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 10
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a557f340-2ca6-46e1-af4d-d52b800fa9e2",
      "name": "每月执行",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        480,
        2224
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "months",
              "triggerAtHour": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "24459b66-e41e-48b1-b267-00d56e97f9f8",
      "name": "发送邮件给员工",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2624,
        2224
      ],
      "webhookId": "87eeeeda-9f1d-4575-8286-0e9e11675995",
      "parameters": {
        "sendTo": "josea.castillodiez@gmail.com",
        "message": "={{ $json.message.content }}",
        "options": {},
        "subject": "SCHEDULE"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "iVfmUSbPyEaMxofu",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "ef328e10-411e-488a-9ac0-fcc57a10a500",
      "name": "发送邮件给管理层",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1312,
        2224
      ],
      "webhookId": "87eeeeda-9f1d-4575-8286-0e9e11675995",
      "parameters": {
        "sendTo": "josea.castillodiez@gmail.com",
        "message": "={{ $json.message.content }}",
        "options": {},
        "subject": "SCHEDULE"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "iVfmUSbPyEaMxofu",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "6aeab75f-def1-46a6-9e13-b515d4bf703c",
      "name": "消息",
      "type": "n8n-nodes-base.set",
      "position": [
        2608,
        1504
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "419d7570-d1ce-44b1-814c-7757da92a188",
              "name": "message",
              "type": "string",
              "value": "=Tracked {{ $('end').item.json.break_duration }} minutes as break time."
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "fa1855df-e3b5-4052-b26a-7be840bcaf0c",
      "name": "消息1",
      "type": "n8n-nodes-base.set",
      "position": [
        2592,
        928
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "419d7570-d1ce-44b1-814c-7757da92a188",
              "name": "message",
              "type": "string",
              "value": "=Tracked {{ $('Set Break Duration').item.json.break_duration }} minutes as break time."
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "42465160-7eec-43ed-93ad-1d73745911a0",
      "name": "消息2",
      "type": "n8n-nodes-base.set",
      "position": [
        2592,
        384
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "419d7570-d1ce-44b1-814c-7757da92a188",
              "name": "message",
              "type": "string",
              "value": "Start time already tracked."
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a87a77ba-3f7d-4dec-9993-9c3e038f1559",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3040,
        944
      ],
      "parameters": {
        "color": 3,
        "width": 272,
        "height": 240,
        "content": "## 已完成"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "end",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ERROR1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If1": {
      "main": [
        [
          {
            "node": "Set Break Duration",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ERROR",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "end": {
      "main": [
        [
          {
            "node": "Update row(s)1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ERROR": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ERROR1": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Insert row",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get row(s)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get row(s)2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MESSAGE": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MESSAGE1": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MESSAGE2": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "EVERY DAY": {
      "main": [
        [
          {
            "node": "ANALYZE TIME ENTRIES",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s)": {
      "main": [
        [
          {
            "node": "If1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Insert row": {
      "main": [
        [
          {
            "node": "MESSAGE2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "EVERY MONTH": {
      "main": [
        [
          {
            "node": "ANALYZE ENTIRE MONTH",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s)2": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row(s)": {
      "main": [
        [
          {
            "node": "MESSAGE1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row(s)1": {
      "main": [
        [
          {
            "node": "MESSAGE",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model": {
      "main": [
        [
          {
            "node": "EMAIL TO MANAGEMENT",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model1": {
      "main": [
        [
          {
            "node": "EMAIL TO EMPLOYEE",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Break Duration": {
      "main": [
        [
          {
            "node": "Update row(s)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ANALYZE ENTIRE MONTH": {
      "main": [
        [
          {
            "node": "Message a model",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ANALYZE TIME ENTRIES": {
      "main": [
        [
          {
            "node": "Message a model1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook - Track Time": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

工作流信息
难度等级
高级
节点数量33
分类2
节点类型10
难度说明

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

作者
Jose Castillo

Jose Castillo

@j4ssn3o

Automation & Growth Engineer | Founder of Automation Hub I build practical, AI-powered workflows that help creators and businesses automate daily tasks, track performance, and make smarter decisions — all without code. Passionate about turning complex systems into simple, scalable automations.

外部链接
在 n8n.io 查看

分享此工作流