My Works | Romar Villamor

My Works

Real-world automation systems and CRM setups that drive business growth and efficiency.

★ Flagship Project Metal Pro Buildings

Enterprise Sales Pipeline
Automation System

Metal Pro Buildings manufactures steel structures — Quonset huts, CFS framing, and I-Beam buildings — and runs a high-volume sales operation where pipeline integrity is critical. Leads move through multiple stages, get assigned to reps, expire ownership windows, get recycled, or escalate. Managing that manually at scale means deals fall through cracks. This system eliminates that entirely.

10 Automation Groups
20+ Workflows
0 Manual Pipeline Errors
2 Sub-Projects
GoHighLevel n8n

Sales Core Pipeline Automation

The pipeline had a fundamental problem: at the volume Metal Pro Buildings operates, manual stage management meant reps missed transitions, ownership periods expired without action, and recycled leads would re-enter without proper cleanup. The system built here automates every stage entry, enforces ownership timers, handles rep-to-rep ownership requests, recycles stale leads, guards against data integrity drift, and pushes internal Discord alerts — all without manual intervention. 10 automation groups, 20+ workflows, fully stage-triggered.

GHL automations that fire the moment an opportunity moves into each pipeline stage — triggering the right sequences, setting timers, and routing contacts without manual touch.

Opportunity Moved → New Lead New Lead
Stage Attempting To Contact Attempting To Contact
Stage Discovery Discovery
Stage Pending Quote Pending Quote
Stage Decision Decision
Stage Lost Lost
Stage Won Won

n8n workflows that track how long each rep owns a lead, expire ownership after a defined period, reset timers on activity, and log touchpoints — enforcing accountability without a manager babysitting the pipeline.

Ownership Period Logger Ownership Period Logger
Ownership Period Expired Ownership Period Expired
Ownership & Cooldown Reset Ownership & Cooldown Reset
Cooldown Period Tracker Cooldown Period Tracker
Touchpoint Reset Touchpoint Reset

The hand-off mechanic: a rep can formally claim a lead currently in Discovery stage. These n8n + GHL workflows validate the request, approve the transfer, update GHL records, and notify the new owner — structured so the process leaves a clean audit trail.

Request Ownership From Discovery (n8n) Request Ownership — n8n
Request Ownership TRIGGER (GHL) Request Ownership — TRIGGER (GHL)
Request Ownership Action (GHL) Request Ownership — Action (GHL)

GHL automations that redistribute stale or expired leads to the next available rep and track follower assignment — preventing leads from sitting idle when ownership expires.

Recycle Lead Assignment Recycle Lead Assignment
Assign Follower (RB) — MAIN WF Assign Follower (RB) — MAIN WF

n8n guard workflows that prevent bad data from propagating: block accidental Lost-stage reversals, detect duplicate open opportunities, and watch for custom field changes that signal deal drift — catching problems before they corrupt pipeline reporting.

Revert From Lost To Previous Revert From Lost To Previous
Existing Deal Checker Existing Deal Checker
Opportunity Custom Fields Changed Opportunity Fields Changed

n8n workflows that push real-time internal alerts to Discord: escalation flags, re-assignment notifications, ownership request updates, and a hard stop for leads aged past 12 months that should not be recycled.

DC Internal Notification — Sales Core Pipeline Internal Notification — Pipeline
Lead Flagged for Escalation / Re-Assignment Lead Flagged — Escalation
Request Ownership Discord Notifier Request Ownership — Notifier
Do Not Recycle — Exceeded 12 Months Do Not Recycle — 12 Months
Node.js ⚙ Custom Built Tool

GHL CSV Cleaner

GHL exports raw CSVs with unformatted or broken phone numbers. Re-importing these files is often critical during disaster recovery, bulk contact migrations, or opportunity rebuilds. However, the malformed numbers trigger import failures and silent data loss. To avoid manually fixing thousands of rows, a custom Node.js sanitization script was built to process GHL exports and normalize every phone number field to a clean, importable format. The result: zero-error re-imports on every run. These 10 screenshots walk through the full tool workflow in sequence.

Other Automation Systems

03
Church Automation GHL · Google Sheets

Technical Website's Automations For New Members

The Technical Ministry of Word of Hope Church features integrated automation workflows designed to streamline communication, data management, and follow-up processes for the team. These workflows ensure that every interaction is automatically processed and properly routed.

Key Automation Processes

📧
Contact Form Submission

When a new contact submits a form, the system automatically sends a confirmation email with a calendar booking form and logs all submitted information into Google Sheets.

📅
Meeting Bookings

If a contact books a meeting through the calendar form, both the contact and assigned user receive automated confirmation emails. A reminder email is sent one day before the scheduled meeting.

📋
Survey Responses

When a user completes a survey form, the system sends automated emails with survey responses. If/else action logic is used to analyze choices and determine the next automated step.

GoHighLevel Google Sheets Email Automation Calendar Integration Conditional Logic
View Live Project
04
Business Automation GHL · n8n · AI Chatbot

VEM Technologies' Automation Workflows For AI and Forms

The VEM Technologies website is equipped with intelligent automation workflows designed to enhance lead management and customer communication. These workflows ensure seamless coordination between form submissions, appointments, and follow-ups — minimizing manual work while improving client engagement.

Key Automation Processes

🎯
Contact Form Submission

When a contact submits a form, their information is automatically added to the Opportunities pipeline in GHL, recorded in Google Sheets with their concern, and triggers an automated thank-you email.

📆
Appointment Booking

Contacts who book through the calendar are moved to the Appointment Booked stage. The system sends confirmation emails to both the contact and assigned user, plus reminder emails one day before the appointment.

🔄
Lead Nurturing

Contacts who haven't booked or responded are automatically added to a nurture workflow, receiving promotional emails every 7 days to maintain engagement and encourage future contact.

🤖
AI Chatbot Workflow

A custom-built AI chatbot powered by n8n and hosted on Render serves as a virtual front desk — answering questions about services, guiding visitors, and assisting with business information in real time.

GoHighLevel n8n Google Sheets AI Chatbot Pipeline Management Render Email Sequences
View Live Project

Let's Build Your Next Automation System

Have a project in mind? Let's discuss how smart automation can transform your business operations.