John Rey Gavilaga
ls -la /workflows

Things I've built

Automations built two ways: client and personal projects under JanriTech Automations, and operational workflows built on the job to make SOC/NOC teams faster.

JanriTech client & personal projects

6 live
CASE-006
n8n · Gemini AI LIVE

Gated CV Download & AI Assistant

Feature automations behind this site

The CV download on this page and the chat widget in the corner both run on n8n workflows. Downloading the CV validates the visitor's email against a real DNS MX lookup before releasing the file, and notifies me by email. The chat assistant is grounded in my actual CV and portfolio data through the Gemini API, so it answers questions about my background accurately instead of generically.

CASE-005
Node.js · PostgreSQL · Socket.IO · OSRM LIVE

Hatod-Sugat Motorcycle-Taxi Platform

Three-portal ride platform for San Carlos City

Passenger, driver, and admin portals on one shared backend, built for a single local city rather than a national market. Map-based booking with real road routing through a self-hosted OSRM engine, live GPS tracking over Socket.IO during an active ride, and a driver-side digital wallet that deducts a per-kilometer commission automatically. Wallet cash-ins reuse the same bank-email payment verification pattern built for Brent & Blair below.

hatud-sugat.janritech.com →

CASE-004
Node.js · PostgreSQL · n8n LIVE

Brent & Blair POS + Anti-Fraud Ordering

Full-stack ordering, POS & payment verification

Complete ordering and point-of-sale system for a food stall business: live kitchen board, inventory control, staff roles, and digital receipts. The standout piece reads the business's own bank confirmation emails through n8n and matches them against customer-typed references before any order is accepted, blocking fake or unpaid orders without a commercial payment gateway.

brent-blair.janritech.com →

CASE-003
n8n · Claude · Telegram LIVE

PHIVolcs Monitoring

Public safety alert automation

Pulls official PHIVOLCS bulletins for Mayon, Kanlaon, and Taal, summarizes each with Claude, and routes every summary through a Telegram approval step before anything posts publicly — a deliberate human-in-the-loop for public safety information.

CASE-002
n8n · IT Glue LIVE

Travel Authorization Automation

Ticket-to-document pipeline

Triggered by a standard "Approved Travel" ticket, parses traveler/destination/client into structured fields, generates the authorization document, and files it directly into the correct client folder in IT Glue.

CASE-001
n8n · Claude · Meta API LIVE

JT Automations Facebook Engine

Daily content pipeline

Pulls local weather data, has Claude write copy, and renders it into a finished graphic, then posts automatically to the JT Automations Facebook page on a daily schedule, unattended.

Operational automations (SOC / NOC)

6 deployed
OPS-01
Power Automate DEPLOYED

NOC Follow-Up Reminder

SharePoint → Microsoft Teams

Runs every 12 hours, checks an Excel incident tracker in SharePoint for items flagged "Follow up," and posts a formatted reminder with incident details to the NOC team's Teams chat — keeping outstanding tickets visible without anyone checking a spreadsheet manually.

OPS-02
Power Automate DEPLOYED

Inbox Noise Filter

Shared mailbox → Microsoft Teams

Watches the NOC/SOC shared mailboxes for new mail, checks sender and subject against a whitelist (health-check reports, daily summaries, etc.), and only surfaces genuinely actionable emails to the team in Teams — cutting inbox noise at the source.

OPS-03
Power Automate DEPLOYED

Peer Recognition Bot

Excel → Microsoft Teams

Runs weekly, tallies peer-nomination votes from an Excel tracker, and posts a summary to Teams highlighting the top analysts for the team's BlueTeam Ally badge.

OPS-04
Power Automate DEPLOYED

PSIRT Advisory Notifier

Fortinet PSIRT → Microsoft Teams

Triggers on new Fortinet PSIRT advisory emails and immediately posts a formatted summary (sender, subject, preview) to Teams, so security advisories get reviewed the same day they're published.

OPS-05
Power Automate DEPLOYED

Shift Tools Check-In

Adaptive Card → Microsoft Teams

Posts a recurring adaptive card every 12 hours asking the on-shift analyst to confirm the midnight tools check. A click captures name and timestamp and posts confirmation back to the chat — simple accountability without a manual log.

OPS-06
n8n · Gemini AI DEPLOYED

Booking-to-Telegram Notifier

Gmail → Gemini AI → Telegram

Watches Gmail for Calendly booking or interview-invite emails, sends the content to Gemini AI for a concise summary, and delivers it to Telegram in real time with event type, attendee, date, and time.

Want something like this built for your own workflow? See what JanriTech offers