Family-owned apothecary and online retailer, Chicago (Merz Apothecary)
- Size
- More than 60 staff
- Where
- US
- Tool
- Shopify's built-in AI, Google Gemini
What the AI did
Used the AI built into its e-commerce platform to produce sales reports on demand, and searched years of old files with Gemini.
The result
Sales reports that took hours to build now take minutes.
Check before trusting
Reconcile the report's totals against your own figures the first few times. Check the date range and any filters it used.
Prompt to try it
Test the job on your own material before buying anything. Replace the highlighted brackets.
Using our sales data for [DATE_RANGE], build a report showing [METRICS] by [PRODUCT_OR_CHANNEL]. Compare it with [COMPARISON_PERIOD] and list the five biggest changes in plain English.
Source
US House Committee on Small Business ↗, 14 July 2026 · official
This source is an official publication.
More from the archive
Bee conservation business, Ireland (OpenHive Bee Conservation)
Photographs handwritten field notes from the apiaries and has AI read, sort and digitise them.
Result Gemini frees up over half a day a week.
Not statedIreland
24/7 veterinary referral hospital, Catalonia (Hospital Veterinari Desvern)
An AI scribe drafts consultation notes during the appointment instead of after it.
Result Writing up a consultation and report fell from around 23 minutes to five.
About 20 staffSpain
Family-owned vet practice, northwest London (Fauna Veterinary Clinic)
An AI scribe records the consultation and drafts structured clinical notes, which staff review before saving.
Result The AI scribe saves five minutes per consultation.
4 staffUK
New entries every week
The archive grows weekly. Get the stories in your inbox, with the context behind them.