Automated Shopify Draft Order Follow-Up Tracker
Every morning, WebRun opens Shopify, finds all draft orders that have been open for more than 48 hours without conversion, captures the customer and order details, and logs them to a Google Sheet so your team has a prioritized follow-up list to work through each day.
Shopify
find open draft orders past the follow-up threshold
How do I automatically track and follow up on open Shopify draft orders?
WebRun opens Shopify every morning and finds all draft orders that have been open without payment for more than 48 hours. It logs each one to a Google Sheet ranked by value, with colour-coded urgency for older drafts. Your sales team works the list each day and converted or cancelled drafts are cleared automatically on the next run.
- No draft order sits forgotten for days because no one checked the admin
- Sales team gets a value-ranked list every morning so the biggest opportunities are worked first
- Converted and cancelled drafts cleared automatically so the tracker stays accurate
Built for Shopify store owners · B2B retailers on Shopify · retail sales teams · omnichannel store operators
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
admin.shopify.com/draft_ordersin a real browser with your saved login - no setup, no API keys. -
1
Shopify - find open draft orders past the follow-up threshold
WebRun opens Shopify to find open draft orders past the follow-up threshold. - Open Shopify Admin and navigate to Orders, then Drafts
- Filter to draft orders with status Open that were created more than 48 hours ago
- Capture the draft order number, customer name, email or phone, total value, and how many hours it has been open
- Sort by highest value first so the most valuable opportunities are at the top of the list
Done when All draft orders open for more than 48 hours are listed with customer details and value.
-
2
Google Sheets - log the follow-up worklist
google.com
WebRun opens Google Sheets to log the follow-up worklist. - Open the Draft Order Follow-Up tracker sheet
- Append a new row for each qualifying draft order with order number, customer, value, and hours open
- Mark draft orders over 72 hours in orange and over 5 days in red to indicate escalating urgency
- Remove rows for drafts that have since converted or been cancelled
Done when The follow-up tracker is updated and the team can see exactly which drafts need attention today.
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.
Shopify
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Will it send a follow-up message to the customer automatically?
No. WebRun only logs the draft orders to a Google Sheet for your sales team to action. Any outreach to the customer is made by your team after reviewing the worklist.
What is a Shopify draft order?
A draft order is an order your team created manually in Shopify Admin, often for a phone or in-store quote, a custom order, or a B2B sale. It stays as a draft until the customer pays or it is cancelled.
Does it clear converted drafts from the list?
Yes. On each morning run, WebRun checks which previously flagged drafts have since converted to paid orders or been cancelled in Shopify and removes them so the tracker only shows open opportunities.
Related templates
Shopify›Shopify›Shopify›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.