8
n8n 中文网amn8n.com

结构化面试反馈收集

高级

这是一个HR, AI Summarization领域的自动化工作流,包含 18 个节点。主要使用 If, Code, Gmail, ClickUp, GoogleSheets 等节点。 使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝

前置要求
  • Google 账号和 Gmail API 凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "FulwU5u7Hx1FETOE",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "结构化面试反馈收集",
  "tags": [],
  "nodes": [
    {
      "id": "4fda932e-4730-482d-952e-7ac16e2e53f2",
      "name": "发送拒绝邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        208,
        352
      ],
      "webhookId": "86f9bdab-5560-4c7e-bbdd-85291f22843d",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "169eb781-745d-464b-9200-36e8f717049b",
      "name": "获取表格中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1296,
        64
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "9a34ce1c-e471-4137-99b2-3b667fafb717",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1568,
        64
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "cb16c914-5913-4e39-9d19-810f0bc54e34",
      "name": "代码",
      "type": "n8n-nodes-base.code",
      "position": [
        -608,
        64
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6e34b7f2-b75d-481c-9a8f-915441f33b9c",
      "name": "如果",
      "type": "n8n-nodes-base.if",
      "position": [
        -352,
        64
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "5e1800cc-efc8-45a1-96ce-8952c8ecdf41",
      "name": "创建任务",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        224,
        160
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "aa4d3b97-ca6b-4dc1-b956-4c7c4d70f373",
      "name": "代码1",
      "type": "n8n-nodes-base.code",
      "position": [
        -32,
        80
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "c3943233-b5c8-43b9-9d05-a2131896cc4b",
      "name": "基础 LLM 链",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -1040,
        64
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "620afca3-0cf8-44a8-90b2-00a71291ad8a",
      "name": "Azure OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        -1088,
        272
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "772ae5a5-0f38-463f-910e-d0c9ba8c351d",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "831f088d-4d12-4e5f-ba0d-b8568bce1f9e",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a6dfd803-b53d-4403-87b8-f0808266fbf3",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        544
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f262a965-363e-4be4-befa-e8a187b186ca",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        -192
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c2497022-256a-4e83-b14a-127d1d63153f",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d350ebe5-e6e7-49b7-bbc4-2da9247e8c40",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1168,
        416
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c3824f6f-ce1e-4f1c-b075-fd51c7f19717",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1040,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ecde2db4-72db-470e-904b-2736ccbb1682",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1376,
        -224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5f49e379-01c6-4824-85a9-811e2cceda85",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1648,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "28bbbc97-14b9-45f9-aa37-4a77129670d5",
  "connections": {
    "If": {
      "main": [
        [],
        [
          {
            "node": "Code1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code1": {
      "main": [
        [
          {
            "node": "Send Rejection Email",
            "type": "main",
            "index": 0
          },
          {
            "node": "Create a task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

作者
Rahul Joshi

Rahul Joshi

@rahul08

Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.

外部链接
在 n8n.io 查看

分享此工作流