All templates

Automated Collision Estimate Intake

When a customer submits an estimate request, WebRun logs the vehicle, damage description, and contact details in Google Sheets, opens CCC ONE to create the estimate record, and pings the estimator in Slack so no request falls through the cracks.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
On form submit WebRunorchestrates each step
1 CCC ONE create the estimate record
2 Google Sheets log request details
3 Slack alert the estimator
In short

How do I automatically log and route collision estimate requests?

WebRun captures every collision estimate request the moment it arrives. It creates the estimate record in CCC ONE, logs the vehicle and damage details in Google Sheets, and pings your estimator in Slack, so your team always has a full intake trail and no request sits unnoticed.

  • Every estimate request is logged in CCC ONE and Google Sheets within seconds of submission
  • Estimators are alerted in Slack before a request can go cold
  • No estimate request is lost or missed after hours

Built for auto body shops · collision repair centers · independent body shops · dealership body shops

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens my.cccone.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    CCC ONE - create the estimate record
    cccis.com
    WebRun in CCC ONE: create the estimate record
    WebRun opens CCC ONE to create the estimate record.
    • Open CCC ONE and navigate to the Estimates section
    • Create a new estimate record with the customer name, vehicle year, make, model, and VIN if provided
    • Enter the reported damage description and preferred drop-off date
    • Save the record and note the estimate number

    Done when The estimate record exists in CCC ONE with all submitted details.

  3. 2
    Google Sheets - log request details
    google.com
    WebRun in Google Sheets: log request details
    WebRun opens Google Sheets to log request details.
    • Open the Estimate Intake log in Google Sheets
    • Append a new row with the customer name, phone, vehicle, damage notes, preferred date, and CCC ONE estimate number
    • Mark the status column as New

    Done when The request is logged as a new row in the intake sheet.

  4. 3
    Slack - alert the estimator
    slack.com
    WebRun in Slack: alert the estimator
    WebRun opens Slack to alert the estimator.
    • Post a message to the estimator channel with the customer name, vehicle, and CCC ONE estimate number
    • Include the preferred drop-off date and a link to the intake sheet row
    • Tag the on-duty estimator

    Done when The estimator has been alerted in Slack with the full request summary.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
my.cccone.com
ScheduleRuns automatically on this cadence
On form submit
DeliveryHow each run's result reaches you
Intake log · Google Sheets · Slack
OutputWhat each run produces - A logged intake row in Google Sheets and a Slack alert to the estimator with the CCC ONE estimate number.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it contact the customer automatically?

No. WebRun only logs the request internally and alerts your estimator in Slack. Any reply to the customer is drafted for your team to review and send, so no message goes out without a human check.

What if a request comes in after hours?

WebRun runs on every form submission around the clock, so the record lands in CCC ONE and Google Sheets immediately. Your team sees the Slack alert the moment they are back online.

Can it handle requests from multiple channels like phone or walk-in?

Yes. Your team can trigger the same intake flow manually for phone or walk-in requests, and WebRun will log and alert the same way as an online submission.

Keep going

Related templates

Automated Auto Body AR Report
Every morning, WebRun cross-references open repair invoices in CCC ONE with QuickBooks, builds an aging AR worklist sorted by carrier and days outstanding, and posts it to Slack so your team knows exactly who to call.
CCC ONE›QuickBooks›Slack
Automated CSI Survey Triage
After delivery, WebRun drafts a CSI survey text via Twilio and queues it for approval. When responses land in Google Sheets, it flags low scores in Slack so your team can follow up before frustration becomes a review.
Google Sheets›Slack›Twilio
Automated Auto Body Cycle-Time Report
Every morning, WebRun pulls repair data from CCC ONE, calculates cycle time and WIP counts, logs the numbers in Google Sheets, and posts a daily digest to Slack so managers can act before delays compound.
CCC ONE›Google Sheets›Slack

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.

Deploy this workflow Talk to us