8
n8n 中文网amn8n.com

使用Azure GPT-4o-mini和Google

高级

这是一个Miscellaneous, AI Summarization, Multimodal AI领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, GoogleSheets, Agent, GoogleSheetsTrigger 等节点。 使用Azure GPT-4o-mini和Google Sheets评估面试并更新分数

前置要求
  • •Google Sheets API 凭证
  • •OpenAI API Key

使用的节点 (16)

Set
Code
StickyNote
GoogleSheets
Agent
GoogleSheetsTrigger
LmChatAzureOpenAi

分类

杂项
AI 摘要总结
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "ncJgeZeVdsws0GpM",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "候选人问卷分析",
  "tags": [],
  "nodes": [
    {
      "id": "5745071e-e64f-44ab-a972-65a3b7ef2a06",
      "name": "监控新问卷回复",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -80,
        816
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 3745099,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SFFWWqefQ6tcaEK0_Ovy9nVgyxS4LQPvno1i8fi39MY/edit#gid=3745099",
          "cachedResultName": "Form Responses 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1SFFWWqefQ6tcaEK0_Ovy9nVgyxS4LQPvno1i8fi39MY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SFFWWqefQ6tcaEK0_Ovy9nVgyxS4LQPvno1i8fi39MY/edit?usp=drivesdk",
          "cachedResultName": "BD Questionarie"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "tjY8nawuuRO1rxAE",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cb360f3e-257f-49d8-930a-b3d31841edbe",
      "name": "AI问卷评估器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        144,
        816
      ],
      "parameters": {
        "text": "=Role:\nQuestions and Candidate Answers:\nQ1: What is Business development according to you\nA1: {{ $json[\"What is BD according to you?\"] }}\nQ2: What is SWOT analysis\nA2: {{ $json[\"What is SWOT analysis\"] }}\n\nPlease evaluate the above responses based on knowledge depth, problem-solving ability, and communication clarity.",
        "options": {
          "systemMessage": "=You are an AI evaluator for candidate screening. \nYou will be given:\n- A set of role-specific questions.\n- A candidate's answers.\n\nYour job:\n1. Evaluate the quality of the answers against the intent of each question.\n2. Score the questionnaire (0–30 by default, or adjust scale if specified).\n3. Provide key takeaways (strengths, weaknesses, red flags, or standout qualities).\n\nOutput ONLY in JSON with this structure:\n{\n  \"questionnaire_score\": <number>,\n  \"key_takeaways\": \"<summary of candidate performance>\"\n}"
        },
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "ed9b6126-dadf-4bd6-851f-dbe3e421434e",
      "name": "Azure OpenAI GPT-4模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        240,
        1040
      ],
      "parameters": {
        "model": "gpt-4o-mini",
        "options": {}
      },
      "credentials": {
        "azureOpenAiApi": {
          "id": "C3WzT18XqF8OdVM6",
          "name": "Azure Open AI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3817a7af-23d1-445d-abc3-b68556ff5ec4",
      "name": "查找候选人档案数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        768,
        816
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1424038785,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA/edit#gid=1424038785",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA/edit?usp=drivesdk",
          "cachedResultName": "Resume store"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "5cd8411b-1851-46e5-833b-2723d14dd509",
      "name": "解析AI评估结果",
      "type": "n8n-nodes-base.code",
      "position": [
        544,
        816
      ],
      "parameters": {
        "jsCode": "return items.map(item => {\n  let text = item.json.output;\n\n  // Remove code fences like ```json ... ```\n  text = text.replace(/```json|```/g, \"\").trim();\n\n  let parsed = {};\n  try {\n    parsed = JSON.parse(text);\n  } catch (err) {\n    parsed = { error: \"Failed to parse JSON\", raw: text };\n  }\n\n  return { json: parsed };\n});"
      },
      "typeVersion": 2
    },
    {
      "id": "abfe1e72-3291-4bfe-ab80-8b9339ea0aa9",
      "name": "计算综合分数",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        816
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1fb84fd6-db3f-432d-baee-2e3e2cfd404a",
              "name": "=final score",
              "type": "number",
              "value": "={{ $json.Score + $('Parse AI Evaluation Results').item.json.questionnaire_score }}\n\n"
            },
            {
              "id": "d257e53b-6887-4cdc-8f50-f90715312b81",
              "name": "Questionarie Score",
              "type": "string",
              "value": "={{ $('Parse AI Evaluation Results').item.json.questionnaire_score }}"
            }
          ]
        }
      },
      "typeVersion": 3.4,
      "alwaysOutputData": true
    },
    {
      "id": "895de667-d515-4331-a2be-e3079af6b468",
      "name": "更新候选人数据库",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        816
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "John Doe",
            "Final score": "={{ $json[\"final score\"] }}",
            "Questionarie Score": "={{ $json[\"Questionarie Score\"] }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone ",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Phone ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Years of experience",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Years of experience",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "skills",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "skills",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "curent role",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "curent role",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "education",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "education",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Score",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Questionarie Score",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Questionarie Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Final score",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Final score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Skill name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Skill name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Skill level",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Skill level",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Skill years",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Skill years",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1424038785,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA/edit#gid=1424038785",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA/edit?usp=drivesdk",
          "cachedResultName": "Resume store"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "60456c78-e211-4bfe-852d-81467d3d5fda",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        512
      ],
      "parameters": {
        "width": 320,
        "height": 352,
        "content": "## 🔔 自动触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "eb5a2306-50c1-4222-9778-8dbd51546ae8",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        368
      ],
      "parameters": {
        "width": 320,
        "height": 420,
        "content": "## 🤖 AI评估引擎"
      },
      "typeVersion": 1
    },
    {
      "id": "29578b3f-a8ff-42d9-9b30-61821ad9a807",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        1088
      ],
      "parameters": {
        "width": 320,
        "height": 280,
        "content": "## ⚙️ AI模型配置"
      },
      "typeVersion": 1
    },
    {
      "id": "2f0e9fba-d447-4951-ac95-7b71ed965e7a",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        400
      ],
      "parameters": {
        "width": 320,
        "height": 340,
        "content": "## 🔧 数据处理"
      },
      "typeVersion": 1
    },
    {
      "id": "2ba1d0f1-4531-4b09-8283-df69a1425360",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        992
      ],
      "parameters": {
        "width": 320,
        "height": 352,
        "content": "## 📊 数据检索"
      },
      "typeVersion": 1
    },
    {
      "id": "512b6d1c-c678-4d9f-9b12-0243b2b44dc0",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        384
      ],
      "parameters": {
        "width": 320,
        "height": 372,
        "content": "## 🧮 分数计算"
      },
      "typeVersion": 1
    },
    {
      "id": "605aa0a9-3b28-4251-b55a-a0d5d6b8e074",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        1008
      ],
      "parameters": {
        "width": 320,
        "height": 360,
        "content": "## 💾 数据库更新"
      },
      "typeVersion": 1
    },
    {
      "id": "2bd8f006-8113-4ed2-a56a-1973f6a8ecec",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -976,
        704
      ],
      "parameters": {
        "width": 480,
        "height": 620,
        "content": "## 📝 候选人问卷分析工作流"
      },
      "typeVersion": 1
    },
    {
      "id": "5dceeae5-f433-42ae-9a42-8d8491133104",
      "name": "便签 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1616,
        640
      ],
      "parameters": {
        "width": 380,
        "height": 520,
        "content": "## ⚙️ 配置与自定义"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "17c11c31-64d6-417f-b01d-863e13dd207f",
  "connections": {
    "ed9b6126-dadf-4bd6-851f-dbe3e421434e": {
      "ai_languageModel": [
        [
          {
            "node": "cb360f3e-257f-49d8-930a-b3d31841edbe",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "abfe1e72-3291-4bfe-ab80-8b9339ea0aa9": {
      "main": [
        [
          {
            "node": "895de667-d515-4331-a2be-e3079af6b468",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cb360f3e-257f-49d8-930a-b3d31841edbe": {
      "main": [
        [
          {
            "node": "5cd8411b-1851-46e5-833b-2723d14dd509",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5cd8411b-1851-46e5-833b-2723d14dd509": {
      "main": [
        [
          {
            "node": "3817a7af-23d1-445d-abc3-b68556ff5ec4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3817a7af-23d1-445d-abc3-b68556ff5ec4": {
      "main": [
        [
          {
            "node": "abfe1e72-3291-4bfe-ab80-8b9339ea0aa9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5745071e-e64f-44ab-a972-65a3b7ef2a06": {
      "main": [
        [
          {
            "node": "cb360f3e-257f-49d8-930a-b3d31841edbe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 杂项, AI 摘要总结, 多模态 AI

需要付费吗？

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

相关工作流推荐

使用Google Drive和GPT-4o将技能矩阵提取至Google表格
使用Google Drive和GPT-4o将技能矩阵提取至Google表格
Code
Google Drive
Google Sheets
+
Code
Google Drive
Google Sheets
17 节点Rahul Joshi
杂项
使用Azure OpenAI和Google
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+
Set
Code
Email Send
28 节点Rahul Joshi
客户关系管理
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+
If
Set
Code
19 节点Rahul Joshi
文档提取
使用 GPT-4o、Slack、Jira 和 Google Sheets
使用 GPT-4o、Slack、Jira 和 Google Sheets 进行依赖更新风险分析
If
Set
Code
+
If
Set
Code
23 节点Rahul Joshi
开发运维
竞争对手内容差距分析器：自动化网站主题映射
使用Gemini AI、Apify和Google Sheets分析竞争对手内容差距
If
Set
Code
+
If
Set
Code
30 节点Mychel Garzon
杂项
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+
If
Set
Code
52 节点Daniel Lianes
杂项
工作流信息
难度等级
高级
节点数量16
分类3
节点类型7
难度说明

适合高级用户，包含 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 查看 →

分享此工作流

分类

多模态 AI
1540
人工智能
1108
内容创作
695
AI 摘要总结
516
营销
419
AI 聊天机器人
251
工程
241
市场调研
203
杂项
193
其他
176
销售
162
IT 运维
156
文档提取
147
AI RAG 检索增强
146
构建模块
144
社交媒体
137
潜在客户开发
125
个人效率
117
开发运维
111
人力资源
101
客户支持
97
客户培育
87
客户关系管理
82
财务
81
产品
77
客服机器人
76
设计
70
工单管理
67
安全运维
57
发票处理
53
加密货币交易
49
文件管理
39
项目管理
35
内部知识库
32

分类: 34