Roadside & Recovery
Paste the Web App URL from your deployed Google Apps Script below to sync job data to Google Sheets. Leave blank to keep using local browser storage only.
Signed in
Enter your dispatcher or driver login to access the Tow Job Log.
Create a login for a dispatcher or driver. Requires the admin password set in your Apps Script.
Fill in job details — the member's out-of-pocket cost is calculated automatically based on membership tier.
Pick a category below to generate a report or view its history.
Straight from AAA's own survey export — % of surveys each month where AAA's "Overall Satisfaction" question was answered "Totally Satisfied", same figure and formula as AAA's own dashboard.
What AAA's Quality Incentive Program (standard) and PSP Alternative Quality Incentive Program would pay, based on your rolling Overall Satisfaction average and AAA-billed call volume in Tow Log for that same window. Estimate only — Tow Log has no way to check the 93% Net Acceptance Rate eligibility gate or flag half-rate (GOA/NSP) calls, and the PSP Alternative program only applies if you're currently enrolled as a Preferred Service Provider. Confirm actual payout with AAA.
Same figure and formula as above, split out per dispatcher — each survey is matched by its Job ID to the job it belongs to in Tow Log, and counted under whoever dispatched that job. A survey whose Job ID isn't found in Tow Log is skipped here (it's still counted in the fleet-wide table above).
AAA's own "Service Provider Satisfaction" question — how satisfied the customer was with the driver specifically — split out per driver, straight from the driver name on each survey (no Job ID lookup needed, so every survey with a driver name on it is counted here).
Every survey where AAA's "Overall Satisfaction" question was answered something other than "Totally Satisfied" — Job ID included so you can pull up the job directly in Tow Log to follow up.
One row per phone number with any message activity, matched to the most recent job for that number. Double-click a row to open that job and its conversation together — the job opens read-only in the New Job form above until you click Edit there.
Quick access to text any driver directly.
Sent and received via your Android phone through SMS Gateway — the API key stays server-side, never exposed here.
Log a payment adjustment requested from AAA. The amount is added to that job's AAA Paid total — the member's Out-of-Pocket is not affected. Use Accepted / Declined to track AAA's response once it comes in.
Every job logged with Call Type "RAP" shows up here as Pending until it's confirmed. Mark it Accepted once AAA approves it — the job's Out-of-Pocket moves to $0, Payment Method locks to AAA, and the full amount is added to the AAA Paid bucket. Mark it Declined to leave it billed to the member as usual.
Upload a CSV or Excel file of jobs (or paste CSV text directly) — each row runs through the exact same calculation engine as the regular form (job total, out-of-pocket, AAA pays, etc. are all computed, not just copied). Download the template first if you're not sure of the expected columns. Required columns: Job ID, Work Order Date, Dispatcher, Driver, Call Type.
Upload or paste a list of Job IDs — optionally with Membership and/or AAA Pay columns too, straight from AAA's own records — and this checks each one against Tow Log. Nothing is imported or changed; this is read-only. A Job ID that was deleted from Tow Log is shown as "Deleted" rather than "Missing".
Upload or paste an AAA survey export — the same file AAA sends you — and every survey row is stored here (Service Call ID, dates, driver, all four satisfaction questions, ATA, clearing code, resolution, and comments). Re-importing an export that overlaps with what's already stored is safe: each survey is matched by its Service Call ID, so nothing gets double-counted, and a re-imported row just refreshes what's on file for it.
How Out-of-Pocket and Cash Call money actually came in, broken down by Payment Method. AAA/Agero-covered amounts aren't included — those aren't transactions collected from a customer. A split payment counts as two separate transactions, one per method.
Enter how much cash was actually handed over for each job — pre-filled with the full amount owed, but editable if a driver only settles part of it. Leave a field at 0 to skip that job.
| Job ID | Driver | Cash in Hand | Amount Received Now |
|---|