Quiz tổng hợp

1## Email Classifier & Auto-Action Workflow
2 
3### Tổng quan:
4Gmail Trigger → Code Node (Classify)
5→ Switch Node → 3 nhánh:
6  - Meeting → Google Calendar
7  - Task → Trello
8  - Info → Google Sheets
9 
10### Chi tiết workflow:
11 
12NODE 1 — Gmail Trigger:
13- Trigger: Mỗi khi có email mới
14- Filter: Inbox (bỏ qua Spam/Promotions)
15- Output: subject, body, from, date, labels
16 
17NODE 2 — Code Node (Email Classifier):
18- Logic phân loại dựa trên keywords:
19  const subject = $json.subject.toLowerCase();
20  const body = $json.body.toLowerCase();
21 
22  if (subject.includes('meeting') ||
23      subject.includes('họp') ||
24      subject.includes('calendar invite') ||
25      body.includes('zoom.us') ||
26      body.includes('meet.google.com')) {
27    return { category: 'meeting', ...items };
28  }
29  if (subject.includes('task') ||
30      subject.includes('deadline') ||
31      subject.includes('yêu cầu') ||
32      subject.includes('cần làm')) {
33    return { category: 'task', ...items };
34  }
35  return { category: 'info', ...items };
36 
37NODE 3 — Switch Node:
38- Field: {{ $json.category }}
39- Case 'meeting' → Nhánh Calendar
40- Case 'task' → Nhánh Trello
41- Case 'info' → Nhánh Sheets
42 
43NODE 4A — Set Node (Parse Meeting Info):
44- Trích xuất: ngày, giờ, tiêu đề cuộc họp
45- Tên: {{ $json.subject }}
46- Start: parse từ email body (regex date pattern)
47- Duration: mặc định 60 phút
48- Attendees: {{ $json.from }}
49 
50NODE 5A — Google Calendar Node:
51- Operation: Create Event
52- Calendar: Work Calendar
53- Summary: {{ $json.meetingTitle }}
54- Start/End: từ Set Node
55- Description: Email body + link gốc
56- Attendees: email người gửi
57 
58NODE 4B — Trello Node (Task branch):
59- Operation: Create Card
60- Board: "Work Tasks"
61- List: "To Do"
62- Name: {{ $json.subject }}
63- Description: {{ $json.body }} + "\n\nFrom: "
64  + {{ $json.from }}
65- Due Date: {{ $now.plus(3, 'days').toISO() }}
66 
67NODE 4C — Google Sheets Node (Info branch):
68- Operation: Append Row
69- Sheet: "Email Summary Log"
70- Columns: Date | From | Subject | Summary
71- Summary: {{ $json.body.substring(0, 200) }}
72 
73NODE 6 — Slack Node (cuối mỗi nhánh):
74- Gửi notification: "📧 Email phân loại:
75  [{{ $json.category }}] {{ $json.subject }}"
76- Channel: #email-digest
77 
78### Error Handling:
79- Mỗi nhánh bật Continue On Fail
80- Error Workflow gửi Slack khi classify sai
81- Retry On Fail cho Google Calendar/Trello: 2 lần

1## Weekly Multi-Channel Report Workflow
2 
3### Tổng quan:
4Cron Trigger (Thứ 2, 9:00 AM)
5→ Song song: Sheets + Trello + Gmail (lấy dữ liệu)
6→ Merge Node → Code Node (tổng hợp)
7→ Song song: Slack + Notion + Email PDF
8 
9### Chi tiết workflow:
10 
11NODE 1 — Cron Trigger:
12- Schedule: Mỗi thứ 2 lúc 9:00 AM
13- Timezone: Asia/Ho_Chi_Minh
14 
15NODE 2A — Google Sheets Node (Doanh thu):
16- Operation: Get All Rows
17- Sheet: "Revenue 2026"
18- Filter: Dữ liệu 7 ngày gần nhất
19- Output: daily_revenue, total_orders, avg_order_value
20 
21NODE 2B — Trello Node (Tiến độ):
22- Operation: Get Cards
23- Board: "Project Board"
24- Output: total cards, done, in progress, overdue
25 
26NODE 2C — Gmail Node (Email):
27- Operation: Get All
28- Filter: is:unread
29- Output: unread_count, oldest_unread_date
30 
31NODE 3 — Merge Node:
32- Mode: Merge by Position
33- Gộp dữ liệu từ 3 nguồn thành 1 object
34 
35NODE 4 — Code Node (Report Generator):
36- Tính toán KPIs:
37  + Tổng doanh thu tuần
38  + So sánh % với tuần trước
39  + Số task hoàn thành / tổng task
40  + Completion rate %
41  + Email chưa xử lý
42- Format báo cáo dạng structured object
43 
44NODE 5A — Slack Node:
45- Channel: #weekly-report
46- Message (Block Kit):
47  "📊 BÁO CÁO TUẦN {{ $now.format('DD/MM/YYYY') }}
48   💰 Doanh thu: {{ $json.totalRevenue }}đ
49      ({{ $json.revenueGrowth }}% so tuần trước)
50   📋 Tasks: {{ $json.tasksDone }}/{{ $json.totalTasks }}
51      hoàn thành ({{ $json.completionRate }}%)
52   📧 Email chờ xử lý: {{ $json.unreadEmails }}"
53 
54NODE 5B — Notion Node:
55- Operation: Create Page
56- Database: "Weekly Reports"
57- Properties:
58  + Title: "Báo cáo tuần {{ $json.weekNumber }}"
59  + Date: {{ $now }}
60  + Revenue: {{ $json.totalRevenue }}
61  + Status: {{ $json.completionRate > 80
62    ? 'On Track' : 'Behind' }}
63- Content: Full report markdown
64 
65NODE 5C — HTML to PDF → Gmail Node:
66- HTML template: Báo cáo chuyên nghiệp
67  (logo, bảng KPIs, biểu đồ, kết luận)
68- HTTP Request → PDF service
69- Gmail Node: Gửi email đến quản lý
70  + Subject: "[Báo cáo tuần] {{ $json.weekRange }}"
71  + Attachment: report.pdf
72  + To: manager@company.com
73 
74### Error Handling:
75- Mỗi source node bật Continue On Fail
76- IF Node kiểm tra: nếu source fail → ghi chú
77  "Dữ liệu không khả dụng" trong báo cáo
78- Error Workflow → Slack #alerts nếu workflow fail
79- Retry On Fail: 3 lần cho mỗi API call

1## Employee Onboarding Automation System
2 
3### Kiến trúc tổng quan:
4Main Workflow (Webhook - nhận form)
5  → Sub-WF 1: Account Setup (Slack, Trello)
6  → Sub-WF 2: Knowledge Base (Notion)
7  → Sub-WF 3: Welcome Package (Email, Drive)
8  → Sub-WF 4: Team Notification (Slack, Calendar)
9Error Workflow → Alert & Rollback
10 
11### MAIN WORKFLOW — Onboarding Orchestrator:
12 
13NODE 1 — Webhook Trigger:
14- Method: POST
15- Path: /onboarding/new-employee
16- Authentication: Header Auth (API key)
17- Input: { name, email, department, role,
18  startDate, managerId }
19- Response: Immediately (return onboarding ID)
20 
21NODE 2 — Set Node (Validate & Enrich):
22- Validate: email format, required fields
23- Generate: onboardingId = UUID
24- Add: timestamp, status = "in_progress"
25- Lookup: manager info từ Google Sheets
26 
27NODE 3 — Google Sheets Node (Log Start):
28- Append row: onboardingId | name | email |
29  department | startDate | status: "started"
30 
31NODE 4 — Execute Workflow (Account Setup):
32- Sub-WF: "Onboarding - Account Setup"
33- Input: name, email, department, role
34- Wait for completion
35- Output: { slackUserId, trelloBoardId }
36 
37NODE 5 — Execute Workflow (Knowledge Base):
38- Sub-WF: "Onboarding - Notion Setup"
39- Input: name, email, department, role,
40  slackUserId (từ Node 4)
41- Output: { notionPageUrl, wikiLinks }
42 
43NODE 6 — Execute Workflow (Welcome Package):
44- Sub-WF: "Onboarding - Welcome Email"
45- Input: name, email, notionPageUrl, wikiLinks,
46  startDate, managerName
47- Output: { emailSent, driveFolder }
48 
49NODE 7 — Execute Workflow (Team Notification):
50- Sub-WF: "Onboarding - Notify Team"
51- Input: name, role, department, startDate,
52  slackUserId, managerSlackId
53- Output: { notificationsSent }
54 
55NODE 8 — Google Sheets Node (Log Complete):
56- Update row: status = "completed"
57- Add: completedAt, allAccountLinks
58 
59### SUB-WORKFLOW 1 — Account Setup:
60 
61NODE A1 — Execute Workflow Trigger
62NODE A2 — Slack Node (Invite User):
63- Operation: Invite to Workspace
64- Email: {{ $json.email }}
65- Channels: #general, #{{ $json.department }}
66 
67NODE A3 — Trello Node (Create Board):
68- Board: "Onboarding - {{ $json.name }}"
69- Template: "Onboarding Checklist"
70- Lists: Week 1, Week 2, Week 3, Week 4
71- Pre-populated cards: IT setup, HR docs,
72  team intro, training schedule
73 
74NODE A4 — Set Output:
75- slackUserId, trelloBoardUrl
76 
77### SUB-WORKFLOW 2 — Notion Setup:
78 
79NODE B1 — Execute Workflow Trigger
80NODE B2 — Notion Node (Create Employee Page):
81- Database: "Team Directory"
82- Properties: Name, Email, Department, Role,
83  Start Date, Slack ID
84- Content: Welcome message template,
85  links to wiki, team docs
86 
87NODE B3 — Notion Node (Create Personal Wiki):
88- Parent: Employee Page
89- Template: Onboarding wiki (company culture,
90  tools guide, FAQ, contacts)
91 
92NODE B4 — Set Output:
93- notionPageUrl, personalWikiUrl
94 
95### SUB-WORKFLOW 3 — Welcome Package:
96 
97NODE C1 — Execute Workflow Trigger
98NODE C2 — Google Drive Node (Create Folder):
99- Folder: "Employees/{{ $json.name }}"
100- Subfolders: Documents, Projects, Training
101 
102NODE C3 — Google Drive Node (Copy Templates):
103- Copy: Employee handbook, NDA, IT policy
104- To: Employee folder
105 
106NODE C4 — Gmail Node (Welcome Email):
107- To: {{ $json.email }}
108- Subject: "Chào mừng {{ $json.name }} đến với
109  công ty! 🎉"
110- HTML template: Welcome message, links
111  (Slack, Trello board, Notion wiki, Drive folder),
112  first week schedule, manager contact
113- CC: {{ $json.managerEmail }}
114 
115### SUB-WORKFLOW 4 — Team Notification:
116 
117NODE D1 — Execute Workflow Trigger
118NODE D2 — Slack Node (Team Announcement):
119- Channel: #{{ $json.department }}
120- Message: "👋 Chào mừng {{ $json.name }} gia nhập
121  team {{ $json.department }} với vai trò
122  {{ $json.role }}!
123  📅 Ngày bắt đầu: {{ $json.startDate }}
124  Hãy chào đón thành viên mới nhé!"
125 
126NODE D3 — Google Calendar Node:
127- Create Event: "Welcome {{ $json.name }}"
128- Date: {{ $json.startDate }} 10:00 AM
129- Duration: 30 phút
130- Attendees: team members + manager
131- Description: "Team introduction meeting"
132 
133### ERROR WORKFLOW:
134 
135NODE E1 — Error Trigger
136NODE E2 — IF Node (Check which sub-WF failed):
137- Account Setup fail → rollback Slack invite
138- Notion fail → log, continue (non-critical)
139- Email fail → retry 3 times, then alert
140- Notification fail → log only
141 
142NODE E3 — Slack Alert:
143- Channel: #hr-alerts
144- Message: "⚠️ Onboarding FAILED
145  Employee: {{ $json.employeeName }}
146  Step: {{ $json.failedWorkflow }}
147  Error: {{ $json.errorMessage }}
148  Action Required: Manual intervention"
149 
150NODE E4 — Google Sheets (Error Log):
151- Log: onboardingId | failedStep | error |
152  timestamp | resolved: false
153 
154### Monitoring Dashboard:
155- Google Sheets "Onboarding Tracker":
156  Tổng onboarding | Success rate | Avg time
157  | Failed steps trending
158- Cron Trigger (daily) → check incomplete
159  onboardings > 24h → alert HR team