📋 ACTION PLAN v1.0 — AGUSTUS 2026

Action Plan: Hermes AI Agent × Panorama Nur Mecca

From Manual to Automated — Step by Step

Hermes v0.17.0 — VM-1-102

Telegram Gateway: ACTIVE

agenumroh.my.id — VPS 200

0. Current State Assessment

Where we stand today — infrastructure, wins, and gaps

Infrastructure

🖥️

Hermes v0.17.0 on VM-1-102-ubuntu
Telegram gateway: ACTIVE

🌐

agenumroh.my.id on VPS 200
Laravel 11 + MariaDB

🗄️

DB: agenumroh @ 43.157.241.200
SSH tunnel from current VPS

Database Tables

👥 jamaah — customer records

📦 partner_packages — umrah packages

✈️ kloters — departure groups

📝 umroh_registrations — bookings

🗺️ itineraries — trip schedules

🕌 manasik_* — rituals guide

🏨 hotel_* — accommodation

🤝 vendor_* — vendor data

What's Working Now

Telegram bot responding (user 227752163)
Cron: umroh clusters generator (daily 10am)
agenumroh CRM: jamaah, packages, kloters
SSH tunnel: current VPS → VPS 200 DB
Hermes memory & skills framework ready

What's Missing

No API bridge between Hermes and agenumroh DB
No automated content pipeline
No customer communication automation
No reporting automation
No multi-agent setup

⚡

Phase 1 — Quick Wins

Minggu 1-2 Target: Hemat 5-8 jam/minggu Zero coding required

Phase 1 Progress0%

1.1 Content Drafting Bot

TODO

Setup Create skill pnm-content-drafter in Hermes

Trigger Admin kirim ke Telegram: "Buat konten paket [nama paket]"

Flow Hermes reads partner_packages from DB (via SSH + mysql command) → generates 3 caption variants (hard-sell, emotional, informatif) + posting schedule

Verifikasi Test dengan paket existing, check output quality

Tools write_file, terminal (SSH mysql), memory

Estimasi 2 jam

Siapa Kerjakan & Kapan Fernando — Minggu 1, Hari 1-2

1.2 Daily Booking Summary

TODO

Setup Create cron job, schedule 0 8 * * *

Prompt "Query agenumroh DB for new registrations in last 24h, summarize by status (baru/dihubungi/jadi_jamaah/batal), count seats available per active kloter. Format as morning briefing."

Delivery Telegram to user (227752163)

SQL Query

SELECT status, COUNT(*) as cnt
FROM umroh_registrations
WHERE created_at >= NOW() - INTERVAL 1 DAY
GROUP BY status;

Verifikasi Check Telegram each morning for 1 minggu

Estimasi 1 jam

Siapa Kerjakan & Kapan Fernando — Minggu 1, Hari 2-3

1.3 Document Checklist Monitor

TODO

Setup Create cron job, schedule 0 9 * * 1 (setiap Senin)

Output "Kloter B3: 3 jamaah belum lengkap (2 belum vaksin, 1 belum upload foto)"

SQL Query

SELECT j.nama, j.dok_vaksin, j.dok_foto,
       k.kode as kloter
FROM jamaah j
JOIN umroh_registrations r ON j.id = r.jamaah_id
JOIN kloters k ON r.kloter_id = k.id
WHERE (j.dok_vaksin IS NULL OR j.dok_foto IS NULL)
  AND k.status != 'selesai';

Verifikasi Manual check against DB

Estimasi 1 jam

Siapa Kerjakan & Kapan Fernando — Minggu 1, Hari 3

1.4 Weekly Financial Snapshot

TODO

Setup Create cron job, schedule 0 8 * * 1 (Senin 8am)

Query Count registrations, estimate revenue dari partner_packages.harga_jual × registrations per kloter

Output Telegram summary card: total pax, revenue estimate, kloter breakdown

Estimasi 1 jam

Siapa Kerjakan & Kapan Fernando — Minggu 1, Hari 3-4

🔧

Phase 2 — Core Automation

Minggu 3-4 Target: Hemat 12-15 jam/minggu Requires DB API setup

Phase 2 Progress0%

2.1 Build REST API Bridge

TODO

Overview On VPS 200: Create simple Laravel API routes untuk Hermes query. Routes: GET /api/v1/jamaah/stats, GET /api/v1/kloter/active, GET /api/v1/package/{id}/seats. Auth: API key di .env

Laravel Route Code (tambah ke routes/api.php)

routes/api.phpuse Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

Route::middleware('auth:api')->group(function () {

    Route::get('/jamaah/stats', function () {
        $stats = DB::select("
            SELECT status, COUNT(*) as cnt
            FROM umroh_registrations
            GROUP BY status
        ");
        return response()->json([
            'registrations' => $stats,
            'total' => array_sum(array_column($stats, 'cnt')),
        ]);
    });

    Route::get('/kloter/active', function () {
        $kloters = DB::table('kloters')
            ->where('status', 'active')
            ->get();
        return response()->json($kloters);
    });

    Route::get('/package/{id}/seats', function ($id) {
        $pkg = DB::table('partner_packages')->find($id);
        $booked = DB::table('umroh_registrations')
            ->where('package_id', $id)
            ->whereNotIn('status', ['batal'])
            ->count();
        return response()->json([
            'package' => $pkg->name,
            'total_seats' => $pkg->kuota,
            'booked' => $booked,
            'available' => $pkg->kuota - $booked,
        ]);
    });
});

Hermes Call

curl -H "Authorization: Bearer $API_KEY" \
  https://agenumroh.my.id/api/v1/jamaah/stats

Estimasi 3-4 jam

Siapa Kerjakan & Kapan Fernando — Minggu 3, Hari 1-2

2.2 Itinerary Auto-Generator

TODO

Trigger Admin kirim: "Generate itinerary kloter [kode], hotel [nama]"

Flow Hermes queries kloter + package data → uses itinerary_templates and template_days from DB → generates formatted itinerary (HTML/PDF)

Output File saved to workspace + Telegram notification with preview

Estimasi 4 jam

Siapa Kerjakan & Kapan Fernando — Minggu 3, Hari 3-4

2.3 Auto-Reply FAQ Bot

TODO

Trigger Seseorang kirim pesan ke Telegram bot dengan pertanyaan umum

Common Q "Berapa harga?", "Kapan berangkat?", "Hotel mana?", "Dokumen apa saja?"

Flow Hermes checks FAQ skill/knowledge base → auto-respond with data dari DB → escalate "Hubungi admin" untuk complex questions

Estimasi 3 jam

Siapa Kerjakan & Kapan Fernando — Minggu 4, Hari 1-2

2.4 Lead Follow-Up Scheduler

TODO

Query 1 umroh_registrations WHERE status='baru' AND first_contact_at IS NULL → generate follow-up draft

Query 2 umroh_registrations WHERE status='dihubungi' AND last_contact_at > 3 hari → "Follow-up needed"

Output "3 leads baru perlu dihubungi: [names, phone, package]"

Estimasi 2 jam

Siapa Kerjakan & Kapan Fernando — Minggu 4, Hari 3

🧠

Phase 3 — Intelligent Assistance

Minggu 5-8 Target: Hemat 20-25 jam/minggu

Phase 3 Progress0%

3.1 Customer Communication Pipeline

TODO

Pipeline Timeline

H-30 Welcome Message H-14 Doc Checklist H-7 Departure Briefing H-3 Meeting Point H-1 Final Reminder

Flow Hermes generates draft → Telegram ke admin → admin approve → send ke jamaah. Uses jamaah + kloter data.

Estimasi 4 jam

Siapa Kerjakan & Kapan Fernando — Minggu 5-6

3.2 Post-Trip Feedback Collection

TODO

Trigger Kloter status berubah ke 'selesai'

Flow Auto-draft feedback survey → auto-send thank-you → aggregate responses → improvement report

Estimasi 3 jam

Siapa Kerjakan & Kapan Fernando — Minggu 6-7

3.3 Content Calendar Automation

TODO

Flow Weekly: Hermes generates 7-day content calendar based on upcoming departures, Islamic events, testimonials

Output Daily posting plan dengan captions ready. Admin approve Senin, Hermes auto-post sisa minggu

Estimasi 4 jam

Siapa Kerjakan & Kapan Fernando — Minggu 7

3.4 Vendor Performance Tracker

TODO

Tracking Hotel vendors: room quality, response time, issues. Ticket partners: price, availability

Output Monthly report with recommendations

Estimasi 3 jam

Siapa Kerjakan & Kapan Fernando — Minggu 8

🚀

Phase 4 — Full Integration

Minggu 9-12 Target: Transform operations

Phase 4 Progress0%

4.1 Multi-Agent Setup

TODO

Agents

Agent 1: Marketing Agent 2: Operations Agent 3: CS

Marketing Agent Content, social media, campaigns

Operations Agent Itinerary, coordination, logistics

CS Agent Customer inquiries, FAQ, follow-up

Coordination Via Kanban board. Each agent has own Hermes profile with specialized skills.

Estimasi 8 jam — Fernando — Minggu 9-10

4.2 Real-Time Dashboard

TODO

Features Active kloters, seat occupancy, revenue, pending tasks — accessible via browser

Auto-refresh Via cron, Hermes regenerates HTML dashboard periodically

Estimasi 6 jam

Siapa Kerjakan & Kapan Fernando — Minggu 10-11

4.3 WhatsApp Blast Automation

TODO

Integration Fonnte/WABiz gateway. Hermes drafts → admin approve → auto-send to segment

Segments Per kloter, per status, per location

Compliance Opt-out handling, message limits

Estimasi 4 jam

Siapa Kerjakan & Kapan Fernando — Minggu 11-12

5. Prompt Library

Copy-paste ready prompts — tested, with SQL examples

1. Generate Caption for Paket

PHASE 1

Prompt

Buat konten promosi untuk paket umroh berikut: Nama: [NAMA_PAKET] Harga: [HARGA] Durasi: [HARI] hari Hotel: [NAMA_HOTEL] Maskapai: [MASKAPAI] Keberangkatan: [TANGGAL] Buat 3 varian caption: 1. Hard-sell (urgensi, harga, CTA) 2. Emotional (impian, perjalanan spiritual) 3. Informatif (detail lengkap, FAQ) Sertakan 5 hashtag populer + jadwal posting ideal.

SQL Query

SELECT name, harga_jual, durasi_hari, hotel_name, maskapai,
       tanggal_berangkatan, kuota, deskripsi
FROM partner_packages
WHERE name LIKE '%[NAMA_PAKET]%';

Customization

Ganti variabel dalam [] dengan data dari DB. Tambahkan brand voice guidelines di skill setup.

2. Morning Booking Summary

PHASE 1

Prompt

Query agenumroh DB for new registrations in last 24 hours. Summarize by status: baru, dihubungi, jadi_jamaah, batal. Count seats available per active kloter. Format as morning briefing for admin — concise, actionable.

SQL Query

-- Registrations last 24h
SELECT status, COUNT(*) as cnt
FROM umroh_registrations
WHERE created_at >= NOW() - INTERVAL 1 DAY
GROUP BY status;

-- Active kloters with seat count
SELECT k.kode, k.nama, p.kuota,
       COUNT(CASE WHEN r.status != 'batal' THEN 1 END) as booked,
       p.kuota - COUNT(CASE WHEN r.status != 'batal' THEN 1 END) as available
FROM kloters k
JOIN partner_packages p ON k.package_id = p.id
LEFT JOIN umroh_registrations r ON r.kloter_id = k.id
WHERE k.status = 'active'
GROUP BY k.id;

📋 Expected Output

Selamat Pagi Fernando! ☀️

📊 Booking Summary (24h)
• Baru: 2 | Dihubungi: 1 | Jadi Jamaah: 3 | Batal: 0

✈️ Active Kloters
• A1 (14 Apr): 28/40 seat (12 tersisa)
• B3 (21 Apr): 35/35 seat ⚠️ FULL
• C2 (28 Apr): 12/45 seat (33 tersisa)

3. Document Checklist for Kloter

PHASE 1

Prompt

Cek kelengkapan dokumen jamaah untuk kloter [KODE_KLOTER]. Query dok_* fields, list jamaah dengan dokumen yang belum lengkap. Format: per kloter, per jamaah, apa yang kurang.

SQL Query

SELECT j.nama, j.no_hp,
       CASE WHEN j.dok_vaksin IS NULL THEN '❌ Vaksin' ELSE '✅ Vaksin' END as vaksin,
       CASE WHEN j.dok_paspor IS NULL THEN '❌ Paspor' ELSE '✅ Paspor' END as paspor,
       CASE WHEN j.dok_foto IS NULL THEN '❌ Foto' ELSE '✅ Foto' END as foto,
       CASE WHEN j.dok_ktp IS NULL THEN '❌ KTP' ELSE '✅ KTP' END as ktp
FROM jamaah j
JOIN umroh_registrations r ON j.id = r.jamaah_id
JOIN kloters k ON r.kloter_id = k.id
WHERE k.kode = '[KODE_KLOTER]'
  AND r.status != 'batal'
HAVING vaksin LIKE '❌%' OR paspor LIKE '❌%' OR foto LIKE '❌%' OR ktp LIKE '❌%';

📋 Expected Output

📋 Dokumen Kloter B3 — 3 jamaah belum lengkap:

1. Ahmad Fauzi (0812xxx) — ❌ Vaksin, ❌ Paspor
2. Siti Rahma (0813xxx) — ❌ Foto
3. Budi Santoso (0815xxx) — ❌ KTP

4. Generate Itinerary for Kloter

PHASE 2

Prompt

Generate itinerary untuk kloter [KODE_KLOTER]. Query data kloter, package, dan itinerary_templates dari DB. Format: day-by-day schedule, waktu sholat, lokasi, hotel, catatan penting. Output sebagai HTML yang bisa di-share ke jamaah.

SQL Query

SELECT k.kode, p.name as package, p.durasi_hari,
       k.tanggal_berangkatan, k.tanggal_pulang,
       h.nama as hotel, h.alamat as hotelAlamat
FROM kloters k
JOIN partner_packages p ON k.package_id = p.id
LEFT JOIN hotels h ON k.hotel_id = h.id
WHERE k.kode = '[KODE_KLOTER]';

-- Template hari
SELECT * FROM itinerary_templates
WHERE package_id = (SELECT package_id FROM kloters WHERE kode = '[KODE_KLOTER]')
ORDER BY hari_ke;

📋 Expected Output

📄 Itinerary Kloter B3 — Umroh 12 Hari
File saved: itinerary-B3-14Apr2026.html
Telegram: Preview + link to download

5. Follow-Up Leads Status Baru

PHASE 2

Prompt

Cek leads umroh yang perlu dihubungi: 1. Status 'baru' + first_contact_at NULL → generate draft pesan perkenalan 2. Status 'dihubungi' + last_contact_at > 3 hari → generate follow-up Kirim ke admin Telegram dengan nama, no_hp, package info.

SQL Query

-- Leads baru, belum dihubungi
SELECT j.nama, j.no_hp, p.name as package, r.created_at
FROM umroh_registrations r
JOIN jamaah j ON r.jamaah_id = j.id
JOIN partner_packages p ON r.package_id = p.id
WHERE r.status = 'baru' AND r.first_contact_at IS NULL
ORDER BY r.created_at ASC;

-- Perlu follow-up (3+ hari)
SELECT j.nama, j.no_hp, p.name as package, r.last_contact_at
FROM umroh_registrations r
JOIN jamaah j ON r.jamaah_id = j.id
JOIN partner_packages p ON r.package_id = p.id
WHERE r.status = 'dihubungi'
  AND r.last_contact_at < NOW() - INTERVAL 3 DAY;

6. Weekly Content Calendar

PHASE 3

Prompt

Generate content calendar untuk minggu [TANGGAL_MINGGU]. Berdasarkan: - Kloter yang berangkat minggu ini - Event Islami mendatang - Testimoni jamaah terakhir - Tips perjalanan ibadah Output: 7 hari × 2 konten (pagi + sore), lengkap dengan caption + hashtag + waktu posting.

📋 Expected Output

📅 Content Calendar — Minggu 14-20 Apr 2026

🟢 Senin: Testimoni jamaah (pagi), Tips dokumen (sore)
🔵 Selasa: Countdown B3 (pagi), Manasik reminder (sore)
🟣 Rabu: Hotel showcase (pagi), Doa perjalanan (sore)
...dst

7. Customer H-7 Reminder Draft

PHASE 3

Prompt

Draft H-7 reminder untuk jamaah kloter [KODE_KLOTER]. Include: - Tanggal keberangkatan - Meeting point & waktu - Dokumen yang harus dibawa - Checklist barang bawaan - Nomor darurat - Doa perjalanan Bahasa: friendly, ramah, tapi informatif.

📋 Expected Output

📱 Draft untuk admin review:

"Assalamualaikum Bapak/Ibu, 🕌

InsyaAllah 7 hari lagi kita berangkat umroh!

📅 Berangkat: 14 April 2026, pukul 20:00
📍 Meeting Point: Terminal 3, Soekarno-Hatta

📋 Yang harus dibawa:
• Paspor + visa
• Bukti vaksin
• Uang saku
• ...

📞 Hubungi admin: 0812-xxxx-xxxx
Selamat bersiap! Semoga menjadi h yang mabrur 🤲"

8. Monthly Performance Report

PHASE 3

Prompt

Generate monthly performance report untuk [BULAN] [TAHUN]. Include: - Total registrations (new vs last month) - Revenue estimate (harga_jual × count) - Kloter completion rate - Document readiness rate - Vendor performance summary - Content metrics (if available) - Recommendations for next month

SQL Query

-- Monthly registrations
SELECT status, COUNT(*) as cnt
FROM umroh_registrations
WHERE MONTH(created_at) = [BULAN]
  AND YEAR(created_at) = [TAHUN]
GROUP BY status;

-- Revenue estimate
SELECT k.kode, p.name, p.harga_jual,
       COUNT(r.id) as pax,
       p.harga_jual * COUNT(r.id) as estimated_revenue
FROM kloters k
JOIN partner_packages p ON k.package_id = p.id
LEFT JOIN umroh_registrations r ON r.kloter_id = k.id AND r.status != 'batal'
WHERE MONTH(k.tanggal_berangkatan) = [BULAN]
GROUP BY k.id;

📋 Expected Output

📊 Monthly Report — April 2026

📈 Registrasi: 45 (↑12% dari Maret)
💰 Revenue Est: Rp 850,000,000
✈️ Kloter selesai: 2/3 (67%)
📋 Doc ready: 88% (40/45 jamaah)
⭐ Hotel avg rating: 4.2/5
💡 Rekomendasi: Fokus promosi kloter C2 yang masih banyak slot

6. KPI Dashboard

Target metrics per phase

5-8

Jam/Minggu

Phase 1 — Quick Wins

12-15

Jam/Minggu

Phase 2 — Core Automation

20-25

Jam/Minggu

Phase 3 — Intelligent

40+

Jam/Minggu

Phase 4 — Full Integration

10x

Response Time

From hours → minutes

Content Output

15 → 45+ posts/month

95%

Doc Readiness

Before departure target

+20%

Revenue Impact

Through better follow-up

7. Risk Register

Identified risks and mitigation strategies

#	Risk	Probabilitas	Impact	Mitigation	Owner
1	DB connection failure (SSH tunnel down)	MEDIUM	HIGH	Fallback to manual query via VPS 200 SSH. Auto-reconnect script.	Fernando
2	AI generates wrong information	HIGH	HIGH	Human review mandatory for all customer-facing content. Never auto-send without approval.	Fernando
3	Telegram rate limit	LOW	MEDIUM	Use batching for bulk messages. Respect 30 msg/sec limit.	Hermes
4	Staff resistance to AI tools	MEDIUM	MEDIUM	Start with quick wins (Phase 1). Demonstrate value before pushing automation.	Fernando
5	Data privacy breach	LOW	HIGH	Never expose credentials. API keys in .env only. SSH tunnel encrypted.	Fernando
6	API breaking changes (Laravel upgrade)	LOW	MEDIUM	Version pinning (v1 prefix). Test suite before production deploy.	Fernando

8. Resources Needed

Investment breakdown — mostly sweat equity

Item	Cost	Priority	Status
Hermes v0.17.0 (VM-1-102)	Free	P0	✅ DONE
Telegram Bot	Free	P0	✅ DONE
SSH Tunnel to VPS 200	Free	P0	✅ DONE
REST API on VPS 200	Free (dev time: 3-4h)	P1	TODO
Fonnte WA Gateway	~50k/bulan	P2	TODO
Additional Hermes profile (Marketing)	Free	P2	TODO
Hosting dashboard (static)	Free (can use VPS)	P2	TODO

9. Timeline — 12 Week Gantt

Visual overview of all phases and tasks

Task	W1	W2	W3	W4	W5	W6	W7	W8	W9	W10	W11	W12
Phase 1 — Quick Wins	1-2	3-4
1.1 Content Drafting Bot	●
1.2 Daily Booking Summary	●
1.3 Doc Checklist Monitor	●
1.4 Weekly Financial Snapshot		●

Phase 2 — Core Automation			5-6	7-8
2.1 Build REST API Bridge			●
2.2 Itinerary Auto-Generator			●
2.3 Auto-Reply FAQ Bot				●
2.4 Lead Follow-Up Scheduler				●

Phase 3 — Intelligent					9-10	11-12	13-14	15-16
3.1 Communication Pipeline					●	●
3.2 Post-Trip Feedback						●	●
3.3 Content Calendar							●
3.4 Vendor Tracker								●

Phase 4 — Full Integration									17-18	19-20	21-22	23-24
4.1 Multi-Agent Setup									●	●
4.2 Real-Time Dashboard										●	●
4.3 WhatsApp Blast											●	●