Automated Auto Detailing Supply Reorder Alerts
Every morning, WebRun checks your supply inventory tracked in Google Sheets against the reorder thresholds you set, identifies any product below the threshold, drafts a purchase order email to your supplier via Gmail, queues it for your review, and posts a low-stock alert to Slack.
How do I automatically track auto detailing supply stock and draft reorder purchase orders?
WebRun checks your Google Sheets supply inventory every morning against your reorder thresholds, then cross-references upcoming jobs in Mobile Tech RX to flag anything needed urgently. It drafts a purchase order email via Gmail for each supplier with low-stock items and posts a prioritised low-stock alert to Slack, all queued for your approval before any order is placed.
- Low stock is caught each morning before it causes a job delay
- Upcoming high-consumption jobs trigger priority reorder flags automatically
- Multiple supplier POs are drafted in separate emails for easy individual review
Built for auto detailing shops · ceramic coating studios · mobile detailers · car care businesses
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
docs.google.com/spreadsheetsin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - check inventory against thresholds
google.com
WebRun opens Google Sheets to check inventory against thresholds. - Open your detailing supplies inventory spreadsheet in Google Sheets
- Compare current stock levels against the minimum reorder threshold for each product
- Identify all products at or below the reorder threshold
- Note the product name, current quantity, reorder quantity, and preferred supplier for each flagged item
Done when All products at or below reorder threshold are listed with quantities and supplier details.
-
2
Mobile Tech RX - cross-reference usage from recent jobs
mobiletechrx.com
WebRun opens Mobile Tech RX to cross-reference usage from recent jobs. - Open Mobile Tech RX and review upcoming jobs for the next 7 days
- Identify any high-consumption services (full paint correction, ceramic coating) that will deplete specific supplies faster than normal
- Add a priority flag to any product needed for an upcoming job within 3 days
Done when Upcoming usage has been checked and urgent priority flags added to any product needed for imminent jobs.
-
3
Gmail - draft reorder PO for review
gmail.com
WebRun opens Gmail to draft reorder PO for review. - Draft a purchase order email for each supplier with flagged low-stock items
- Include product name, SKU or product code, reorder quantity, and any urgency note for priority items
- Save as a Gmail draft for your review before sending
- Never send a PO automatically without human approval
Done when Reorder PO drafts are saved in Gmail for every supplier with low-stock items.
-
4
Slack - post low-stock alert to team
slack.com
WebRun opens Slack to post low-stock alert to team. - Post a low-stock alert to your team or owner channel
- List each product below threshold with current quantity, reorder quantity, and urgency level
- Flag any product needed within 3 days for immediate action
Done when Team has a low-stock alert in Slack with urgency levels and PO drafts ready for review.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Will it place orders with suppliers automatically?
No. Every purchase order is drafted and saved in Gmail for your review. Nothing is sent to a supplier until you approve and send it manually.
How does it know what the reorder thresholds are?
You set the minimum quantity and reorder amount for each product in your Google Sheets inventory tracker. WebRun reads those values each morning and flags anything at or below the threshold.
Can it handle multiple suppliers for different products?
Yes. It groups low-stock items by supplier and drafts a separate PO email for each one, so you can review and send each order independently.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.