{ "edges": [ { "to": "56077bfe-f3d6-430a-8a2c-931039994e0c", "from": "97f6e05e-8ec9-44d8-b874-13810b22343f", "toPort": "0", "fromPort": "0" }, { "to": "a8883617-c50f-4dfd-b2c5-b9ac26a31cd7", "from": "c5280bdf-bbd5-4c3b-8cb3-6191097a30a4", "toPort": "0", "fromPort": "0" }, { "to": "4fe253db-456b-403d-b9f7-cf017587cc7e", "from": "4b00cbde-7e41-456a-ae89-107a020a441a", "toPort": "0", "fromPort": "0" }, { "to": "f5679924-1ba1-49b2-b98a-a48ec4f83770", "from": "2b2381b7-6b12-4245-bbb7-557c7f5c3f64", "toPort": "0", "fromPort": "0" }, { "to": "4b00cbde-7e41-456a-ae89-107a020a441a", "from": "76459fa7-3cba-4f65-9948-f022768952c0", "toPort": "0", "fromPort": "0" }, { "to": "c5280bdf-bbd5-4c3b-8cb3-6191097a30a4", "from": "774ae079-daec-45e7-bef7-5291c3a85644", "toPort": "0", "fromPort": "0" }, { "to": "97f6e05e-8ec9-44d8-b874-13810b22343f", "from": "abef2c32-c886-4ac6-83d4-cc4d8dca7bf8", "toPort": "0", "fromPort": "0" }, { "to": "76459fa7-3cba-4f65-9948-f022768952c0", "from": "f5679924-1ba1-49b2-b98a-a48ec4f83770", "toPort": "0", "fromPort": "0" }, { "to": "774ae079-daec-45e7-bef7-5291c3a85644", "from": "56077bfe-f3d6-430a-8a2c-931039994e0c", "toPort": "0", "fromPort": "0" }, { "to": "abef2c32-c886-4ac6-83d4-cc4d8dca7bf8", "from": "4fe253db-456b-403d-b9f7-cf017587cc7e", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "f5679924-1ba1-49b2-b98a-a48ec4f83770", "name": "Process Employee Data", "type": "code", "params": { "jsCode": "// Extract data from webhook body\nconst webhookData = $input.item.json.body;\n\n// Calculate average score from all performance metrics\nconst scores = webhookData.scores;\nconst averageScore = (\n scores.technical + \n scores.communication + \n scores.leadership + \n scores.productivity + \n scores.teamwork\n) / 5;\n\n// Determine performance level based on overall rating\nconst getPerformanceLevel = (rating) => {\n if (rating >= 4.5) return 'Outstanding';\n if (rating >= 4.0) return 'Exceeds Expectations';\n if (rating >= 3.0) return 'Meets Expectations';\n return 'Needs Improvement';\n};\n\n// Determine performance color for visual elements\nconst getPerformanceColor = (rating) => {\n if (rating >= 4.5) return '#4CAF50'; // Green\n if (rating >= 4.0) return '#2196F3'; // Blue\n if (rating >= 3.0) return '#FF9800'; // Orange\n return '#F44336'; // Red\n};\n\n// Format date for review period\nconst currentDate = new Date().toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n});\n\n// Build comprehensive output object\nconst output = {\n // Employee Information\n employeeId: webhookData.employeeId,\n employeeName: webhookData.employeeName,\n employeeEmail: webhookData.employeeEmail,\n \n // Manager Information\n managerName: webhookData.managerName,\n managerEmail: webhookData.managerEmail,\n \n // Department & Period\n department: webhookData.department,\n reviewPeriod: webhookData.reviewPeriod,\n reviewDate: currentDate,\n \n // Performance Scores (Individual)\n technicalScore: scores.technical,\n communicationScore: scores.communication,\n leadershipScore: scores.leadership,\n productivityScore: scores.productivity,\n teamworkScore: scores.teamwork,\n \n // Calculated Metrics\n overallRating: webhookData.overallRating,\n averageScore: parseFloat(averageScore.toFixed(2)),\n performanceLevel: getPerformanceLevel(webhookData.overallRating),\n performanceColor: getPerformanceColor(webhookData.overallRating),\n \n // Percentage calculations for visual bars\n technicalPercent: (scores.technical / 5) * 100,\n communicationPercent: (scores.communication / 5) * 100,\n leadershipPercent: (scores.leadership / 5) * 100,\n productivityPercent: (scores.productivity / 5) * 100,\n teamworkPercent: (scores.teamwork / 5) * 100,\n \n // Feedback Details\n strengthsFeedback: webhookData.feedback.strengths,\n improvementsFeedback: webhookData.feedback.improvements,\n managerComments: webhookData.feedback.managerComments,\n \n // Flags for conditional logic\n isLowPerformer: webhookData.overallRating < 3.0,\n isHighPerformer: webhookData.overallRating >= 4.5,\n requiresManagerAlert: webhookData.overallRating < 3.0,\n \n // Additional metadata\n scoresObject: scores, // Keep original scores object for reference\n feedbackObject: webhookData.feedback, // Keep original feedback object\n \n // Generate unique review ID\n reviewId: `REV-${webhookData.employeeId}-${Date.now()}`,\n \n // Timestamp\n processedAt: new Date().toISOString()\n};\n\n// Return the processed data\nreturn { json: output };" }, "position": [ 1152, 240 ] }, { "id": "76459fa7-3cba-4f65-9948-f022768952c0", "name": "AI Summary Generator", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "gpt-4", "cachedResultName": "GPT-4" }, "options": { "temperature": 0.7 }, "provider": "openai", "responses": { "values": [ { "role": "system", "content": "=You are an expert HR professional specializing in performance reviews. Create concise, professional, and encouraging summaries that highlight achievements while providing constructive developmental guidance. Your tone should be supportive, specific, and actionable. Always format your response as valid JSON." }, { "content": "=Create a comprehensive performance review summary for the following employee:\n\nEMPLOYEE INFORMATION:\n- Name: {{ $json.employeeName }}\n- Department: {{ $json.department }}\n- Review Period: {{ $json.reviewPeriod }}\n- Overall Rating: {{ $json.overallRating }}/5.0 ({{ $json.performanceLevel }})\n\nPERFORMANCE SCORES:\n- Technical Skills: {{ $json.technicalScore }}/5.0\n- Communication: {{ $json.communicationScore }}/5.0\n- Leadership: {{ $json.leadershipScore }}/5.0\n- Productivity: {{ $json.productivityScore }}/5.0\n- Teamwork: {{ $json.teamworkScore }}/5.0\n- Average Score: {{ $json.averageScore }}/5.0\n\nMANAGER'S FEEDBACK:\nStrengths: {{ $json.strengthsFeedback }}\nAreas for Improvement: {{ $json.improvementsFeedback }}\nAdditional Comments: {{ $json.managerComments }}\n\nINSTRUCTIONS:\nGenerate a performance review summary with the following structure. Return ONLY valid JSON with no markdown formatting, no code blocks, and no additional text:\n\n{\n \"executiveSummary\": \"A compelling 2-3 sentence overview that captures the employee's overall performance, key impact, and standing within the team. Be specific and reference actual scores.\",\n \"keyStrengths\": [\n \"First major strength with specific example or metric\",\n \"Second major strength with specific example or metric\",\n \"Third major strength with specific example or metric\"\n ],\n \"developmentAreas\": [\n \"First development opportunity phrased constructively with actionable steps\",\n \"Second development opportunity phrased constructively with actionable steps\"\n ],\n \"closingStatement\": \"An inspiring, forward-looking statement that motivates the employee and acknowledges their value to the organization. Should be encouraging and personalized.\"\n}\n\nIMPORTANT: \n- Return ONLY the JSON object\n- No markdown code blocks (no ```json or ```)\n- No additional text before or after the JSON\n- Ensure all strings are properly escaped\n- Be specific and reference actual performance metrics\n- Keep a professional yet warm tone" } ] }, "temperature": 0.7, "builtInTools": {} }, "position": [ 1408, 240 ] }, { "id": "2b2381b7-6b12-4245-bbb7-557c7f5c3f64", "name": "Receive Review Data", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "performance-review", "options": {}, "httpMethod": "POST", "responseMode": "responseNode" }, "position": [ 912, 240 ] }, { "id": "4b00cbde-7e41-456a-ae89-107a020a441a", "name": "Parse AI Response", "type": "code", "params": { "jsCode": "// Get the OpenAI response from the new output structure\nconst openaiOutput = $input.item.json.output[0].content[0].text;\n\n// Remove markdown code blocks if present\nlet cleanedResponse = openaiOutput\n .replace(/```json\\s*/g, '')\n .replace(/```\\s*/g, '')\n .trim();\n\n// Parse the JSON\nlet aiSummary;\ntry {\n aiSummary = JSON.parse(cleanedResponse);\n} catch (error) {\n // If parsing fails, try to extract JSON from text\n const jsonMatch = cleanedResponse.match(/\\{[\\s\\S]*\\}/);\n if (jsonMatch) {\n aiSummary = JSON.parse(jsonMatch[0]);\n } else {\n throw new Error('Could not parse AI response: ' + error.message);\n }\n}\n\n// Get previous node data (from the Process Employee Data node)\nconst previousData = $('Process Employee Data').item.json;\n\n// Merge everything together\nconst output = {\n ...previousData, // All employee data from Code node\n \n // AI-generated content\n executiveSummary: aiSummary.executiveSummary,\n keyStrengths: aiSummary.keyStrengths,\n developmentAreas: aiSummary.developmentAreas,\n closingStatement: aiSummary.closingStatement,\n \n // Keep original AI response for reference\n aiResponseRaw: openaiOutput,\n \n // Format strengths and development areas as HTML lists for later use\n strengthsHTML: aiSummary.keyStrengths\n .map(strength => `

${strength}

`)\n .join(''),\n developmentHTML: aiSummary.developmentAreas\n .map(area => `

${area}

`)\n .join('')\n};\n\nreturn { json: output };\n" }, "position": [ 1744, 240 ] }, { "id": "4fe253db-456b-403d-b9f7-cf017587cc7e", "name": "Generate Review Card HTML", "type": "code", "params": { "jsCode": "// Get all the data\nconst data = $input.item.json;\n\n// Generate the complete HTML document\nconst html = `\n\n\n \n \n Performance Review - ${data.employeeName}\n \n\n\n

\n \n \n

Employee

${data.employeeName}

Department

${data.department}

Reviewer

${data.managerName}

\n \n

${data.overallRating}

/5.0

${data.performanceLevel}

Overall Performance Rating

\n \n

Performance Metrics

Technical Skills

${data.technicalScore}/5.0

Communication

${data.communicationScore}/5.0

Leadership

${data.leadershipScore}/5.0

Productivity

${data.productivityScore}/5.0

Teamwork

${data.teamworkScore}/5.0

\n \n

AI-Generated Executive Summary

\n ${data.executiveSummary}\n

\n \n

Key Strengths

\n ${data.strengthsHTML}\n \n

\n \n

Development Opportunities

\n ${data.developmentHTML}\n \n

\n \n

\n ${data.closingStatement}\n

\n \n \n

\n\n`;\n\n// Return all data plus the HTML\nreturn {\n json: {\n ...data,\n html: html\n }\n};" }, "position": [ 2000, 240 ] }, { "id": "56077bfe-f3d6-430a-8a2c-931039994e0c", "name": "Send Review to Employee", "type": "integration", "params": { "sendTo": "={{ $('Parse AI Response').item.json.employeeEmail }}", "message": "=\n\n\n \n \n\n\n

🎯 Performance Review Complete

\n \n

Dear {{ $('Parse AI Response').item.json.employeeName }},

\n \n

Your performance review for {{ $('Parse AI Response').item.json.reviewPeriod }} has been completed by {{ $('Parse AI Response').item.json.managerName }}. We're pleased to share your comprehensive evaluation and feedback.

\n \n

Your Overall Performance Rating

{{ $('Parse AI Response').item.json.overallRating }}/5.0

\n \n

📊 Executive Summary

\n \n

✨ Performance Highlights

Technical Skills: {{ $('Parse AI Response').item.json.technicalScore }}/5.0
Productivity: {{ $('Parse AI Response').item.json.productivityScore }}/5.0
Communication: {{ $('Parse AI Response').item.json.communicationScore }}/5.0
Teamwork: {{ $('Parse AI Response').item.json.teamworkScore }}/5.0
Leadership: {{ $('Parse AI Response').item.json.leadershipScore }}/5.0

\n \n

📎

\n Detailed Review Card Attached\n Your complete performance review card is attached as a high-quality image. It includes detailed metrics, AI-generated insights, key strengths, and personalized development recommendations.\n

\n \n

📅 Next Steps

We encourage you to schedule a follow-up meeting with {{ $('Parse AI Response').item.json.managerName }} to discuss:

Your career development goals for the upcoming quarter
Training and professional growth opportunities
Questions or clarifications about your review
Resources and support to help you succeed

\n \n \n 📅 Schedule Your 1-on-1 Meeting\n \n \n

Thank you for your continued dedication and valuable contributions to the {{ $('Parse AI Response').item.json.department }} team. We appreciate your hard work and commitment to excellence.

\n \n

Best regards,
\n Human Resources Department
\n {{ $('Parse AI Response').item.json.department }} Division

\n \n \n

\n\n", "options": { "attachmentsUi": { "attachmentsBinary": [ { "property": "=data" } ] } }, "service": "gmail", "subject": "=Your {{ $('Parse AI Response').item.json.reviewPeriod }} Performance Review - {{ $('Parse AI Response').item.json.performanceLevel }}", "operation": "read" }, "position": [ 2528, 240 ] }, { "id": "97f6e05e-8ec9-44d8-b874-13810b22343f", "name": "Download Image", "type": "http", "params": { "url": "={{ $json.image_url }}", "options": { "response": { "response": { "responseFormat": "file" } } } }, "position": [ 2368, 240 ] }, { "id": "774ae079-daec-45e7-bef7-5291c3a85644", "name": "Log to Google Sheets", "type": "integration", "params": { "columns": { "value": { "Date": "={{ $('Parse AI Response').item.json.reviewDate }}", "Image URL": "={{ $('Convert HTML to Image').item.json.image_url }}", "Review ID": "={{ $('Parse AI Response').item.json.reviewId }}", "Department": "={{ $('Parse AI Response').item.json.department }}", "Email Sent": "Yes", "Employee ID": "={{ $('Parse AI Response').item.json.employeeId }}", "Manager Name": "={{ $('Parse AI Response').item.json.managerName }}", "Average Score": "={{ $('Parse AI Response').item.json.averageScore }}", "Employee Name": "={{ $('Parse AI Response').item.json.employeeName }}", "Review Period": "={{ $('Parse AI Response').item.json.reviewPeriod }}", "Employee Email": "={{ $('Parse AI Response').item.json.employeeEmail }}", "Overall Rating": "={{ $('Parse AI Response').item.json.overallRating }}", "Teamwork Score": "={{ $('Parse AI Response').item.json.teamworkScore }}", "Technical Score": "={{ $('Parse AI Response').item.json.technicalScore }}", "Leadership Score": "={{ $('Parse AI Response').item.json.leadershipScore }}", "Executive Summary": "={{ $('Parse AI Response').item.json.executiveSummary }}", "Performance Level": "={{ $('Parse AI Response').item.json.performanceLevel }}", "Productivity Score": "={{ $('Parse AI Response').item.json.productivityScore }}", "Communication Score": "={{ $('Parse AI Response').item.json.communicationScore }}", "Low Performer Alert": "={{ $('Parse AI Response').item.json.isLowPerformer ? 'Yes' : 'No' }}" }, "schema": [ { "id": "Review ID", "type": "string", "display": true, "required": false, "displayName": "Review ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Date", "type": "string", "display": true, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Employee ID", "type": "string", "display": true, "required": false, "displayName": "Employee ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Employee Name", "type": "string", "display": true, "required": false, "displayName": "Employee Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Employee Email", "type": "string", "display": true, "required": false, "displayName": "Employee Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Department", "type": "string", "display": true, "required": false, "displayName": "Department", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Manager Name", "type": "string", "display": true, "required": false, "displayName": "Manager Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Review Period", "type": "string", "display": true, "required": false, "displayName": "Review Period", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Overall Rating", "type": "string", "display": true, "required": false, "displayName": "Overall Rating", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Performance Level", "type": "string", "display": true, "required": false, "displayName": "Performance Level", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Technical Score", "type": "string", "display": true, "required": false, "displayName": "Technical Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Communication Score", "type": "string", "display": true, "required": false, "displayName": "Communication Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Leadership Score", "type": "string", "display": true, "required": false, "displayName": "Leadership Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Productivity Score", "type": "string", "display": true, "required": false, "displayName": "Productivity Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Teamwork Score", "type": "string", "display": true, "required": false, "displayName": "Teamwork Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Average Score", "type": "string", "display": true, "required": false, "displayName": "Average Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Image URL", "type": "string", "display": true, "required": false, "displayName": "Image URL", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Sent", "type": "string", "display": true, "required": false, "displayName": "Email Sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Low Performer Alert", "type": "string", "display": true, "required": false, "displayName": "Low Performer Alert", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Executive Summary", "type": "string", "display": true, "required": false, "displayName": "Executive Summary", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_ID/edit#gid=0", "cachedResultName": "YOUR_SHEET_NAME" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "YOUR_DOCUMENT_NAME" } }, "position": [ 2768, 240 ] }, { "id": "c5280bdf-bbd5-4c3b-8cb3-6191097a30a4", "name": "Notify HR Team", "type": "integration", "params": { "text": "=✅ *Performance Review Successfully Processed*\n\n*Employee:* {{ $('Parse AI Response').item.json.employeeName }}\n*Department:* {{ $('Parse AI Response').item.json.department }}\n*Review Period:* {{ $('Parse AI Response').item.json.reviewPeriod }}\n\n*Performance Summary:*\n- Overall Rating: {{ $('Parse AI Response').item.json.overallRating }}/5.0 - {{ $('Parse AI Response').item.json.performanceLevel }}\n- Technical: {{ $('Parse AI Response').item.json.technicalScore }}/5 | Communication: {{ $('Parse AI Response').item.json.communicationScore }}/5\n- Leadership: {{ $('Parse AI Response').item.json.leadershipScore }}/5 | Productivity: {{ $('Parse AI Response').item.json.productivityScore }}/5\n- Teamwork: {{ $('Parse AI Response').item.json.teamworkScore }}/5\n\n*Status:*\n✉️ Email sent to: {{ $('Parse AI Response').item.json.employeeEmail }}\n📋 Manager CC'd: {{ $('Parse AI Response').item.json.managerEmail }}\n📸 Review card: <{{ $('Convert HTML to Image').item.json.image_url }}|View Image>\n📝 Review ID: {{ $('Parse AI Response').item.json.reviewId }}\n\n{{ $('Parse AI Response').item.json.isLowPerformer ? '⚠️ *Low performer alert triggered - Manager notified*' : '✅ Performance within normal range' }}", "select": "channel", "service": "slack", "channelId": { "__rl": true, "mode": "list", "value": "YOUR_SLACK_CHANNEL_ID", "cachedResultName": "YOUR_CHANNEL_NAME" }, "operation": "read", "otherOptions": {} }, "position": [ 2944, 240 ] }, { "id": "abef2c32-c886-4ac6-83d4-cc4d8dca7bf8", "name": "Convert HTML to Image", "type": "integration", "params": { "service": "htmlcsstoimage", "operation": "run", "html_content": "={{ $json.html }}", "__originalType": "n8n-nodes-htmlcsstoimage.htmlCssToImage", "response_format_html": "png" }, "position": [ 2192, 240 ] }, { "id": "a8883617-c50f-4dfd-b2c5-b9ac26a31cd7", "name": "Send Webhook Response", "type": "passthrough", "params": { "mode": "noOp", "options": {}, "respondWith": "json", "responseBody": "={\n \"success\": true,\n \"message\": \"Performance review processed successfully\",\n \"reviewId\": \"={{ $('Parse AI Response').item.json.reviewId }}\",\n \"employeeName\": \"={{ $('Parse AI Response').item.json.employeeName }}\",\n \"overallRating\": \"={{ $('Parse AI Response').item.json.overallRating }}\",\n \"performanceLevel\": \"={{ $('Parse AI Response').item.json.performanceLevel }}\",\n \"imageUrl\": \"={{ $('Convert HTML to Image').item.json.image_url }}\",\n \"emailSent\": true,\n \"timestamp\": \"={{ $('Parse AI Response').item.json.processedAt }}\"\n}" }, "position": [ 3104, 240 ] } ] }

Generate employee performance review summaries with GPT-4, Gmail and Sheets