Case Study #1: Record Contamination Case Study #2: Dashboard Intelligence Case Study #3: Zapier Elimination Case Study #4: PestRoutes Discovery Case Study #5: Jobber Bridge
AGM Pro Tools — Case Study

How We Replaced Zapier and Fixed 176 Customer Records in One Session

Heavenly Greens — Salesforce & AGM Integration Overhaul

176
Contacts Fixed
4
Zapier Zaps Replaced
1
Session
$0
Downtime

The Client

Heavenly Greens is a leading artificial turf installation company serving the San Francisco Bay Area. They operate across multiple sales channels including direct residential, commercial, and a strategic partnership with Costco through Shaw Industries. Their technology stack spans Salesforce (CRM), AGM/GoHighLevel (marketing automation & pipeline management), and multiple third-party integrations including DocuSign, Invoca, and QuickBooks.

27
Active Users in SF
22
SF Dashboards
42
Zapier Automations
221
AGM Workflows

The Problem

Customer-Facing Documents Had Wrong Names

A completed installation verification form — signed by the customer — showed the member name as "Jeff Guevara-Costco-Front Yard" instead of simply "Jeff Guevara." The project descriptor was leaking into the customer's actual name on legally binding documents.

This wasn't an isolated incident. The contamination was systemic — affecting every customer whose job progressed through certain pipeline stages. The wrong names were appearing on contracts, completion forms, review requests, and internal communications.

The business impact was immediate: unprofessional customer-facing documents, inaccurate CRM data, and broken automation workflows that depended on clean contact names.

The Investigation

AGM Pro Tools conducted a real-time triage session, tracing the data contamination from the signed document back through every system in the stack.

Traced the contamination path

Followed the mangled name from the completion form → AGM contact record → Zapier automation → Salesforce Opportunity fields. Identified that Zapier was overwriting AGM contact names on every pipeline stage change.

Found the root cause: a dead integration field

The Zapier Zaps were mapping a field called "Broadly Business Name" to the AGM contact's Full Name. Broadly — a review management platform — had been cancelled months ago, but its custom fields and automation were never cleaned up in Salesforce. The field happened to contain clean names for some contacts, but for others, HG's team had edited it to include project descriptors.

Discovered Broadly was still firing outbound messages

Queried the Salesforce API directly and found that while Broadly's custom fields had been removed, a workflow rule and outbound message on the Opportunity object were still active — sending data to a dead endpoint on every job completion. A ghost integration consuming resources and introducing risk.

Identified broken review automation

The review request workflow existed in AGM and was correctly built, but it was never firing. The trigger chain — Salesforce marks a job complete → Zapier syncs to AGM → AGM review workflow fires — was broken because Zapier was using the wrong field mapping. Customers were completing jobs and never receiving review requests.

Confirmed the Salesforce object limitation

Investigated why the original Zapier builder used "Broadly Business Name" in the first place. The Salesforce Opportunity (Job) object has no separate First Name / Last Name fields. The builder needed a clean name source, couldn't find one on the Job record, and used the Broadly field as a workaround. It worked until Broadly was removed.

The Audit

Before building any replacement, AGM Pro Tools conducted a complete Salesforce system audit — mapping every automation, trigger, email alert, and integration to ensure nothing would be disrupted during the fix.

50
Workflow Rules
21
Email Alerts
38
Apex Triggers
14
Installed Packages
57
Email Templates
25
Pipeline Stages

The audit was compiled into a comprehensive reference document — every workflow rule categorized by object, every email alert mapped to its trigger, every installed package assessed for active vs. legacy status. This document now serves as the foundation for the full Zapier deprecation roadmap.

Additional Findings

  • Broadly outbound message still active on cancelled subscription
  • HubSpot integration package installed (v2.60) — status unknown, possibly legacy
  • No review automation firing despite workflow being correctly built in AGM
  • Salesforce "Company to Full Name" workflow rule on Lead object — separate naming concern
  • 42 Zapier Zaps active — many redundant or using outdated field mappings

The Solution

1. Built an Enterprise-Grade Replacement

Rather than fixing the Zapier field mapping (which would have been a band-aid on a fundamentally flawed approach), AGM Pro Tools built a purpose-built integration endpoint on Modal that replaces all four Salesforce → AGM Zapier Zaps.

Architecture: SF → AGM Stage Sync

ComponentPurpose
SF SOAP/REST APIPolls for Opportunity stage changes every 5 minutes
Contact matching (email → phone fallback)Finds existing AGM contact without relying on name fields
Pipeline stage move via AGM APIMoves opportunity to correct stage in Lead Flow pipeline
SQLite event trackingDeduplication — never processes the same stage change twice
Safety checksNo backwards pipeline movement, no duplicate workflow triggers
Retry logic with capsFailed updates retry up to 3 times, then dead-letter with alert
Slack alertsReal-time notification on every failure, throttled per contact
Health endpointCanary monitoring for uptime verification
Heartbeat trackingPersistent state on Modal Volume for operational visibility

2. Cleaned 176 Contaminated Contact Records

Built and executed a programmatic cleanup that stripped project descriptors from every affected AGM contact name. The script handled 30+ contamination patterns including compound variants (-costco-back yard, -front and side yard-pavers, -back yard-cancelled) and edge cases like hyphenated surnames (Garcia-Mendoza, Evoy-Mount).

176
Contacts Cleaned
0
Errors
30+
Pattern Variants
100%
Audit Logged

3. Restored the Review Request Chain

By replacing the Zapier bridge with a clean integration that properly moves pipeline stages, the existing AGM review workflow now fires correctly when production marks a job as "Completed - Paid" in Salesforce. The review request chain — which had been silently broken — is now operational.

4. Deployed with Zero Downtime

The Modal endpoint was deployed alongside the existing Costco lead intake cron, sharing the same isolated infrastructure (secrets, volumes, monitoring). The old Zapier Zaps were paused only after the replacement was validated against live data. At no point was any business workflow interrupted.

The Value

Traditional Approach

$11K – $24K+
68–100 hours across 4-5 vendors over 3-6 weeks
Salesforce Admin15-20 hrs$3,000-5,000
Zapier Specialist10-15 hrs$1,500-2,600
GHL Developer8-12 hrs$1,000-2,400
Integration Engineer20-30 hrs$3,500-9,000
Data Cleanup5-8 hrs$625-1,600
Project Manager10-15 hrs$1,500-3,750
  • No single vendor sees the full picture
  • No deduplication or safety checks
  • No real-time monitoring or alerting
  • No audit trail
  • 3-6 week timeline

AGM Pro Tools

1 Session
Diagnosed, built, tested, deployed, and validated — same day
Full SF system auditComplete
Full AGM deep diveComplete
Integration replacementDeployed
Data cleanup (176 records)Executed
8-phase migration roadmapDelivered
Review chain restorationLive
  • Full-stack visibility (SF + AGM + Zapier)
  • SQLite dedup — never process same event twice
  • Real-time Slack alerts on every failure
  • Complete audit trail with JSON logs
  • Same-day delivery
No single vendor would have found the dead Broadly outbound message, the broken review chain, and the name contamination in the same engagement — because no single vendor operates across Salesforce, AGM, and Zapier simultaneously. AGM Pro Tools does.

What the Replacement Does That Zapier Can't

CapabilityZapierAGM Pro Tools
Deduplication (never process same event twice)NoSQLite event tracking
Safety checks (prevent duplicate customer messages)NoStage position validation
No backwards pipeline movementNoStage order enforcement
Retry failed updates with capsNo3-attempt cap + dead letter
Real-time failure alertingNoSlack alerts per failure type
Alert throttling (no flood)NoPer-contact dedup
Health endpoint for monitoringNo/health on Modal
Audit trailNoFull SQLite history
Contact matching by email/phone (not name)Uses name fieldsEmail primary, phone fallback
Client isolationShared accountSeparate Modal app + secrets

Results

4
Zapier Zaps Eliminated
176
Records Corrected
0
Downtime
GREEN
System Health

Immediate Outcomes

  • Customer-facing documents now display correct names
  • Review request automation restored — customers now receive review requests after job completion
  • 176 historically contaminated contact records cleaned to proper names
  • Dead Broadly integration identified for deactivation
  • Complete Salesforce system audit documented for ongoing reference
  • 8-phase Zapier deprecation roadmap established (42 Zaps → 0)
  • Enterprise-grade monitoring, alerting, and audit trail in place

About AGM Pro Tools

AGM Pro Tools is an enterprise integration platform for field service businesses. We connect your FSM, CRM, and sales automation systems with self-healing pipelines, real-time monitoring, and the operational intelligence to find and fix problems before they affect your customers.

We don't just connect systems. We understand what's happening inside them.

Book a Free Strategy Call