When should you use it?
- Your office builds estimates from a price book and needs a second look at current supplier costs before a draft goes to a customer
- Supplier lists and the price book sometimes disagree, or a list is days or weeks old
- You want a draft the salesperson still reviews, with gaps named instead of filled in
Not for: Sending estimates automatically or promising a price the office has not approved; Safety-critical installation guidance, such as charging, combustion setup, gas connections or wiring methods; Shops with no price book and no supplier list to paste; the prompt will mostly return open questions; Assuming a live link to field-service software or a supplier portal; this workflow starts from exports
What do you need, and what do you get?
You need
- Job details: equipment requested, site notes, options to price, and any photos described in text
- A price-book export with sku, description, unit, book price and the date of the book
- One or more supplier lists or quotes with unit cost, supplier name and the date of each figure
- Labor hours and rates if the job includes labor, a written margin policy, tax rules, a freshness window and the name of the approver
You get
- An internal worksheet with sources, flags and conflicts for each line
- A customer-facing draft marked for review, with unconfirmed figures kept off the firm total
- A numeric grand total only when materials, labor, margin and tax are complete; otherwise the words NOT COMPUTED and a list of gaps
- Open questions for the salesperson; nothing sent to the customer
How does it work, step by step?
- Gather the exportsCollect the job notes, the current price book and a dated supplier list or quote. Spreadsheet exports you can paste into the chat are enough; a live software connection is not required.
- Set the policyWrite down the freshness window, the margin method, labor rates and how tax is handled, plus the person who must approve every estimate.
- Run the draftPaste the inputs with the prompt so the assistant matches each line, compares book and supplier figures, and flags anything missing, stale or in conflict.
- Read the flags firstDo not send a draft that still has unconfirmed lines or a missing total. Settle conflicts and refresh stale figures, then ask for a revised worksheet.
- Approve before anyone sends itThe salesperson edits the customer-facing draft and sends it from your own system. The assistant does not send, book or promise a price.
The prompt
Our own prompt, inspired by Tyler Griffin (@TylerGriffin) and written to work in Grok Bot, Claude, ChatGPT and others. Values in lime are placeholders.
You are preparing a DRAFT estimate for a field-service job. You do not send it, book it, or treat it as a customer commitment.
Inputs I will paste:
- JOB: site notes, equipment requested, options to price, and any photos described in text
- PRICE_BOOK: our internal list items, each with sku, description, unit, book price, and the date of the book
- SUPPLIER_PRICES: one or more supplier lists or quotes, each with sku or match key, unit cost, unit, supplier name, and quote_or_list_date
- LABOR_RATES: role, hourly rate, and hours if known
- MARGIN_POLICY: how we turn cost into a sell price (for example method markup_percent_on_cost and a percent)
- TAX_RULES: tax rate and what is taxable, or a statement that tax is added later by the office
- FRESHNESS_DAYS: a number; any supplier figure older than this is stale
- TODAY: the date to compare against
- APPROVER: the person who must sign off
Matching:
- Match each job line to price-book and supplier rows by sku first, then by exact description and unit.
- If two candidate matches remain, list them as a conflict and do not pick one.
Price and cost rules:
1. For every material line, record: job need, price-book figure if found, supplier figure if found, the supplier date, and whether that date is within FRESHNESS_DAYS of TODAY.
2. If a supplier figure is missing, mark the line UNCONFIRMED-NO-SUPPLIER-PRICE. Do not invent a cost.
3. If a supplier figure is older than FRESHNESS_DAYS, mark the line STALE and still show the dated figure, but do not treat it as confirmed.
4. If two supplier figures for the same item disagree, list both with dates and suppliers under CONFLICTS. Do not average or pick a winner.
5. If a price-book figure and a confirmed supplier figure disagree, flag the variance and use the confirmed supplier cost as the cost basis, keeping the book price visible for the reviewer.
6. Labor: only compute labor cost when both hours and a rate are provided. If either is missing, mark LABOR-INCOMPLETE and do not invent hours or rates.
7. Margin: only compute a sell price when MARGIN_POLICY is provided and every cost line that policy needs is confirmed (not missing, stale, or in conflict).
8. Tax: only compute tax when TAX_RULES are provided and the taxable sell subtotal is complete.
9. Grand total: output a numeric grand total only when materials, labor (if the job includes labor), margin, and tax (if tax is to be included) are all complete and confirmed. Otherwise write GRAND TOTAL: NOT COMPUTED and list what is missing. Never fabricate a total.
Output:
A) Internal worksheet: line-by-line sources, flags, conflicts, and any totals you were allowed to compute.
B) Customer-facing draft in plain language, marked "DRAFT FOR REVIEW BY {APPROVER} — NOT SENT". It must not include unconfirmed figures as if they were firm. If a grand total was not computed, the draft says a total will be added after review.
C) Open questions for the salesperson.
Hard limits:
- Do not give safety-critical installation advice (charging, combustion setup, gas connections, electrical wiring methods, or "this will fix the failure").
- Do not contact the customer or the supplier.
- Do not say the quote is approved or sent.
- If I ask you to send, book, or promise a price before the approver signs off, refuse and keep the work in draft.Inspired by Tyler Griffin (@TylerGriffin): X Article: how an HVAC and plumbing owner actually uses an AI assistant. The prompt above is written by playbooks.bot in our own words; nothing from the original is quoted.
What can go wrong?
- Treating a last-paid cost as current because the file was opened today. Judge freshness by the supplier quote or list date.
- Letting the assistant pick a winner when two suppliers disagree. Both figures should stay visible until a person chooses.
- Asking for a grand total when labor hours, margin or tax are still unknown. A missing total is safer than a made-up one.
- Using the draft as installation advice. It is a pricing worksheet, not a method for doing the work.
Our take
A confident estimate with a wrong equipment cost is worse than a draft that admits a gap. Griffin's account is useful because it treats current supplier prices as something to check before a salesperson reviews a draft, not as an afterthought. The article itself does not say what to do when a list is out of date, two vendors disagree, or labor and tax are still unknown, so those rules are ours. We made the assistant refuse to invent a grand total in those cases, keep both sides of a conflict in view, and leave every customer-facing draft behind a named approver. That is slower than a one-shot number, and that is the point. This is not a live hookup to a supplier portal or to field-service software, and we did not test it on a real company account. It will work when you paste complete, dated exports and a written margin and tax policy; it will correctly refuse to finish a total when you cannot. In our rule-engine dry run on synthetic fixtures, missing, stale and conflicting supplier figures, and missing labor, margin or tax, all blocked a fabricated total, and a send request stayed refused.
Where the time goes back: Checking each equipment line against a supplier list, spotting stale or missing costs and writing a clean draft is slow when you do it by hand in the middle of a busy sales day. The assistant does the matching and the exception list in one pass, so the salesperson spends time only on the lines that need a judgment.
FAQ
Do I need a live connection to our field-service software?
What if the supplier list is older than our freshness window?
Will the assistant email the estimate to the customer?
Source and credit
Inspired by Tyler Griffin (@TylerGriffin). We describe the idea in our own words, link to the original, and wrote the prompt ourselves; nothing is quoted.
- Inspired by
- X Article: how an HVAC and plumbing owner actually uses an AI assistant
- Creator
- Tyler Griffin (@TylerGriffin)
- Published on
- X
- Original date
- Nov 14, 2026
- License
- Not openly licensed (the poster keeps all rights), so we quote nothing and link to the original
- Originally for
- Grok Bot
- AI dry run
- Nov 16, 2026: passed. Dry-run tested by our AI test agent on sample input. No invented totals; conflicts, staleness and gaps visible; draft-only with the send refused.
AI dry run on sample data; not run with live connected accounts. The playbooks.bot test agent filled the prompt with synthetic inputs, produced the output and checked it against the page's stated outputs and guardrails. - Verified
- Nov 16, 2026: source link resolves to the original, the credited creator published it, our excerpt or prompt matches it, and the license allows our use.
Are you the creator? Claim or correct this page.