Deployment Log: Chimcare

Workiz API
Bridge.

How we used Google Apps Script middleware to automate technician follow-ups and capture 35% more reviews without human intervention.

The Friction Point

Chimcare relies on Workiz to manage thousands of service calls across the Pacific Northwest. While excellent for scheduling, Workiz created a data silo.

Technicians would complete a job, but the "Review Request" process was manual. Techs often forgot to send the link, or sent it hours later when the customer's excitement had faded. This "Lead Leakage" meant hundreds of 5-star experiences were never captured online.

System Architecture

The Automation Bridge

1. Job Complete
Workiz Status Change
2. Webhook Listener
Google Apps Script
3. Trigger SMS
Twilio / Email API

The Engineering Fix

We didn't need to replace Workiz. We built a middleware layer using Google Apps Script. This script listens for the specific API payload `job_status: completed`, filters for high-value service types, and immediately triggers a personalized SMS sequence.

middleware/workiz_bridge.gs
function doPost(e) { // 1. Parse incoming Webhook from Workiz var data = JSON.parse(e.postData.contents); if (data.event_type === "job.status.completed") { // 2. Extract Customer Data var phone = data.payload.customer_phone; var techName = data.payload.tech_name; // 3. Trigger Review Sequence (Instant) sendReviewRequest(phone, techName); // 4. Log to BigQuery for Analysis logToBigQuery(data.payload); } return ContentService.createTextOutput("200 OK"); }
Impact Report

Quantitative Results

+35%
Review Velocity
0h
Manual Entry Time
100%
Customer Coverage

This entire system runs serverlessly on Google Cloud. No maintenance fees. No external SaaS subscriptions. Just code.

Request Similar Audit