$ cat ./problem-solving
Find the bottleneck. Build the system that removes it.
Beyond SEO, I build the plumbing: webhook pipelines, lead routing, portals, scrapers, and client websites. Here's what that looks like on a real problem.
FEATURED BUILDLead routing automation
The problem
Leads came in through BlinkVoice, but the client was collecting them manually, one by one - then hand-filtering which dealership each lead belonged to. Slow, error-prone, and it didn't scale.
What I built
A site connected to the BlinkVoice webhook: every incoming lead flows through SMS filtering and is auto-categorized into Google Sheets, tab by tab - one tab per dealership.
The result
Zero manual sorting. Leads land in the right dealership's tab the moment they arrive, and the team works from one always-current document.
Automation Workflow — BlinkVoice lead routing
One webhook fires. Everything else runs itself.
Lead arrives
BlinkVoice SMS
Webhook fires
per incoming lead
Parse & filter
read the SMS body
Match dealership
routing rules
Google Sheets
tab per dealership
no match? → drops to review
Logged
in the right tab, instantly
Review queue
unmatched, flagged for a human
Duplicate skipped
no double entries
⚡ BlinkVoice webhook✉ SMS filtering▤ Google Sheets API
Real proof, not a mockup
Same skill, other shapes
P
Employee portals & trackers
Time tracking, task boards, and internal portals - built on Next.js + Supabase, deployed on Vercel.
S
Scrapers & data pipelines
Inventory, listings, and competitor data pulled on schedule and delivered where the team already works.
W
Client & dealership websites
Fast, SEO-ready sites and landing pages built to capture leads - not just to look good.
I
API & email integrations
Webhooks, third-party APIs, transactional email with Resend, Google Cloud services - glued together so data moves itself.
Stack I build with
Claude CodeChatGPT / CodexVS CodeNext.jsSupabaseVercelResendGoogle CloudWebhooks & APIsCanva
Free tools & resources
Take something useful, even if you never hire me.
Practical, free tools built to support real SEO and reporting work - no signup required.
Free toolSchema generator
Fast structured-data helper for public pages and local SEO support work.
Free toolMeta tag generator
Useful for shaping title, description, and social metadata drafts before implementation.
Free toolSERP previewer
Quick preview tool to tighten title and description length before shipping revisions.
Got a manual process eating your team's hours?
Describe it in one message - I'll tell you if it's automatable, honestly.
© 2026 Jerome SEO Works · Built by Jerome Sabangan