For a small cabinet shop, the best AI for ordering is the assistant that sits where your supplier emails already live: Gemini in Gmail, Copilot in Outlook, or ChatGPT or Claude with a pasted order sheet. Keep a lead-time tracker sheet as the source of truth, and let the AI draft the chasers and check acknowledgements.
In a cabinet shop an ordering mistake shows up as idle fitters, not as an error message: the board arrives on Monday and the hinges the following Thursday. No assistant knows your suppliers' real lead times, so the sheet comes first and the AI second. Design software is a separate question, covered in my tutorial on cabinet design software and what AI adds.
The tracker first: ten columns that carry the routine
One row per order line, not per order, because the hinges and the board travel separately and slip separately. Job references replace client names, which keeps personal data out of the sheet and out of every prompt you write later.
| Column | What goes in it | Why it earns its place |
|---|---|---|
| A: Job ref | K-214 | Links the line to a job without naming the client |
| B: Item | 18 mm birch ply, 14 sheets | Specific enough to check against an acknowledgement |
| C: Supplier | Board merchant | Lets you total slips by supplier later |
| D: Ordered | 26 Oct | Starts the clock on the quoted lead time |
| E: Promised | The supplier's latest confirmed date | The date you actually plan around |
| F: Need-by | The day it must be in the workshop | Turns a promise into a risk |
| G: Buffer | Need-by minus promised, in days | Negative means late before it even ships |
| H: Confirmed in writing | Yes or No | A phone promise is not a date |
| I: Last chased | Date and rung of the ladder | Stops double chasing and shows patterns |
| J: Next action | A formula, not a judgement | Tells you what to do this Monday |
Columns G and J are plain formulas, with no AI involved. They are the same in Excel and Google Sheets:
G2: =F2-E2
J2: =IF(H2<>"Yes","CHASE: no written confirmation",IF(G2<0,"ESCALATE: promised after need-by",IF(E2-TODAY()<=3,"CHECK DISPATCH","")))
Here is the tracker on a Monday, 2 November, for an invented shop running three kitchens at once, with the formula's answer in the last column:
| Job | Item | Supplier | Promised | Need-by | Buffer | Confirmed | Next action |
|---|---|---|---|---|---|---|---|
| K-214 | 18 mm birch ply, 14 sheets | Board merchant | 4 Nov | 9 Nov | 5 | Yes | CHECK DISPATCH |
| K-214 | Soft-close hinges and runners | Hardware distributor | 6 Nov | 9 Nov | 3 | No | CHASE |
| K-214 | 14 doors, sprayed finish | Door finisher | 6 Nov | 10 Nov | 4 | Yes | (blank) |
| K-217 | Quartz worktops, template and supply | Stone fabricator | 20 Nov | 23 Nov | 3 | Yes | (blank) |
| K-217 | Edge tape, 4 rolls | Board merchant | 5 Nov | 12 Nov | 7 | Yes | CHECK DISPATCH |
| K-219 | Handles, custom finish | Hardware distributor | 30 Nov | 25 Nov | -5 | Yes | ESCALATE |
| K-219 | 18 mm MDF, 20 sheets | Board merchant | 6 Nov | 16 Nov | 10 | No | CHASE |
| K-221 | Bin drawer inserts | Hardware distributor | 13 Nov | 23 Nov | 10 | Yes | (blank) |
Five of the eight lines need something today, and the one that matters most is the handles for K-219: the supplier has confirmed a date five days after the kitchen needs them. No chaser will fix that. It needs a phone call, an alternative finish or a conversation with the client, and the sheet found it three weeks early.
Which assistant sits where: a comparison for a six-person shop
| Option | Where it works | Good at | Limits to know | List cost (USD) |
|---|---|---|---|---|
| Gemini in Gmail | Inside Gmail ("Help me write" and the side panel) | Drafting a chaser in your own tone, summarising a long supplier thread | Works on one email at a time and does not see your sheet unless you paste lines in | Starts at Workspace Starter. List prices are about $7, $14 and $22 per user a month on annual terms for Starter, Standard and Plus, before any introductory discount |
| Copilot in Outlook | Inside Outlook | Drafting and summarising mail | Copilot Chat in Outlook can summarise and draft from your inbox and calendar without the paid licence; the licence adds wider grounding across your files and priority access. The buttons you see also depend on your Outlook version, so check your own account | Copilot Chat is included with Microsoft 365 business plans; the paid add-on is about $21 per user a month on an annual term |
| ChatGPT or Claude with a saved project | Browser or app, outside your mail | Batch work: five tracker lines in, five chasers out; checking acknowledgements | You paste in and copy out, so keep client names out of what you paste | About $20 a month each on individual plans (Claude Pro is $17 a month billed annually) |
| Gemini in Sheets or Copilot in Excel | Inside the tracker | Explaining a formula, adding a column, flagging lines | See the section below on what each can and cannot do | Gemini in Sheets needs Workspace Standard or above, or a Google AI plan; Copilot in Excel needs an eligible Microsoft 365 plan |
| No AI: mail rules | Gmail or Outlook | Scheduling sends, labelling replies from each supplier | No judgement at all | Free |
My rule is to use the assistant that lives where the email lives, then add ChatGPT or Claude for the batch jobs. A shop on Gmail gets "Help me write" on all three Business plans, and since May 2026 it can match the tone of your past emails, which suits short supplier notes. A shop on Outlook should try Copilot Chat first and see what appears. If you only ever send the Monday batch of five or six chasers, a ChatGPT or Claude project with your wording saved in it is simpler than either.
Connectors add one more option. Claude's Google Workspace connector can create Gmail drafts, and it can also send mail, so keep it on drafts only and press send yourself. The same applies to any assistant you connect to your inbox.
Tell suppliers how you will chase, before you need to
A chaser lands better when the supplier has been told it is coming. Send each regular supplier one short note, and keep their answers on a second tab of the sheet called Suppliers, with a row each: contact name and direct number, the cut-off time for next-day dispatch, delivery days, quoted lead time, and whether they confirm in writing. An assistant can draft the note from a few facts you supply. This is a version after editing:
Hello [first name], we are tightening how we track orders so nothing reaches our fitters late. From now on, could you confirm each order in writing with a delivery date per line? We will send a short check a few days before each promised date, and a note if anything looks late. Could you also tell us who to contact directly, and whether your cut-off for next-day dispatch is still [cut-off time]? Thanks, [your name]
Most suppliers welcome it, because it replaces irritated phone calls with predictable short emails. The tab then earns its keep in the prompts: paste a supplier's row alongside the flagged lines and the draft addresses the right person and respects the cut-off, instead of asking for same-day dispatch on an order placed at 4pm.
The chaser ladder: five emails written once
Chasing works when it is boring and consistent. Each rung has a trigger, and the formula in column J tells you which one applies:
| Rung | Trigger | What it asks for |
|---|---|---|
| 1: Confirm the order | No written confirmation within a day of ordering | Quantity, finish and a delivery date in writing |
| 2: Pre-ship check | About five working days before the promised date | Is it still on track, and is anything out of stock |
| 3: Dispatch check | Promised date within three days | A tracking reference or a delivery window |
| 4: Late, new date | The day after a missed date | A new confirmed date and the reason, by a stated time |
| 5: Escalate | Buffer is negative, or three days late | A call today, plus what you will do if the date cannot move |
Paste only the flagged lines into the assistant with a standing prompt:
You draft short supplier emails for a six-person cabinet workshop.
Below are the tracker lines flagged today, each with its action.
For each line write one email: a subject line, then a body of 70 words or fewer.
Rules: use the job reference, never a client's name. Always ask for a confirmed date in writing. Be polite and specific. Do not threaten, blame, or mention other suppliers.
For ESCALATE lines, say we need the item in the workshop by the need-by date and ask them to ring me today. Do not offer payment terms or accept part deliveries.
Tracker lines:
[paste only the flagged lines]
For the hinges on K-214, a sample draft reads:
Subject: K-214 hinges and runners: please confirm delivery date
Hello [first name], we ordered soft-close hinges and runners for job K-214 on 26 October and have not had a written confirmation. Could you confirm quantities and a delivery date by reply today? We need them in the workshop by 9 November, so I would like to know now if that is at risk. Thanks, [your name]
The board order for K-214 is on the dispatch-check rung, and the handles on K-219 sit on the top rung. Two more drafts show how the tone changes between them:
Subject: K-214 18 mm birch ply: dispatch check
Hello [first name], our order for job K-214 (14 sheets of 18 mm birch ply) is promised for 4 November. Could you send the dispatch time or a tracking reference? Thanks, [your name]
Subject: K-219 handles: need a call today
Hello [first name], the custom-finish handles for job K-219 are now confirmed for 30 November, but we need them in the workshop by 25 November. Could you ring me today on [your number] to talk through what is possible? If the date cannot move, I need to know today so I can plan around it. Thanks, [your name]
Across the batch, two faults crept in. The first run of the handles escalation said "as we discussed on Friday", which never happened, and it offered to accept a part delivery, which is my decision. Both are now ruled out in the prompt, and I still read every email before it goes. The tone is the other thing to watch. Assistants drift towards either grovelling or sharpness, and a supplier you need next month deserves neither.
Check every acknowledgement against the order
Acknowledgements are where quiet errors live: a different thickness, a changed finish code, a delivery date a day later than promised. People skim them. An assistant will compare line by line without getting bored:
Compare my order with the supplier's acknowledgement below.
List every difference in quantity, size, thickness, finish code, price and delivery date. Write "no difference" for lines that match.
Convert units before comparing (2440 x 1220 mm and 2.44 x 1.22 m are the same size). If the acknowledgement uses a different product code, flag it instead of assuming it is equivalent.
My order:
1. 18 mm birch ply, 2440 x 1220 mm, BB/BB, 14 sheets
2. 18 mm MDF, 2440 x 1220 mm, 20 sheets
3. 2 mm ABS edge tape, white W-100, 4 rolls
Promised: Wednesday 4 November
Acknowledgement:
1. 15 mm birch ply, 2440 x 1220 mm, BB/BB, 14 sheets
2. 18 mm MDF, 2.44 x 1.22 m, 20 sheets
3. 1 mm ABS edge tape, white W-100, 4 rolls
Delivery: Thursday 5 November
A correct result: line 1 is flagged because the ply is 15 mm, not 18 mm; line 2 is "no difference" once units are converted; line 3 is flagged because the tape is 1 mm, not 2 mm; and the delivery date is a day later than promised, with the buffer still four days. Without the instruction to convert units, an earlier run flagged line 2 as a size mismatch, which is the kind of false alarm that teaches people to ignore the tool. Two genuine errors caught before dispatch is a good Monday: 14 sheets cut at the wrong thickness is a week of rework.
Turn vague replies into dates you can act on
Suppliers reply in shorthand. An assistant can turn a reply into fields for the sheet, provided you make it show its working:
Read the supplier's reply below. My email was sent on Thursday 5 November.
For each item give: item, delivery date as a full date, whether the date is firm, probable or vague, and the exact words you used.
If the reply gives a week rather than a day, use the last working day of that week. If anything is ambiguous, say so instead of guessing.
Reply: "Hinges will be with you w/c 9th, runners are on back order, probably end of next week. Cheers"
The output I would accept: hinges, 13 November (last working day of the week commencing 9 November), firm for the week but not the day; runners, 13 November, probable, because "end of next week" from a Thursday email points to Friday 13 November, and "probably" carries the doubt. A weaker draft got it wrong in two places: an earlier version entered 9 November for the hinges, treating "w/c" as a delivery day, and recorded the runners as firm. Entering the latest day of a window and "Confirmed: No" for anything probable keeps the sheet honest.
Follow that reply through the tracker. The hinges for K-214 were promised for 6 November with a buffer of 3 days. A new date of 13 November against a need-by of 9 November gives a buffer of minus 4, and column J flips to ESCALATE. The chasing stage is over and the re-source rule further down applies, which is exactly the kind of consequence a skimmed email hides.
A 15-minute Monday and a supplier scorecard
The routine is short: filter column J for anything non-blank, paste those lines into the chaser prompt, read and edit each draft, schedule the sends for the morning, and update column I. Gmail can hold up to 100 scheduled emails, so a Monday batch goes out at 8am without you being at the desk.
Once a quarter, add an outcome column (On time, Late) and total it by supplier. The formula for one supplier, with the supplier in column C and the outcome in column K:
=COUNTIFS(C:C,"Hardware distributor",K:K,"On time")/COUNTIF(C:C,"Hardware distributor")
After twelve weeks the scorecard might read:
| Supplier | Lines | On time | Share on time | Average slip when late |
|---|---|---|---|---|
| Board merchant | 20 | 17 | 85% | 1 day |
| Door finisher | 7 | 6 | 86% | 2 days |
| Stone fabricator | 5 | 3 | 60% | 4 days |
| Hardware distributor | 16 | 9 | 56% | 3 days |
The numbers change how you plan. If the hardware distributor quotes seven days and is late in nearly half of lines by three days, plan on ten, and order hinges the day a job is confirmed rather than when the carcasses are built. For more on tracking prices, lead times and supplier risk generally, read AI supplier management.
When a date will not move: a re-source rule
Some chasers end with the same answer: the date is not going to change. Decide in advance what you will do, and write the rule on the sheet's front page. Mine would read: if the buffer is negative by more than two days and a stock alternative can arrive in time for no more than 10% extra, switch; otherwise tell the client the same day.
Apply it to the K-219 handles. The custom finish costs $420 and arrives five days after the kitchen needs it. A stock handle in a similar finish costs $460 and arrives in two days. The extra is $40, about 10%, so the rule says switch. If the alternative cost $600, the extra would be 43%, so the rule says keep the order, price a return visit to fit the handles (two fitters for two hours at $35 an hour is $140, plus travel) and warn the client. The assistant can draft the client message and the cancellation note to the supplier. The decision stays with you, and so does checking the cancellation terms first, because a custom-finish order is often not cancellable once it is in production.
What a late delivery costs, as a quick sum
Hinges arrive on Thursday instead of Monday. Two fitters lose a day each, or are sent to another job and have to come back. At $35 an hour (an assumption, so use your own rate), that is 2 x 8 x $35 = $560 of labour, before the client call nobody enjoys. The Monday routine takes 15 minutes, or about 13 hours a year, which is roughly $455 of the owner's time at the same rate. One avoided idle day pays for a year of the routine, and the scorecard makes the avoidable days visible.
Using Copilot or Gemini inside the sheet itself
Both suites have an assistant that works in the spreadsheet, and both are best used for the dull parts. In Excel, the Copilot side pane has modes called Allow editing (the default), Plan and Chat only. Choose Chat only while you are learning, so it explains without changing anything. Excel's =COPILOT() worksheet function was retired on 14 September 2026, so any template that relies on it needs rebuilding with ordinary formulas. In Google Sheets, the AI function needs an eligible Workspace or Google AI plan, fills 350 cells at a time, cannot be nested and does not refresh on its own.
A sensible use: ask either assistant to add a column that flags lines where the supplier's average slip from the scorecard tab would push delivery past the need-by date. Then verify the result on three rows by hand, because a formula that looks right and is wrong in one supplier's row is worse than no formula. My tutorial on Google Sheets AI prompts has more to try.
Keep drafts as drafts, and customers out of them
Two habits protect the shop. First, use job references in every prompt and email, and keep the key to client names in a separate sheet. Check which plan you are on: business plans of the main assistants do not train on your content by default, while consumer plans have a model-training switch in their privacy settings. Second, let the AI draft and let a person send. A chaser that goes to a supplier without being read can promise things you did not agree to, and the supplier will remember.
When a sheet stops being enough
A tracker works well for a shop with a few kitchens in progress. It starts to creak when several people edit it at once, when you need to receive stock against orders, or when invoices need matching to purchase orders. At that point look at cabinet shop software that handles quotes, cut lists and orders together, which I compare in cabinet shop software for quotes, cut lists and orders. If your drawings already produce a cutting list, the step from list to material order is covered in building a cutting list and material order from a drawing. The sheet you built here still earns its keep, because the columns and the chaser ladder move straight into whatever system replaces it.
Ordering questions cabinet makers ask
Can AI read supplier replies and update the tracker by itself?
Not safely without supervision. Supplier replies are vague, with phrases like 'w/c the 9th' or 'probably end of next week', and an automatic update will pick one reading and move on. The reliable version is to paste the reply into an assistant, check the date it extracts, and enter it yourself. Automate only once the extraction rules are written down and a person reviews every exception.
Should a chaser email mention the client's name?
No. The supplier needs the job reference, the item, the quantity and the need-by date. A client's name and address add nothing to the chase and put personal data into a supplier's inbox and into whichever AI tool drafted the email. Keep a private key that links job references to clients, and use only the reference in prompts and emails.
What if a supplier ignores every chaser?
Switch channel and date it. After the escalation email goes unanswered for a working day, ring and note the name of the person you spoke to in the Notes column. If the buffer is already negative, price a second source on the same day rather than waiting. The scorecard will show whether this is a one-off or a pattern worth acting on.
Further reads
- How to Automate Purchase Orders and Supplier Emails With AI — Draft the purchase orders and supplier emails themselves with AI.
- How to Compare Supplier Quotes Side by Side With AI — Compare board and hardware quotes before you place the order.
- How to Match Supplier Invoices to Purchase Orders Automatically — Match supplier invoices to your orders once goods arrive.
- Hardware Store POS Systems: Which Features Matter and Where AI Fits — A feature checklist for an independent hardware store POS: SKU depth, trade accounts, special orders and reorders, plus what AI really does in each.
- Countertop Fabricator Software: Templating, Slabs and Where AI Helps — A vendor question list for templating, slab layout, quotes and cut files, with a scorecard, a yield sum and where ChatGPT helps with quote wording.
- Cabinet Maker AI: Answer Showroom Enquiries and Book Site Measures — Triage lanes, an enquiry form, a rules sheet, a booking page and reminder texts for a cabinet maker, with a worked month of 56 enquiries and what it costs.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: Claude and Google Workspace pricing pages (checked October 2026); Microsoft Learn overview of Copilot Chat (updated October 2026); Gmail help on scheduling emails; vendor documentation on Gemini in Gmail and Sheets and on Copilot in Excel.