Skip to content
GetInto AI

Perishable waste check with Gemini in Sheets for farm shops

Gemini in Google Sheets compares weekday till sales with producer deliveries, so bread, veg and dairy orders match what sells. From about $16£12€14A$23C$23 a month.

At a glance

  • What it costs$16£12€14A$23C$23 a month

  • Worth, in extra profit or time saved in the worked example$114£86€102A$165C$162 a month

  • Pays for itselfIn about a week

  • Connecting two tools or some setup timeSome setup needed

Figures come from the worked example below, using its stated assumptions. Tool prices checked . How we check prices

The problem

Bread, salad, soft fruit and dairy from local producers have a short life, and a farm shop that orders the same every day bins the difference on quiet days. Throwing away about $80£60€71A$115C$113 a week of perishables at cost is about $343£258€307A$495C$485 a month.

What the AI does

Export 8 weeks of item sales by day from your till and list what each producer delivered on each day. Paste both into Google Sheets, click Ask Gemini and ask for a pivot table of units delivered, sold and left over by line and weekday, with a chart. Google says Gemini in Sheets can create tables, formulas, pivot tables and charts. You then set a standing order per weekday with each producer. On a business account it needs Google Workspace Business Standard (about $16£12€14A$23C$23 per user a month).

A worked example

A farm shop near Ludlow takes daily deliveries of bread, salad and milk from 6 local producers. The manager pastes 8 weeks of till sales and delivery notes into a Google Sheet and asks Gemini for leftovers by weekday.

Before

About $80£60€71A$115C$113 a week of perishables binned at cost, about $343£258€307A$495C$485 a month

After

Standing orders set by weekday, waste down by a third to about $229£172€205A$330C$323 a month

What it's worth

About $114£86€102A$165C$162 a month less waste, against about $16£12€14A$23C$23 for Workspace Business Standard. Cutting $343£258€307A$495C$485 a month of binned perishables by a third saves about $114£86€102A$165C$162 for about an hour a month of exporting and checking.

How to set it up

  1. Use Google Workspace Business Standard (€13.60, about $16£12€14A$23C$23 per user a month on a one-year commitment) for the manager's account.
  2. Export 8 weeks of item sales by day from your till, and list deliveries by line and day from producers' delivery notes.
  3. Paste both into a Google Sheet, click Ask Gemini and ask: 'Make a pivot table of units delivered, sold and left over by line and weekday, and chart the 10 lines with most left over.'
  4. Check two lines by hand against the till and the delivery notes.
  5. Agree a standing order per weekday with each producer, and run the check again after a month.

What goes wrong

  • Sales show what sold, not what people wanted. If a line sold out by noon, demand was higher; note sell-out times for a fortnight.
  • Weather, school holidays and local events move sales. Keep a small top-up arrangement with producers for busy weekends.
  • If Gemini builds a formula wrongly, every order is wrong the same way. Check a sample by hand.
  • Business Starter (about $8£6€7A$12C$11) doesn't include Gemini in Sheets. On a personal Google account, Google AI Pro ($25.26£18.99€22.60A$36.46C$35.70 a month) does.

More ideas for Farm shops

Seasonal emails for farm shops: what's in this week

A short weekly Brevo email tells opted-in customers what's in season and on the counter. From about $8£6€7A$12C$11 a month for up to 500 contacts.

  • Costs $8–17£6–13€7–15A$12–25C$11–24/mo
  • Worth $274£206€245A$396C$387/mo
  • Pays for itself in a few days
  • Easy to set up

Stock control for farm shops: reorder from local producers

Square for Retail tracks stock on each local producer's lines and drafts purchase orders for you to check. From about $65£49€58A$94C$92 a month per shop.

  • Costs $65£49€58A$94C$92/mo
  • Worth $246£185€220A$355C$348/mo
  • Pays for itself in about a week
  • Some setup needed

Click and collect for farm shops: pre-ordered meat boxes

Sell meat and veg boxes online with Shopify, paid upfront and collected from the farm shop on the day you set. From about $33£25€30A$48C$47 a month.

  • Costs $33–110£25–83€30–99A$48–159C$47–156/mo
  • Worth $251£189€225A$363C$355/mo
  • Pays for itself in about two weeks
  • Some setup needed

Staff rotas for farm shops: cover busy weekends and seasons

Plan farm shop, butchery and café shifts around staff availability in RotaCloud, with swaps and holiday requests in an app. From about $27£20€24A$38C$38 a month.

  • Costs $27–40£20–30€24–36A$38–58C$38–56/mo
  • Worth $206£155€184A$298C$291/mo
  • Pays for itself in about a week
  • Easy to set up

Loyalty scheme for farm shops: bring weekend visitors back

Square Loyalty gives farm shop customers points at the till, with texts when they earn a reward. From about $33£25€30A$48C$47 a month per shop.

  • Costs $33–60£25–45€30–54A$48–86C$47–85/mo
  • Worth $168£126€150A$242C$237/mo
  • Pays for itself in about two weeks
  • Easy to set up

Producer invoices for farm shops captured with Dext

Dext reads the paper and emailed invoices from local producers at goods-in and sends them to Xero to approve. From about $32£24€29A$46C$45 a month, plus Xero.

  • Costs $32–40£24–30€29–36A$46–58C$45–56/mo
  • Worth $133£100€119A$192C$188/mo
  • Pays for itself in about two weeks
  • Some setup needed

Last updated October 17, 2026.