All templates

Automated Car Wash Chemical Reorder

Every morning, WebRun opens your chemical inventory Google Sheet, finds any product at or below its reorder threshold, drafts a supplier reorder email in Gmail with the right quantities, and posts a Slack alert with the low-stock list and the draft email so your team can approve and send the order.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Google Sheets check inventory levels
2 Gmail draft reorder email
3 Slack alert team for approval
In short

How do I automatically reorder car wash chemicals before running out?

WebRun checks your Google Sheets chemical inventory every morning and flags any product at or below its reorder threshold. It drafts a consolidated supplier reorder email in Gmail for each flagged item and posts a low-stock alert to Slack so your team can review the drafts and send the order before any product runs out.

  • Low-stock chemicals are caught every morning before they cause a service interruption
  • Draft supplier emails are ready for one-click approval in Gmail
  • Multi-supplier orders are consolidated into one email per vendor

Built for car wash operators · site managers · purchasing teams

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

  2. 1
    Google Sheets - check inventory levels
    google.com
    WebRun in Google Sheets: check inventory levels
    WebRun opens Google Sheets to check inventory levels.
    • Open the chemical inventory Google Sheet and scan the current quantity column
    • Flag any row where the current quantity is at or below the reorder threshold
    • Capture the chemical name, current quantity, reorder quantity, and preferred supplier for each flagged item

    Done when Every chemical below its reorder threshold is listed with quantity and supplier details.

  3. 2
    Gmail - draft reorder email
    gmail.com
    WebRun in Gmail: draft reorder email
    WebRun opens Gmail to draft reorder email.
    • Draft a reorder email to the appropriate supplier for each flagged chemical
    • Include the product name, SKU if available, and the reorder quantity
    • Leave every email as a draft in Gmail, unsent, for a team member to review before sending

    Done when A draft reorder email exists in Gmail for each low-stock chemical, ready for review.

  4. 3
    Slack - alert team for approval
    slack.com
    WebRun in Slack: alert team for approval
    WebRun opens Slack to alert team for approval.
    • Post a low-stock alert to the Slack ops channel listing every flagged chemical
    • Show the current quantity, reorder quantity, and supplier for each item
    • Note that Gmail draft emails are ready and link to the Gmail drafts folder for quick access

    Done when Your team has the low-stock list and a Gmail draft link in Slack for same-day approval.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
sheets.google.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Low-stock alert · Slack
OutputWhat each run produces - A Slack alert listing low-stock chemicals with quantities and suppliers, plus Gmail draft reorder emails ready for team approval and sending.
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 send reorder emails to suppliers automatically?

No. Every reorder email is drafted in Gmail and left unsent. WebRun posts a Slack alert with the low-stock list and a link to the drafts so a team member can review and send each order.

How do I set reorder thresholds for each chemical?

Add a reorder threshold column to your Google Sheet, one per chemical. WebRun reads that value each morning and flags any product at or below the threshold, so thresholds are easy to adjust without changing any settings.

Can it handle chemicals from multiple suppliers?

Yes. WebRun groups chemicals by supplier and drafts one consolidated email per supplier, so you are not sending a separate email for every single product line.

Put this on autopilot.

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