Best AI for Cabinet Making: Supplier Orders, Lead Times and Chasers

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Best AI for Cabinet Making: Supplier Orders, Lead Times and Chasers.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Best AI for Cabinet Making: Supplier Orders, Lead Times and Chasers.

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.

Follow me on Instagram@sagnikteaches

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.

Connect on LinkedInSagnik Bhattacharya
ColumnWhat goes in itWhy it earns its place
A: Job refK-214Links the line to a job without naming the client
B: Item18 mm birch ply, 14 sheetsSpecific enough to check against an acknowledgement
C: SupplierBoard merchantLets you total slips by supplier later
D: Ordered26 OctStarts the clock on the quoted lead time
E: PromisedThe supplier's latest confirmed dateThe date you actually plan around
F: Need-byThe day it must be in the workshopTurns a promise into a risk
G: BufferNeed-by minus promised, in daysNegative means late before it even ships
H: Confirmed in writingYes or NoA phone promise is not a date
I: Last chasedDate and rung of the ladderStops double chasing and shows patterns
J: Next actionA formula, not a judgementTells 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:

Subscribe on YouTube@sagnikteaches
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:

JobItemSupplierPromisedNeed-byBufferConfirmedNext action
K-21418 mm birch ply, 14 sheetsBoard merchant4 Nov9 Nov5YesCHECK DISPATCH
K-214Soft-close hinges and runnersHardware distributor6 Nov9 Nov3NoCHASE
K-21414 doors, sprayed finishDoor finisher6 Nov10 Nov4Yes(blank)
K-217Quartz worktops, template and supplyStone fabricator20 Nov23 Nov3Yes(blank)
K-217Edge tape, 4 rollsBoard merchant5 Nov12 Nov7YesCHECK DISPATCH
K-219Handles, custom finishHardware distributor30 Nov25 Nov-5YesESCALATE
K-21918 mm MDF, 20 sheetsBoard merchant6 Nov16 Nov10NoCHASE
K-221Bin drawer insertsHardware distributor13 Nov23 Nov10Yes(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

OptionWhere it worksGood atLimits to knowList cost (USD)
Gemini in GmailInside Gmail ("Help me write" and the side panel)Drafting a chaser in your own tone, summarising a long supplier threadWorks on one email at a time and does not see your sheet unless you paste lines inStarts 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 OutlookInside OutlookDrafting and summarising mailCopilot 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 accountCopilot 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 projectBrowser or app, outside your mailBatch work: five tracker lines in, five chasers out; checking acknowledgementsYou paste in and copy out, so keep client names out of what you pasteAbout $20 a month each on individual plans (Claude Pro is $17 a month billed annually)
Gemini in Sheets or Copilot in ExcelInside the trackerExplaining a formula, adding a column, flagging linesSee the section below on what each can and cannot doGemini in Sheets needs Workspace Standard or above, or a Google AI plan; Copilot in Excel needs an eligible Microsoft 365 plan
No AI: mail rulesGmail or OutlookScheduling sends, labelling replies from each supplierNo judgement at allFree

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:

RungTriggerWhat it asks for
1: Confirm the orderNo written confirmation within a day of orderingQuantity, finish and a delivery date in writing
2: Pre-ship checkAbout five working days before the promised dateIs it still on track, and is anything out of stock
3: Dispatch checkPromised date within three daysA tracking reference or a delivery window
4: Late, new dateThe day after a missed dateA new confirmed date and the reason, by a stated time
5: EscalateBuffer is negative, or three days lateA 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:

SupplierLinesOn timeShare on timeAverage slip when late
Board merchant201785%1 day
Door finisher7686%2 days
Stone fabricator5360%4 days
Hardware distributor16956%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

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.

Want supplier chasing off your own to-do list?

On a 1:1 call we'll look at how your orders and deliveries are tracked today, set up a tracker and chaser routine in the mail system you already use, and decide what stays manual.

Book a 1:1 call with me