Web App View
Live fleet ops — less phone tag, faster compliance handoffs
Internal real-time platform for trucking — IoT through NATS JetStream, fleet dashboards, FMCSA-oriented reporting, Keycloak, Postgres + Redis.
AWSIoTNext.js
Back to Portfolio 
Web App
X-Lead
Spreadsheet addon for bulk email verification with integrated lead management and HubSpot sync — lightweight UI in the sheet, API-backed checks, and an admin surface for operations.
Validation stages (syntax, MX, SMTP)
Surfaces — addon, API, landing, admin, CRM
CRM touchpoints (contacts + pipeline status)
- Verify email columns in bulk without exporting CSVs or switching tools
- API performs syntax, MX, and SMTP-oriented checks; heavy work runs off the UI thread via a queue
- HubSpot sync for contacts and pipeline status so verified leads land where sales already works
- Admin dashboard for usage, logs, and accounts — separate from the marketer’s spreadsheet flow
Next.jsGoogle Sheets APIHubSpot APITypeScriptTailwind CSS
Overview
X-Lead is a spreadsheet addon for teams that live in Google Sheets but still need trustworthy email data. Users select ranges or columns, run verification, and write results back into the grid — same file, same workflow, fewer copy-paste round trips to standalone tools.
Behind the addon sits a verification API and a queue-backed processing path so large batches do not time out in the browser or hit provider rate limits naively. A Next.js landing page covers acquisition and onboarding; an authenticated dashboard gives operators visibility into jobs, failures, and usage.
The product deliberately meets sales and growth teams where they work. Verified rows can sync into HubSpot as contacts with appropriate lifecycle or deal signals, so the spreadsheet remains the scratchpad while the CRM stays the system of record.
The Challenge
Email verification products usually assume a web app or API-only integration. Sheet users expect instant feedback for small jobs but also run multi-thousand-row lists — the system has to feel responsive while still being honest about async work and partial failures.
CRM sync adds another constraint: HubSpot objects and pipelines are easy to get wrong. Updates must be idempotent enough for re-runs, scoped to the right portal, and visible in admin logs when something misconfigures.
Our Solution
The addon talks to a dedicated verification API. Interactive checks can return quickly for small selections; bulk jobs are accepted as work items, processed by workers that implement syntax validation, MX lookup, and SMTP-oriented probing, then persist results for the sheet to poll or pull.
The Next.js app hosts the public landing (hero, product explanation, signup/install path) and the authenticated admin experience — metrics, job history, user-level usage, and integration health. Serverless or API routes handle auth boundaries and proxy sensitive operations.
HubSpot integration uses the official APIs to upsert contacts and map verification outcomes to properties or stages the team configures. The addon does not replace HubSpot; it feeds it from the sheet with clear audit trails in the admin panel.
Architecture
Frontend
- Google Sheets addon UI — bulk actions, progress, and per-row results in-grid
- Marketing landing (Next.js) — hero, product narrative, install / trial CTAs
- Authenticated dashboard — accounts, usage, logs, integration settings
Backend
- REST-style API for verification requests and job status
- Queue and workers for batch processing, retries, and rate-aware outbound checks
- Persistence for jobs, results, and audit data consumed by the admin app
Integrations
- Google Sheets API — sidebar UI, triggers, and writing results to cells
- HubSpot API — contacts, properties, and pipeline / status updates from verified rows
Key Features
- Bulk email verification from the spreadsheet UI — select a range, run checks, read results in place
- Fast, API-driven validation pipeline (syntax, MX records, SMTP-oriented probes as applicable)
- Lead workflow — track verification outcomes alongside your columns before pushing to CRM
- HubSpot integration for contacts and status / pipeline alignment after verification
- Admin panel for monitoring usage, logs, integrations, and user activity
- Next.js landing for marketing, pricing context, and onboarding
Screens
Addon in the spreadsheet
Bulk verification and per-row status without leaving the grid.
Landing page
Hero, product summary, and path to install or sign up.
Admin dashboard
Usage, job history, and user-level visibility for operations.
Data flow
Sheet addon
Verification API
Queue & workers
Results store
HubSpot CRM
Technical Highlights
- Next.js (TypeScript) for landing and dashboard; Tailwind for layout and component styling
- API routes / serverless handlers for auth, job submission, and webhook-style HubSpot callbacks where needed
- Addon uses Google Apps Script and the Sheets API for UI surfaces and cell writes; calls backend over HTTPS
- Worker tier decouples SMTP and DNS-heavy work from request/response latency
- HubSpot client implemented against current REST APIs; mapping layer keeps sheet columns and CRM properties explicit and testable
- Structured logging in admin for failed jobs, integration errors, and re-sync operations
Results
- Automated 3-stage validation that reduced bounce rates for early-adopter sales teams by an average of 22%.
Portfolio
More case studies
Explore additional work built with the same craft and attention to detail.
