AMHAC ST Platform · status

Leads

Takes sales leads from the Parts App, matches them to ServiceTitan customers, assigns them to an engineer and emails everyone involved.

• okParts App → Leads API (sales leads in) · live, 3434 lead(s) on file
• okLead housekeeping · no run recorded here

Tables

5 · 25,625 rows

Routes

/v1/leads-api, /admin/leads

Settings

leads.*

Commands

st leads

Runbook

70-leads-api.md

Reports

Builds and emails scheduled reports from the data layer; each report is a definition (Daily Invoice & Payment Report, Weekly Callback Meeting Report; more queue up here) on one shared clock, send ledger and watchdog.

• okReports (email) · 3 report(s) registered, nothing overdue
• okReport: Daily Invoice & Payment Report · last run 1 h 53 min ago · 2026-11-11: 46 invoices (+1 late); time on job 31 -> sent to ['service@amhac.com', 'accounting@amhac.com', 'demetrius@amhac.com', 'jordan@amhac.com', 'bill@amhac.com', 'santiago@amhac.com', 'adam@amhac.com']; marked 46; via scheduler
• okReport: Weekly Callback Meeting Report · last run 18 h 23 min ago · github: not due on a Wednesday (Thu 2:00 PM ET)

Tables

2 · 1,073 rows

Routes

/admin/report, /admin/reports

Settings

reports.*, invoice_report.*

Commands

st report

Runbook

65-reports.md, 60-invoice-report.md, 66-bonus-report.md

Sources

Captures data from outside ServiceTitan: OnCall Air proposal events and sold proposals by webhook, Azuga trucks and trips by API, webhook and import, Google reviews by API, ServiceTitan report rows by the Reporting API.

• okOnCall Air (proposal events) · receiving, last event just now
• okOnCall Air (sold proposals) · receiving, last sale 3 min ago
• okAzuga GPS (trucks and trips) · live, last trip event just now
• okGoogle reviews (the AMHAC listing) · 1,564 reviews, refreshed 15 h 25 min ago
• okAzuga vehicles and trips · last run 15 h 36 min ago · 2591 complete, 4 open of 2595

Tables

7 · 20,132 rows

Routes

/webhooks/oncallair, /webhooks/azuga

Settings

none

Commands

st azuga, st oca, st google, st reporting

Runbook

25-oncallair.md, 30-azuga.md, 66-bonus-report.md

Wells Fargo claims

Emails accounting within the hour when Wells Fargo funds a Carrier Infinity or Performance sale, so the dealer claim is filed inside its 30-day window.

• okWells Fargo claim alerts · last run 26 min ago · 0 claim alert(s), 0 without a proposal, 0 not qualifying

Tables

1 · 2 rows

Routes

/admin/wf-claims

Settings

wf_claims.*

Commands

st wf-claims

Runbook

67-wells-fargo-claims.md

Truck attribution

Works out which technician drove which truck on each day and matches trips to job stops, with a confidence band, using geocoded addresses.

• okUS Census geocoder (addresses to coordinates) · 2,843 addresses cached, 87% matched
• okGeocoder (US Census) · last run 15 h 26 min ago · pending 0, match 0, tie 0, no_match 0, unparseable 0, error 0
• okTruck attribution (who drove what) · last run 15 h 26 min ago · 3 days; {'default_confirmed': 39, 'swap_detected': 4, 'excluded': 9, 'no_jobs': 4, 'ambiguous': 5, 'default_assumed': 4}

Tables

4 · 16,150 rows

Routes

none

Settings

none

Commands

st attribution, st geocode

Runbook

40-attribution.md

Prospects

Builds and keeps the register of Westchester light-commercial parcels from public records, the data set behind HVAC prospecting and real-estate acquisition.

• okProspects refresh · last run 16 days ago · 1,254 of 9,498 parcels matched to 2,051 ServiceTitan locations; active 468, lapsed 545, never 8,485; 0 new links, 0 retired

Tables

8 · 32,889 rows

Routes

/v1/prospects-api

Settings

prospects.*

Commands

st prospects

Runbook

95-prospects.md, 96-prospects-api.md, 97-prospects-roadmap.md

Claude connector

Lets Claude answer questions about the business through fixed tools and read-only SQL over the serving views, with every question logged.

• okClaude connector (MCP) · 133 questions in the last 7 days

Tables

1 · 572 rows

Routes

/mcp, /oauth

Settings

none

Commands

none

Runbook

20-incidents.md

Platform services

Shared plumbing the other applications use: email in and out through Resend, owner settings, the job-run log, customer identity matching and the shadow record of ServiceTitan writes.

• okResend (email replies and delivery receipts in) · receiving, last event 9 min ago
• okEmail out (Resend) · 246 email(s) sent in the last 30 days
• okServiceTitan writes (shadow only) · 82 recorded, 0 executed (read-only phase)
• okPlatform-data backup · no run recorded here
• okFreshness check · no run recorded here

Tables

8 · 2,747 rows

Routes

/webhooks/resend, /admin/email, /admin/platform

Settings

none

Commands

st email, st settings

Runbook

50-email.md, 80-status-window.md

ServiceTitan (API mirror)

Read-only pulls from the ServiceTitan API, every 4 hours and nightly

Resources mirrored

85

Last sync

26 min ago (Thu 11/12 08:26 AM ET)

Last run

ok · 106 rows · 9 API calls

Errored resources

none

Behind schedule

none

OnCall Air (proposal events)

Event-subscription webhook into this service; captured raw, one row per event

Events captured

1,895

Last received

just now (Thu 11/12 08:53 AM ET)

Last 30 days

viewed 1132, emailed 199, followup 145, presented 137, created 98, assigned 69, reverted 66, accepted 31, expired 14, blocked 2, unaccepted 2

OnCall Air (sold proposals)

The Sold Proposals webhook: the accepted option, its money and products, linked to a lead when one matches; the Parts App reads sales from here

Sold proposals captured

26

Last received

3 min ago (Thu 11/12 08:50 AM ET)

Linked to a platform lead

23

Lead match waiting on a person

0

Azuga GPS (trucks and trips)

Vehicle list from the Azuga API on the sync schedule; trips live from webhooks, history from a one-time report import

Trucks

24 (list refreshed 15 h 36 min ago)

Live events

5,270, last just now

Trips

11,298 total · live 2,595 · imported 8,703

Trip history

2026-07-19 to 2026-11-11

Trips in progress

4

API key on the sync runner

not visible from this service

Google reviews (the AMHAC listing)

Pulled nightly by the sync workflow through the Business Profile API, read only; the bonus report credits 5-star reviews to the crew of the visit before them

Reviews on file

1,564 (1,502 five-star)

Last 30 days

14 (14 five-star)

Newest review

20 h 52 min ago

Last pull

ok 15 h 25 min ago · 1564 reviews

Credentials

GitHub Actions secrets only; nothing on this service

US Census geocoder (addresses to coordinates)

Free batch geocoder; results cached forever so each address is looked up once

Addresses cached

2,843

Matched

2,469 (87%)

No match or tie

374

Parts App → Leads API (sales leads in)

The Parts App submits, assigns and updates leads over /v1/leads-api with a bearer token; Mitsubishi accepted-lead emails forwarded to leads@mail.amhac.com become leads by themselves

Leads on file

3434

By status

IMPORTED 3199, ASSIGNED 112, ST_JOB_CREATED 92, PROPOSAL_SOLD 22, REJECTED 5, SUBMITTED 3, NEEDS_CORRECTION 1

Last submitted

9 min ago (Thu 11/12 08:44 AM ET)

Open customer matches

0

Mitsubishi emails

6 seen: 5 lead(s) created, 1 duplicate(s), 0 needing attention; last lead 2 days ago

API requests logged

159

Resend (email replies and delivery receipts in)

Resend posts delivery events and inbound replies to leads@mail.amhac.com into this service

Delivery events

1,461, last 9 min ago

Replies received

87, last 13 min ago

Replies matched to a sent email

81

Replies still without a body

0

Claude connector (MCP)

Claude signs in with Supabase OAuth and asks questions through fixed tools and read-only SQL over the serving views

Questions, last 7 days

133 (4 errors, 1 caller(s))

Questions, last 30 days

571

Last question

40 min ago

Most used tools (30 days)

run_query 388, find_customer 39, schema 37, get_invoice 32, get_job 23

Reports (email)

The Reports sub-application: each report is a definition on the data layer; one shared clock, send ledger and watchdog

Daily Invoice & Payment Report

weekdays 7:00 AM ET · last sent for 2026-11-11 (Thu 11/12 07:00 AM ET, scheduler) · next due Fri 11/13 07:00 AM ET · to service@amhac.com, accounting@amhac.com, demetrius@amhac.com, jordan@amhac.com, bill@amhac.com, santiago@amhac.com, adam@amhac.com

Weekly Callback Meeting Report

Thu 2:00 PM ET · last sent for 2026-11-04 (Thu 11/05 02:00 PM ET, scheduler) · next due Thu 11/12 02:00 PM ET · to jordan@amhac.com, service@amhac.com, demetrius@amhac.com

Weekly Bonus Events Report

Tue 4:00 PM ET · last sent for 2026-11-09 (Tue 11/10 08:09 AM ET, skipped by hand: sent-by-hand-at-7:55-ET-to-accounting-and-jordan) · next due Tue 11/17 04:00 PM ET · to accounting@amhac.com

Email out (Resend)

Lead assignment and status emails, the invoice report and test sends, all logged before they go

Sent, last 30 days

246 · bonus_report 6, invoice_report 20, lead_assigned 82, lead_assigned_copy 23, lead_assigned_preview 4, lead_rejected 5, lead_reminder 8, lead_reply_help 4, lead_returned 3, lead_submitted 83, one_off 1, test 1, weekly_callback_report 5, wf_claim 1

Failed / bounced

0 / 0

ServiceTitan writes (shadow only)

Intended ServiceTitan changes (e.g. a sales estimate job per assigned lead) are recorded, never sent: the platform is read-only against ServiceTitan

Recorded

create_sales_estimate_job shadow/cancelled 6, create_sales_estimate_job shadow/proposed 76