Live Automation Projects — N8N · Airtable · Grok AI
IT Automation by Vraj Desai
Two production-grade automation systems built from scratch — a fully AI-powered IT support ticketing bot and a real-time website health monitoring suite. Both live. Both running.
A complete end-to-end IT support system across two N8N workflows. Users submit issues via Telegram, Grok AI classifies severity and generates resolution steps, tickets are created in Airtable, and a scheduled resolution workflow automatically closes the loop — from intake to resolved, zero manual steps.
STEPS: · Restart the computer and see if the issue persists. · Check for any error messages and provide more details. · Ensure all software updates are installed and try safe mode.
✅ Your issue has been logged. Keep your ticket number for tracking!
This message was sent automatically with n8n · 22:32
⚙️ Hi Vraj! 🎫 Ticket #20 is in progress! 🔧 Our IT team is actively working on: i have issue in my computer. We will notify you once resolved! Thank you for your patience 🙏
This message was sent automatically with n8n · 22:33
✅ Good news Vraj! 🎫 Ticket #20 has been resolved! 🖥️ Problem: i have issue in my computer 🔧 Your issue has been addressed by our IT team. Thank you for your patience!
This message was sent automatically with n8n
Airtable Data Layer — IT Support Tickets Base
📋
IT support tickets
IT support · Grid view · 20 live records
#
Problem Description
Severity
AI Response (truncated)
Status
Timestamp
2
My computer screen is flick...
Medium
SEVERITY: Medium STEPS: ...
Notified
—
7
There is noise of cooling fan
Low
SEVERITY: Low STEPS: 1. Ve...
Notified
—
9
My mouse is not working
Medium
SEVERITY: Medium STEPS: ...
Notified
—
14
I've been hacked
High
SEVERITY: High STEPS: 1. I...
Notified
—
20
i have issue in my computer
Low
SEVERITY: Low STEPS: Rest...
Notified
5/3/2026 10:32pm
Grok AI via HTTP
Every ticket message is sent via HTTP POST to api.groq.com. The model returns Low / Medium / High severity and step-by-step resolution guidance in real time — fully integrated, not mocked.
Full Ticket Lifecycle
Three automated touchpoints per ticket: intake confirmation with AI steps, in-progress notification, and resolved closure — complete lifecycle with zero manual input.
Scheduled SLA Checks
Workflow 2 runs on a schedule, queries Airtable for open tickets, evaluates resolution status via an If condition, and automatically notifies users and updates records.
Structured Audit Trail
Every ticket logged with Chat ID, username, problem description, AI-assigned severity, full AI response text, notification status, and timestamp in Airtable.
20+
Live tickets processed
3
Automated touchpoints per ticket
Grok AI
Real API — not mocked
100%
Tickets notified, zero missed
02 — Real-Time System Health Monitor
PROJECT_02 / SYSTEM_HEALTH_MONITOR
LIVE · SystemMonitor_VD_Bot
Automated System Health Checker & Daily Report
A two-workflow monitoring suite that performs scheduled HTTP availability checks, detects outages in real time, fires instant Telegram alerts via SystemMonitor_VD_Bot, logs all incidents and recovery events to Airtable with timestamps, and delivers an automated daily health digest — built entirely from scratch.
▸ WORKFLOW 3: System Health Monitor — Real-Time Outage Detection
🕐 Schedule Trigger 1 item
→
{ } Code in JS 5 items
→
✏️ Edit Fields 1 item
→
🌐 HTTP Request Ping URL
→
⚡ If — site down?
→ true (site DOWN): immediate alert path
🚨 Send Alert Telegram
→
🗄️ Create Record Log incident + time
→ false (site UP): recovery check path
🗄️ Search Records 5 items
→
⚡ If1 — was down?
→
✅ Send Recovery Telegram · 5 items
→
🗄️ Update Record Recovery time
▸ WORKFLOW 4: Daily Health Report — Scheduled Digest to Telegram
🕐 Schedule Trigger
→
🗄️ Search Records All incidents
→
{ } Code in JS Format report
→
✈️ Send Report Daily digest
Live Telegram Bot — SystemMonitor_VD_Bot
📡
SystemMonitor_VD_Bot
bot · Powered by N8N · Real-time website monitoring
🚨 WEBSITE DOWN ALERT! 🌐 URL: https://www.google.com 🕐 Detected: 2026-03-09T18:50:18.105+00:00 ❌ Site is not responding! Please investigate immediately!
This message was sent automatically with n8n · 18:50
🚨 WEBSITE DOWN ALERT! 🌐 URL: https://www.google.com 🕐 Detected: 2026-03-09T19:08:43.185+00:00 ❌ Site is not responding! Please investigate immediately!
This message was sent automatically with n8n · 19:08
✅ WEBSITE RECOVERED! 🌐 URL: https://www.google.com 🕐 Recovered at: 2026-03-09T19:10:04.930+00:00 ⚡ Site is back online! All systems normal! 🎉
This message was sent automatically with n8n · 19:10
Airtable Data Layer — System Incidents Base
📊
System Incidents
Table 1 · Grid view · 12 records logged
#
URL
Site Status
Response Time
Incident Time
Recovery Time
Notified
1
https://www.google.com
Up
0.0
9/3/2026 2:22pm
9/3/2026 2:38pm
Yes
4
https://www.google.com
Up
0.0
9/3/2026 4:05pm
9/3/2026 4:05pm
Yes
7
https://www.wikipedia.org
Up
0.0
9/3/2026 4:29pm
9/3/2026 4:45pm
Yes
11
https://this-fake-site-123.c...
Up
0.0
9/3/2026 7:08pm
9/3/2026 7:10pm
Yes
12
https://this-fake-site-123.c...
Up
0.0
9/3/2026 7:10pm
9/3/2026 7:13pm
Yes
Real-Time Detection
Scheduled HTTP pings check target URLs on a defined interval. If a site fails, a Telegram DOWN alert fires in the same execution cycle with the exact timestamp of detection.
Automated Recovery Alerts
On recovery, the workflow searches existing Airtable incidents, confirms the site was previously down, sends a "back online" Telegram notification, and stamps the recovery time.
JavaScript Processing
Custom Code-in-JavaScript nodes handle health check evaluation logic and daily report formatting — going beyond standard N8N configuration into real scripting.
Daily Health Digest
A separate scheduled workflow queries all Airtable incident records, formats a structured summary using JavaScript, and sends a daily Telegram report automatically.
12+
Incidents logged in Airtable
<5min
Detection-to-alert speed
2
Workflows: monitor + daily report
100%
All incidents notified
03 — About the Engineer
VD
Vraj Desai
IT Support Engineer · CCNA 2026 · Microsoft 365 Certified 2025 · Apple-Trained · 6+ Years Enterprise IT Experience