Have Gemini write the code for a daily sales forecast report for your café, even if you don't program
Hrag Kalebjian, who took over his family's Henry's House of Coffee in San Francisco (a local landmark with a nationwide coffee subscription), in a Google Keyword blog customer story
Gemini wrote custom code for a daily sales forecaster from his plain-language requests, and he fixed errors by sharing screenshots with it. He also uses Gemini to turn dense PDFs into printable instruction cards and to polish his weekly newsletter.
Google Gemini $4.99/mo (Google AI Plus); free plan available
Medium · or we set it up for $197
Google Gemini
The problem
Tracking daily revenue matters, but pulling the numbers by hand every day takes time, and Kalebjian juggles every role from roaster to accountant to marketer.
What happened
The forecaster took about an hour to set up, and he gets the report every morning. A printable instruction card for the shop's Armenian coffee kits took about 20 minutes. Google says the shop creates assets 95% faster with Gemini. Self-reported.
Quoted in the source: Hrag Kalebjian, Henry's House of Coffee. Source: Google Keyword blog: 3 ways small businesses can save time with Gemini (2026-07-08) · Added 2026-10-23.
How to set it up yourself
- What Henry's House of Coffee uses: Gemini as a coding assistant. The owner described the daily sales forecaster he wanted in plain language, and Gemini wrote the code. The story doesn't say where the code runs or which sales system it reads from.
- Export a few months of daily sales from your POS into a Google Sheet (date, day of week, total sales, and notes such as weather or events).
- Paste the prompt below into Gemini with your column names. Ask for a Google Sheets formula or an Apps Script you can paste in, plus step-by-step setup instructions.
- Run it. If anything errors, screenshot the error and send it back to Gemini, the way Kalebjian did, until the forecast works.
- Set a daily trigger (or a scheduled action, if your Gemini plan has it) so the forecast lands in your inbox each morning, and check it against actual sales for a couple of weeks before relying on it.
Copy-paste prompt
I run {BUSINESS TYPE} and I'm not a programmer. My daily sales are in a Google Sheet called {SHEET NAME} with columns {COLUMN NAMES}, going back to {START DATE}. Write a Google Apps Script that forecasts today's and tomorrow's sales from the same weekday over the last {NUMBER} weeks, adjusted for {SEASONAL OR EVENT NOTES}, and emails the forecast to {EMAIL} every morning at {TIME}. Give me step-by-step setup instructions written for a beginner, and explain how the forecast is calculated in plain English.We set up one AI automation in your tools, live within 48 hours of getting access, for $197. No call needed. Founding price for our first 10 customers (regular $297).
One short email a day: 3 new AI use cases from real small businesses, each with its source and setup steps, plus a Tool of the Day. Free, no spam, unsubscribe anytime.
Tools used
Google Gemini
Google's AI assistant, integrated with Gmail, Docs and Workspace.
From $4.99/mo (Google AI Plus); free plan available (checked 2026-10-21)
Visit site →Some tool links may be affiliate links. Disclosure
Checked prices: Google Gemini: from $4.99/mo (Google AI Plus); free plan available (verified 2026-10-21)
Rather not do it yourself?
The $197 Quick-Win: we set up one AI automation that saves you hours each week, in accounts you own, live within 48 hours of getting access. No call needed. Refund if it isn't live in 48 hours or isn't doing its job in the first 14 days. Founding price for our first 10 customers (regular $297). Terms.
See the $197 Quick-WinNeed more than one automation or ongoing care? Bigger setups: $149/mo with setup included (6-month minimum), or $497 pay-once. Satisfaction guarantee: we'll fix it until it works. Pay-once setups: or we refund your setup fee. $149/mo plan: cancel in the first 30 days and we refund your first month. We reply within 1 business day.
Related for Restaurants
Let customers build catering orders by chatting with an AI that remembers past events
An AI catering assistant (AIA) takes orders through conversation, using headcount, budget and event type for recommendations and quotes, …
Draft every review reply with AI, then approve each one before it posts
Marqii's Suggested Review Response feature drafts on-brand replies (positive, negative or neutral) using the restaurant's tone and custom…
Run a holiday pre-order campaign with AI agents taking BBQ orders
AI agents took advance takeout orders for the holiday.
Running something like this in your business? Submit your use case and we'll credit you with a link.
Get 3 new AI use cases every morning
One email every morning: 3 new AI use cases from real small businesses, each linked to its source, plus a Tool of the Day. Free. No spam, unsubscribe anytime. Privacy
Rather have one set up for you? The $197 Quick-Win.