8
n8n 中文网amn8n.com

构建基于GPT-4、Jotform和Google Sheets的AI员工认可系统

高级

这是一个自动化工作流,包含 24 个节点。主要使用 If, Set, Code, Gmail, GoogleSheets 等节点。 构建基于GPT-4、Jotform和Google Sheets的AI员工认可系统

前置要求
  • Google 账号和 Gmail API 凭证
  • Google Sheets API 凭证
  • OpenAI API Key

分类

-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "277842713620d9f5554de3b1518b865a152c8c4db680008bd8aec536fc18b4a8"
  },
  "nodes": [
    {
      "id": "86fd61aa-d2ce-446f-930e-67245b71a05b",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1248,
        64
      ],
      "parameters": {
        "color": 4,
        "width": 360,
        "height": 536,
        "content": "## 🏆 员工表彰与奖励"
      },
      "typeVersion": 1
    },
    {
      "id": "e125cbbb-45c7-4f17-994d-bd361c65097c",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -32
      ],
      "parameters": {
        "color": 5,
        "width": 340,
        "height": 508,
        "content": "## 📝 Jotform 表彰字段:"
      },
      "typeVersion": 1
    },
    {
      "id": "c28077cb-cfc6-4f9d-99e8-8a7841e201a1",
      "name": "提取表彰数据",
      "type": "n8n-nodes-base.set",
      "position": [
        -688,
        320
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "nominator_name",
              "name": "nominatorName",
              "type": "string",
              "value": "={{ $json.rawRequest['q3_nominatorName'] }}"
            },
            {
              "id": "nominator_email",
              "name": "nominatorEmail",
              "type": "string",
              "value": "={{ $json.rawRequest['q4_nominatorEmail'] }}"
            },
            {
              "id": "nominee_name",
              "name": "nomineeName",
              "type": "string",
              "value": "={{ $json.rawRequest['q5_nomineeName'] }}"
            },
            {
              "id": "nominee_email",
              "name": "nomineeEmail",
              "type": "string",
              "value": "={{ $json.rawRequest['q6_nomineeEmail'] }}"
            },
            {
              "id": "department",
              "name": "department",
              "type": "string",
              "value": "={{ $json.rawRequest['q7_department'] }}"
            },
            {
              "id": "recognition_title",
              "name": "recognitionTitle",
              "type": "string",
              "value": "={{ $json.rawRequest['q8_recognitionTitle'] }}"
            },
            {
              "id": "description",
              "name": "description",
              "type": "string",
              "value": "={{ $json.rawRequest['q9_description'] }}"
            },
            {
              "id": "example",
              "name": "example",
              "type": "string",
              "value": "={{ $json.rawRequest['q10_example'] }}"
            },
            {
              "id": "impact",
              "name": "impact",
              "type": "string",
              "value": "={{ $json.rawRequest['q11_impact'] }}"
            },
            {
              "id": "submission_id",
              "name": "submissionId",
              "type": "string",
              "value": "={{ $json.submissionID }}"
            },
            {
              "id": "submitted_at",
              "name": "submittedAt",
              "type": "string",
              "value": "={{ $now.toISO() }}"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "7fa86947-b282-44b2-b3b6-6552eee4fb06",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        -64
      ],
      "parameters": {
        "color": 6,
        "width": 440,
        "height": 508,
        "content": "## 🤖 AI表彰分析"
      },
      "typeVersion": 1
    },
    {
      "id": "9d20965d-fc31-422a-8c12-722164322404",
      "name": "AI表彰分析",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -480,
        256
      ],
      "parameters": {
        "text": "=Analyze this employee recognition submission and provide comprehensive categorization:\n\nRECOGNITION DETAILS:\nNominee: {{ $json.nomineeName }}\nDepartment: {{ $json.department }}\nRecognition Title: {{ $json.recognitionTitle }}\nDescription: {{ $json.description }}\nSpecific Example: {{ $json.example }}\nImpact: {{ $json.impact }}\n\nProvide analysis in JSON format:\n{\n  \"primaryCategory\": \"Innovation/Teamwork/Leadership/Customer Service/Excellence/Problem Solving/Mentorship\",\n  \"secondaryCategories\": [\"category1\", \"category2\"],\n  \"recognitionStrength\": 1-10,\n  \"keyQualities\": [\"quality1\", \"quality2\", \"quality3\"],\n  \"impactLevel\": \"individual/team/department/company-wide\",\n  \"impactScore\": 1-10,\n  \"behaviorExamples\": [\"specific behavior 1\", \"specific behavior 2\"],\n  \"coreValues\": [\"value1\", \"value2\"],\n  \"awardRecommendation\": \"Employee of the Month/Spot Award/Team Achievement/Leadership Excellence/Innovation Award\",\n  \"nominationQuality\": \"excellent/good/moderate\",\n  \"standoutElements\": [\"element1\", \"element2\"],\n  \"summaryForLeadership\": \"brief 2-3 sentence summary\",\n  \"publicRecognitionText\": \"1-2 sentence version for announcement\",\n  \"suggestedRewardValue\": \"$50/$100/$250/$500\",\n  \"eligibleForMonthlyAward\": true/false,\n  \"reasoningNotes\": \"explanation of categorization\"\n}",
        "agent": "conversationalAgent",
        "options": {
          "systemMessage": "You are an expert HR analyst specializing in employee recognition programs. Analyze nominations objectively, identify genuine impact and exceptional performance, and provide actionable insights for recognition and rewards decisions."
        },
        "promptType": "define"
      },
      "typeVersion": 1.6
    },
    {
      "id": "4a5ccf7c-6f3b-467d-9eb2-167a518bc018",
      "name": "解析AI分析",
      "type": "n8n-nodes-base.set",
      "position": [
        -208,
        256
      ],
      "parameters": {
        "mode": "expressionData",
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "f2226ffc-08e1-427d-8f98-8e53d660f8cb",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -64
      ],
      "parameters": {
        "color": 2,
        "width": 320,
        "height": 764,
        "content": "## 📊 表彰追踪"
      },
      "typeVersion": 1
    },
    {
      "id": "f2f7b3ed-13a2-4780-b0bb-2cd307e3f2cd",
      "name": "记录到表彰表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        96,
        288
      ],
      "parameters": {
        "columns": {
          "value": {
            "impact": "={{ $('Extract Recognition Data').item.json.impact }}",
            "status": "Pending Review",
            "example": "={{ $('Extract Recognition Data').item.json.example }}",
            "timestamp": "={{ $('Extract Recognition Data').item.json.submittedAt }}",
            "coreValues": "={{ $json.coreValues.join(', ') }}",
            "department": "={{ $('Extract Recognition Data').item.json.department }}",
            "description": "={{ $('Extract Recognition Data').item.json.description }}",
            "impactLevel": "={{ $json.impactLevel }}",
            "impactScore": "={{ $json.impactScore }}",
            "nomineeName": "={{ $('Extract Recognition Data').item.json.nomineeName }}",
            "keyQualities": "={{ $json.keyQualities.join(', ') }}",
            "nomineeEmail": "={{ $('Extract Recognition Data').item.json.nomineeEmail }}",
            "submissionId": "={{ $('Extract Recognition Data').item.json.submissionId }}",
            "nominatorName": "={{ $('Extract Recognition Data').item.json.nominatorName }}",
            "nominatorEmail": "={{ $('Extract Recognition Data').item.json.nominatorEmail }}",
            "primaryCategory": "={{ $json.primaryCategory }}",
            "recognitionTitle": "={{ $('Extract Recognition Data').item.json.recognitionTitle }}",
            "nominationQuality": "={{ $json.nominationQuality }}",
            "awardRecommendation": "={{ $json.awardRecommendation }}",
            "recognitionStrength": "={{ $json.recognitionStrength }}",
            "secondaryCategories": "={{ $json.secondaryCategories.join(', ') }}",
            "suggestedRewardValue": "={{ $json.suggestedRewardValue }}",
            "eligibleForMonthlyAward": "={{ $json.eligibleForMonthlyAward ? 'Yes' : 'No' }}"
          },
          "mappingMode": "defineBelow"
        },
        "options": {
          "useAppend": true,
          "cellFormat": "USER_ENTERED"
        },
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Recognition_Log"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_GOOGLE_SHEET_ID"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Kz2DdSp11rxqwlFt",
          "name": "Google Sheets account - Deepanshi"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "64fda40f-f57b-4106-a09e-d6946af9ac26",
      "name": "发送提名者确认",
      "type": "n8n-nodes-base.gmail",
      "position": [
        624,
        -96
      ],
      "webhookId": "722e1d97-7f01-48bf-9469-9229906656ae",
      "parameters": {
        "sendTo": "={{ $('Extract Recognition Data').item.json.nominatorEmail }}",
        "message": "=<div style='font-family: Arial, sans-serif; max-width: 650px; margin: 0 auto;'>\n  <div style='background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 40px 30px; text-align: center;'>\n    <h1 style='margin: 0;'>Thank You!</h1>\n    <p style='margin: 15px 0 0 0;'>Your recognition has been received</p>\n  </div>\n  <div style='background-color: #fff; padding: 30px;'>\n    <p>Hi {{ $('Extract Recognition Data').item.json.nominatorName.split(' ')[0] }},</p>\n    <p>Thank you for recognizing <strong>{{ $('Extract Recognition Data').item.json.nomineeName }}</strong>!</p>\n    <div style='background-color: #e7f3ff; padding: 20px; margin: 20px 0;'>\n      <h3>AI Analysis Results</h3>\n      <p><strong>Category:</strong> {{ $json.primaryCategory }}</p>\n      <p><strong>Recognition Strength:</strong> {{ $json.recognitionStrength }}/10</p>\n      <p><strong>Impact Level:</strong> {{ $json.impactLevel }}</p>\n    </div>\n    <p>Your nomination helps us build a culture of appreciation!</p>\n  </div>\n</div>",
        "options": {},
        "subject": "=Thank You for Recognizing {{ $('Extract Recognition Data').item.json.nomineeName }}!"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "PIMDNhXNj8Zyiz3G",
          "name": "Gmail account - Deepanshi"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "26df9307-1b65-4e88-85c6-2002f0b085f7",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        192
      ],
      "parameters": {
        "color": 5,
        "width": 512,
        "height": 312,
        "content": "## 🎉 被提名者通知"
      },
      "typeVersion": 1
    },
    {
      "id": "0a2a369f-8e7d-4ad2-a540-3323ef8766f6",
      "name": "发送被提名者通知",
      "type": "n8n-nodes-base.gmail",
      "position": [
        656,
        240
      ],
      "webhookId": "16e1b346-a574-495a-bffc-d6f3faa0fd0a",
      "parameters": {
        "sendTo": "={{ $('Extract Recognition Data').item.json.nomineeEmail }}",
        "message": "=<div style='font-family: Arial, sans-serif; max-width: 650px; margin: 0 auto;'>\n  <div style='background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%); color: white; padding: 50px 30px; text-align: center;'>\n    <div style='font-size: 60px;'>🌟</div>\n    <h1 style='margin: 10px 0;'>Congratulations!</h1>\n    <p style='margin: 10px 0;'>You've been recognized</p>\n  </div>\n  <div style='background-color: #fff; padding: 30px;'>\n    <p>Hi {{ $('Extract Recognition Data').item.json.nomineeName.split(' ')[0] }},</p>\n    <p><strong>{{ $('Extract Recognition Data').item.json.nominatorName }}</strong> has recognized you!</p>\n    <div style='background-color: #667eea; color: white; padding: 25px; border-radius: 8px; margin: 20px 0;'>\n      <h2 style='margin: 0; text-align: center;'>{{ $('Extract Recognition Data').item.json.recognitionTitle }}</h2>\n      <p style='margin: 15px 0; text-align: center; font-style: italic;'>{{ $json.publicRecognitionText }}</p>\n    </div>\n    <div style='background-color: #e7f3ff; padding: 20px; margin: 20px 0;'>\n      <h3>Recognition Highlights</h3>\n      <p><strong>Category:</strong> {{ $json.primaryCategory }}</p>\n      <p><strong>Impact Level:</strong> {{ $json.impactLevel }}</p>\n    </div>\n    <p>Keep up the amazing work!</p>\n  </div>\n</div>",
        "options": {},
        "subject": "=You've Been Recognized by {{ $('Extract Recognition Data').item.json.nominatorName }}!"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "PIMDNhXNj8Zyiz3G",
          "name": "Gmail account - Deepanshi"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "f947a01d-80c8-4481-8da2-90af0182bba0",
      "name": "### 需要帮助?",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        512
      ],
      "parameters": {
        "color": 7,
        "width": 320,
        "height": 376,
        "content": "## 👔 HR领导层通知"
      },
      "typeVersion": 1
    },
    {
      "id": "854fd1e0-e088-46d9-8e3f-d4dae94f6585",
      "name": "通知HR领导层",
      "type": "n8n-nodes-base.gmail",
      "position": [
        464,
        752
      ],
      "webhookId": "165019e2-b333-4622-98a3-eff43e4118ce",
      "parameters": {
        "sendTo": "hr@yourcompany.com",
        "message": "=<div style='font-family: Arial, sans-serif; max-width: 700px; margin: 0 auto;'>\n  <div style='background-color: #667eea; color: white; padding: 25px;'>\n    <h1 style='margin: 0;'>New Employee Recognition</h1>\n  </div>\n  <div style='background-color: #fff; padding: 25px;'>\n    <h2>Recognition Summary</h2>\n    <p><strong>Nominee:</strong> {{ $('Extract Recognition Data').item.json.nomineeName }} ({{ $('Extract Recognition Data').item.json.department }})</p>\n    <p><strong>Nominated By:</strong> {{ $('Extract Recognition Data').item.json.nominatorName }}</p>\n    <p><strong>Category:</strong> {{ $json.primaryCategory }}</p>\n    <p><strong>Recognition Strength:</strong> {{ $json.recognitionStrength }}/10</p>\n    <p><strong>Impact Score:</strong> {{ $json.impactScore }}/10</p>\n    <p><strong>Award Recommendation:</strong> {{ $json.awardRecommendation }}</p>\n    <p><strong>Suggested Reward:</strong> {{ $json.suggestedRewardValue }}</p>\n    <p><strong>Monthly Award Eligible:</strong> {{ $json.eligibleForMonthlyAward ? 'YES' : 'NO' }}</p>\n  </div>\n</div>",
        "options": {},
        "subject": "=New Recognition: {{ $('Extract Recognition Data').item.json.nomineeName }} - {{ $json.primaryCategory }}"
      },
      "typeVersion": 2.1
    },
    {
      "id": "8cbe052e-1432-4224-ada6-668fe2f8e2ab",
      "name": "## 试试看!",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        624
      ],
      "parameters": {
        "width": 340,
        "height": 504,
        "content": "## 📅 月度奖项评选"
      },
      "typeVersion": 1
    },
    {
      "id": "8832751e-0b10-4610-85c1-cae8abd0f426",
      "name": "月度奖项触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1120,
        912
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 9 1 * *"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "92741cd7-9f6a-4426-a0a3-92cba8a76f96",
      "name": "读取表彰日志",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -800,
        912
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Recognition_Log"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_GOOGLE_SHEET_ID"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Kz2DdSp11rxqwlFt",
          "name": "Google Sheets account - Deepanshi"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "a6117dbb-d16d-40b0-80df-2d409c3fffcc",
      "name": "筛选月度合格者",
      "type": "n8n-nodes-base.code",
      "position": [
        -528,
        912
      ],
      "parameters": {
        "jsCode": "const now = new Date();\nconst lastMonth = new Date(now.getFullYear(), now.getMonth() - 1, 1);\nconst thisMonth = new Date(now.getFullYear(), now.getMonth(), 1);\nconst eligibleNominations = [];\n\nfor (const item of $input.all()) {\n  const nomination = item.json;\n  if (nomination.eligibleForMonthlyAward !== 'Yes') continue;\n  const nominationDate = new Date(nomination.timestamp);\n  if (nominationDate >= lastMonth && nominationDate < thisMonth) {\n    eligibleNominations.push({\n      json: {\n        ...nomination,\n        monthYear: lastMonth.toLocaleString('default', { month: 'long', year: 'numeric' })\n      }\n    });\n  }\n}\n\neligibleNominations.sort((a, b) => {\n  const scoreA = (parseFloat(a.json.recognitionStrength) + parseFloat(a.json.impactScore)) / 2;\n  const scoreB = (parseFloat(b.json.recognitionStrength) + parseFloat(b.json.impactScore)) / 2;\n  return scoreB - scoreA;\n});\n\nreturn eligibleNominations;"
      },
      "typeVersion": 2
    },
    {
      "id": "709520dd-41f1-4582-a06b-3054855b9de3",
      "name": "检查是否有提名",
      "type": "n8n-nodes-base.if",
      "position": [
        -288,
        912
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "has_nominations",
              "operator": {
                "type": "string",
                "operation": "notEmpty"
              },
              "leftValue": "={{ $json.nomineeName }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "d4f615b5-0c50-4ef3-9890-a40b07c77169",
      "name": "生成奖项报告",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        16,
        896
      ],
      "parameters": {
        "text": "=Generate Employee of the Month report:\n\n{{ JSON.stringify($input.all().map(item => item.json)) }}\n\nProvide in JSON:\n{\n  \"monthYear\": \"month year\",\n  \"totalNominations\": number,\n  \"winnerRecommendation\": \"name\",\n  \"winnerJustification\": \"reasoning\",\n  \"runnerUp\": \"name\",\n  \"executiveSummary\": \"summary\"\n}",
        "agent": "conversationalAgent",
        "options": {
          "systemMessage": "You are an HR analytics expert. Analyze nominations and recommend Employee of the Month winner."
        },
        "promptType": "define"
      },
      "typeVersion": 1.6
    },
    {
      "id": "146ecedb-db1d-4900-81f7-efd6169963ff",
      "name": "解析奖项报告",
      "type": "n8n-nodes-base.set",
      "position": [
        384,
        896
      ],
      "parameters": {
        "mode": "expressionData",
        "options": {}
      },
      "typeVersion": 3.3
    },
    {
      "id": "b4e916a5-336b-42d4-bd30-6196f0071a71",
      "name": "发送奖项报告",
      "type": "n8n-nodes-base.gmail",
      "position": [
        656,
        912
      ],
      "webhookId": "8718da03-59b7-4c74-823f-d9e0a6a542a8",
      "parameters": {
        "sendTo": "leadership@yourcompany.com",
        "message": "=<div style='font-family: Arial, sans-serif; max-width: 800px; margin: 0 auto;'>\n  <div style='background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; padding: 40px; text-align: center;'>\n    <h1>Employee of the Month</h1>\n    <p>{{ $json.monthYear }}</p>\n  </div>\n  <div style='background-color: #fff; padding: 30px;'>\n    <h2>Executive Summary</h2>\n    <p>{{ $json.executiveSummary }}</p>\n    <div style='background-color: #d4edda; padding: 25px; margin: 25px 0;'>\n      <h2>Recommended Winner</h2>\n      <h3>{{ $json.winnerRecommendation }}</h3>\n      <p>{{ $json.winnerJustification }}</p>\n    </div>\n    <div style='background-color: #fff3cd; padding: 25px;'>\n      <h3>Runner-Up</h3>\n      <p>{{ $json.runnerUp }}</p>\n    </div>\n  </div>\n</div>",
        "options": {
          "ccList": "hr@yourcompany.com"
        },
        "subject": "=Employee of the Month Report - {{ $json.monthYear }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "PIMDNhXNj8Zyiz3G",
          "name": "Gmail account - Deepanshi"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "4415bfb7-78fa-477a-99cf-4584614123f0",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        16,
        1088
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8IkhtT3EbXygnvcr",
          "name": "Klinsman OpenAI"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "38cb80b1-5303-4df0-b07a-e9fac3934e79",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -624,
        464
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8IkhtT3EbXygnvcr",
          "name": "Klinsman OpenAI"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "c90ff216-57bb-4222-b250-5590e216c6c3",
      "name": "Jotform触发器",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -848,
        320
      ],
      "webhookId": "recognition-submission-webhook",
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Jotform Trigger": {
      "main": [
        [
          {
            "node": "Extract Recognition Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Generate Award Report",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Parse AI Analysis": {
      "main": [
        [
          {
            "node": "Log to Recognition Sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Nominator Acknowledgment",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Nominee Notification",
            "type": "main",
            "index": 0
          },
          {
            "node": "Notify HR Leadership",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "AI Recognition Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Parse Award Report": {
      "main": [
        [
          {
            "node": "Send Award Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Recognition Log": {
      "main": [
        [
          {
            "node": "Filter Monthly Eligible",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Has Nominations": {
      "main": [
        [
          {
            "node": "Generate Award Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Award Report": {
      "main": [
        [
          {
            "node": "Parse Award Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monthly Award Trigger": {
      "main": [
        [
          {
            "node": "Read Recognition Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Recognition Analysis": {
      "main": [
        [
          {
            "node": "Parse AI Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Monthly Eligible": {
      "main": [
        [
          {
            "node": "Check Has Nominations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Recognition Data": {
      "main": [
        [
          {
            "node": "AI Recognition Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级

需要付费吗?

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

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

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

作者
Jitesh Dugar

Jitesh Dugar

@jiteshdugar

AI Automation Specialist - OpenAI, CRM & Automation Expert with a solid understanding of various tools that include Zapier, Make, Zoho CRM, Hubspot, Google Sheets, Airtable, Pipedrive, Google Analytics, and more.

外部链接
在 n8n.io 查看

分享此工作流