Automated Pet Vendor Order Tracking
Every morning, WebRun opens the Vendor Orders sheet in Google Sheets, compares expected delivery dates to today, flags any purchase orders that are past due, drafts a follow-up email to the supplier in Gmail for your review, and posts a late-delivery alert to Slack so the right person can chase it.
How do I automatically track and flag late vendor deliveries for my pet store?
Every morning, WebRun scans your Vendor Orders Google Sheet for purchase orders past their expected delivery date, drafts a polite follow-up email to each late supplier in Gmail, and posts a ranked late-delivery alert to Slack. Supplier emails are held for staff review so you control the tone and timing of every chase.
- Late deliveries are flagged daily before they cause empty shelves
- Draft supplier follow-ups are ready in Gmail after a single click to review
- The most overdue orders surface first so staff chase the biggest risks first
Built for pet store owners · purchasing managers · store operations staff
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 POs for late deliveries
google.com
WebRun opens Google Sheets to check POs for late deliveries. - Open the Vendor Orders sheet and scan each row for purchase orders whose expected delivery date has passed
- Capture vendor name, PO number, items ordered, expected date, and days overdue for each late order
- Skip any PO already marked as Received or Cancelled
Done when Every overdue PO is listed with the vendor, items, and days late.
-
2
Gmail - draft a follow-up to the late supplier
gmail.com
WebRun opens Gmail to draft a follow-up to the late supplier. - Draft a polite follow-up email to each supplier whose delivery is late
- Reference the PO number, items, and original expected delivery date
- Save each draft without sending so staff can review the tone and details before it goes out
Done when A draft follow-up email is saved in Gmail for each late supplier.
-
3
Slack - post a late-delivery alert to staff
slack.com
WebRun opens Slack to post a late-delivery alert to staff. - Post a late-delivery alert to the store channel listing each overdue PO with vendor and days late
- Note that follow-up drafts are waiting in Gmail for review
- Flag the most overdue orders at the top so staff prioritize the most urgent chases
Done when Staff have a Slack alert with all overdue POs and a pointer to the Gmail drafts.
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 email suppliers automatically when a delivery is late?
No. WebRun drafts a follow-up email in Gmail for each late supplier and alerts staff in Slack, but nothing is sent until a team member reviews the message and sends it manually.
How does it know which POs are late?
It reads the expected delivery date from each row in your Vendor Orders Google Sheet and compares it to today's date. Keep the sheet updated with new POs and WebRun will track them automatically from the next morning run.
What if a delivery arrived but the sheet was not updated?
Mark the PO row as Received in Google Sheets and WebRun will skip it on all future runs. It only flags rows that are still in an open or pending status, so a quick sheet update clears the alert.
Related templates
Shopify›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.