All templates

Automated Coating Material Reordering

Every Monday, WebRun opens CoatingOS, reads the week's booked coating jobs, works out how much flake, base resin, and topcoat they will use, compares that to your stock sheet in Google Sheets, and drafts a supplier reorder email for anything below par.

Runs on WebRun · Strict Lockdown policy
Every Monday at 7:00 AM WebRunorchestrates each step
1 CoatingOS read upcoming jobs
2 Google Sheets check stock against par
3 Gmail draft the reorder email
In short

How do I reorder coating materials before a job run runs me short?

WebRun keeps your coating supplies stocked. Every Monday it reads the week's booked jobs in CoatingOS, estimates the flake, resin, and topcoat they will use, compares that to your Google Sheets stock, and drafts a supplier reorder email in Gmail for anything below par, left unsent so you approve every order.

  • No crew shows up to a job short on flake or resin
  • Reorders reflect the real jobs booked, not a guess
  • You approve every supplier order before it is sent

Built for garage floor coating contractors · epoxy installers · polyaspartic coating companies · coating shop managers

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 app.coatingos.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    CoatingOS - read upcoming jobs
    coatingos.com
    WebRun in CoatingOS: read upcoming jobs
    WebRun opens CoatingOS to read the week's booked jobs.
    • Open CoatingOS and list installs booked for the coming week
    • Read each job's square footage and coating system
    • Estimate the flake, base resin, and topcoat each job will consume

    Done when Projected material usage for the week's jobs is totalled by product.

  3. 2
    Google Sheets - check stock against par
    google.com
    WebRun in Google Sheets: check stock against par
    WebRun opens Google Sheets to compare stock against par levels.
    • Open your materials stock sheet in Google Sheets
    • Subtract projected usage from current on-hand quantities per product
    • Flag any flake color, resin, or topcoat that falls below its par level

    Done when Every product below par is flagged with the shortfall quantity.

  4. 3
    Gmail - draft the reorder email
    gmail.com
    WebRun in Gmail: draft the reorder email
    WebRun drafts a supplier reorder email and leaves it for your review.
    • Draft a reorder email to your coating supplier listing each low product and the quantity to order
    • Group the order by supplier so each vendor gets one clean request
    • Leave every reorder email unsent in Gmail for you to review and send

    Done when A reorder email per supplier waits in your Gmail drafts, none sent automatically.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.coatingos.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Reorder list · Gmail drafts
OutputWhat each run produces - A list of low coating materials with shortfall quantities, plus a drafted reorder email per supplier waiting in Gmail.
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 place orders with my supplier automatically?

No. WebRun drafts the reorder email and leaves it unsent in Gmail. You check the quantities and send it yourself, so no order is placed without your approval.

How does it know how much material a job needs?

It reads each booked job's square footage and coating system in CoatingOS and estimates flake, resin, and topcoat usage from that, so the reorder reflects real upcoming work.

Can it order the right flake colors?

Yes. It tracks stock per product in your Google Sheet, including individual flake blends, so a color running low is flagged by name in the draft.

Put this on autopilot.

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