New to AI? You don't need to learn anything first. Follow the steps below: open the tool, paste the prompt, fill in the [brackets], then check the result before you use or send it. See also how to use AI at work, for beginners.

Job 6 of 17ChatGPTGemini

Build a pricing sheet for your arrangements

Pricing by eye means some designs quietly lose money once freight, wasted stems and your time are counted. A pricing sheet adds every cost so each quote has a real margin.

Time: 15 minutesTool cost: you can start with a free AI tool

A free AI chat tool (ChatGPT, Gemini, Copilot or Claude)

Steps

Gather recent wholesale invoices and note your typical freight charge and how many stems you usually lose.
Decide your hourly labour rate and your markup. These are your decisions.
Run the prompt below to build the sheet in Google Sheets or Excel.
Test it on three recent orders and compare with what you charged.
Use it for every quote and update stem prices each month.

The exact prompt

Copy, paste, then fill in the [brackets]

Build a florist pricing sheet for Google Sheets.
Rows: each stem or sundry with quantity and unit cost.
Then: subtotal, freight [%], waste allowance [%], labour (minutes x hourly rate [£]), markup [my figure], VAT if registered, final price.
Explain each formula in one line. Use my numbers [paste]. Don't suggest markups; I set them.

✓ Check before you send

Costs come from your real invoices.
Markup and labour rate are your own choices.
VAT is only included if you're VAT registered.
You've tested it against recent jobs.

UK notes extra

GOV.UK: consumer protection rights.

Last reviewed Oct 2026. Free tools change. If a screen looks different, the steps still apply.Back to top ↑

More AI jobs for florists

Plan Valentine's or Mother's Day before it plans you
Reply when a budget doesn't match the wishlist
Turn a wedding consultation into an itemised quote (subscribers)
Help customers word a sympathy or card message (subscribers)
Write online shop listings that set honest expectations (subscribers)
Write sustainability claims you can actually back up (subscribers)
Write a wedding pricing guide for couples (subscribers)

See all 17 jobs in the florists playbook →

The full playbook

Unlock the other 14 florists jobs

Every job has the full steps, the exact prompt, a check-before-you-send list and optional UK notes. We keep adding new jobs and new niches, and re-checking existing jobs, while you subscribe. Monthly, cancel anytime, instant access, no password.

Just florists

£5 a month

Every job in florists plus the updates we make to it.

Subscribe · £5/mo

3 niches

£12.99 a month

Starts with florists; you pick the other two (or swap later) on your account page.

Subscribe · £12.99/mo

All niches

£19.99 a month

All 81 niches, and every new one we add. Or £149 a year: save £90.88.

Subscribe · £19.99/mo or £149 a year (save £90.88)

Cancel anytime. One click in Stripe's billing page, no emails or phone calls: how to cancel.

Pay securely with Stripe. Prices include any VAT. Digital content: at checkout you ask for instant access and agree you lose the 14-day right to cancel once it starts. Terms · Privacy · Pricing · Already subscribed? Sign in