⚙️Operations & Admin · Step-by-step guide

Find your best and slowest sellers from last month's receipts, then get a picture and captions to promote the winner

Gemini's new small-business tools can turn a messy sales spreadsheet, a pile of receipts or purchase records into clear charts. You upload last month's sales, ask which three products made you the most and which sat still, then have Gemini make one promo picture in your brand style for the best seller and three short captions in your own tone.

Created byDonsie · @The_Donsie on X
📰 Read the original: Donsie: Google just gave Gemini a business hub. Here is a workflow you can try this week (X post) ↗
⏱️ About 20 minutes🎯 Easy💵 Free; Google AI Plus is USD 4.99/month for higher limits📋 7 steps
✨ Gemini📘 How-to
🎯 What you'll have at the endYou'll know your three best and three slowest products from last month, with a chart, plus a ready promo picture and captions for the best seller.

👀 What you'll get

Example

Here's the kind of thing you'll have at the end:

📊 ReportOctober sales · Teh Tarik Corner

Top 3 by money made

  • Iced teh tarik: MYR 3,240 (1,080 cups)
  • Kaya toast set: MYR 2,610
  • Nasi lemak bungkus: MYR 1,950

Slowest

  • Matcha latte: 14 sold
  • Brownie: 9 sold
  • Mango smoothie: none since 12 Oct

Worth noting

  • Saturdays bring in twice a weekday

Suggestion

  • Bundle brownie with iced teh tarik for the weekend

Caption idea

  • 'Saturday's sorted: iced teh tarik, the way the regulars like it.'

🧪 Made-up sample to show the kind of result. Your output will vary.

💸 What will this really cost me?

Prices checked 23 Oct 2026
🧪 To try it once
Free: the Gemini app is free with a Google account, with daily limits.
🔁 To keep it running
Free for a monthly check. Google AI Plus is USD 4.99 (MYR 20) a month and Google AI Pro USD 19.99 (MYR 82) a month for higher limits. Local prices vary by country: check the provider's pricing page.
⚠️ Watch out for
Google says the business page and finance tools are rolling out over the coming days, so they may not appear on every account yet, and it didn't say which features are on the free plan. Making several pictures a day can hit free limits.

🔗 Official pricing: Google AI & Gemini plans · Google: new Gemini tools for small business owners

Prices change often, so check the links before you pay. Amounts exclude tax. MYR at USD 1 = MYR 4.08 (Bank Negara Malaysia, 19 Oct 2026).

🧾 Which plan do I need?

✅ Free for you

The free Gemini app works for a monthly check, with daily limits.

🪙 Small = up to MYR 250 a month more · 💎 Big = over MYR 250 a month more · prices from each provider's pricing page, checked 21 Oct 2026.
ℹ️ How we work this outPrices come from each provider's own pricing page (checked 21 Oct 2026; amounts exclude tax; USD 1 = MYR 4.08, Bank Negara Malaysia 19 Oct 2026). Small upgrade = up to MYR 250 a month more than you pay now. Big upgrade = more than MYR 250 a month more. Check pricing = the provider doesn't publish a price we could confirm. Each guide's needs come from its own "What will this really cost me?" box. Your ticks stay in this browser only (no account, nothing sent to us).
Tick all your plans on the home page →

⏱️ Try it in 10 minutes

✅ Free plan · nothing to connect

What you'll see: your top and slowest sellers by money made, a simple chart, then a promo picture and captions for the winner.

Copy the prompt, paste it into one of the free AI apps below and press send. The sample is made up, so swap in your own details if you like.

💬 Your 10-minute test
Here are my sales for October from my small bakery (sample; upload your own sheet or receipt photos instead). Columns: product, quantity, price (MYR).

Croissant, 420, 6.50
Banana cake slice, 300, 5.00
Sourdough loaf, 95, 14.00
Cheesecake slice, 160, 9.50
Cinnamon roll, 40, 7.00
Gluten-free muffin, 12, 8.00

1. Show my top 3 by money made (not quantity), with totals.
2. Show the 3 that made least.
3. Make one simple bar chart of money made by product.
4. Make one promo picture for the top seller in warm, simple colours, with the words "Fresh every morning".
5. Write 3 short captions for WhatsApp status and Instagram.

✅ Works on: Gemini app (free) · ChatGPT Free · Claude Free

Links go to the official plan pages. Free plans have daily limits and can change, so check before you rely on them.

➡️ Like it? The full setup adds: The full guide covers uploading real receipts and sales sheets, using your logo and colours, and doing this every month. Go to the steps ↓

⚡ One-click install

Checked install pages (app stores, official sites and template pages): tap to get it straight away.

⬇️ Get Gemini on AndroidGoogle Play⬇️ Get Gemini on iPhoneApp Store

🧰 Before you start

⏱️ Time neededAbout 20 minutes
💵 Rough costFree; Google AI Plus is USD 4.99/month for higher limits

🪜 Step by step

🐣 Beginner mode: showing the 7 essential steps only. Extra steps are hidden; tap 🚀 Advanced at the top to see all 7.
✅ 0 of 7 steps done 📄 Printable page
  1. 1
    ☐

    Export last month's sales

    From your till, online shop or booking app, download last month's sales as a spreadsheet (CSV or Excel). If you only have paper, take clear photos of the receipts.

  2. 2
    ☐

    Remove customer details

    Delete columns with customer names, phone numbers or emails before you upload. Gemini only needs product, quantity, price and date.

  3. 3
    ☐

    Open Gemini

    Open the Gemini app or gemini.google.com (buttons below). Look for the new business page; Google says it is rolling out to all Gemini users, so if you don't see it yet, a normal chat works too.

  4. 4
    ☐

    Ask for the winners and the slow ones

    Upload the file and paste the 'Best and slow sellers' prompt below. Ask for a simple chart.

  5. 5
    ☐

    Check the numbers

    Pick two products and check Gemini's totals against your own records. Only then use the results to reorder or discount.

  6. 6
    ☐

    Make one promo picture

    Upload your logo and colours (or your website link) and use the 'Promo for the winner' prompt. Gemini keeps your brand style for future pictures.

  7. 7
    ☐

    Post it yourself

    Save the picture and pick one caption. Post it to WhatsApp status, Instagram or Facebook.

💬 Copy-paste prompts

Tap Copy prompt, paste it into your AI (Grok, ChatGPT, Claude or Gemini), then replace the [yellow bits] with your own details.

💬 Best and slow sellers
Here are my sales for [month] from my [shop / salon / online store]. Columns: product or service, quantity, price, date. Customer details are removed.
Please:
1. Show my top 3 products by money made (not by quantity), with totals in [currency].
2. Show the 3 that sold least or not at all.
3. Make one simple bar chart of money made by product.
4. Note anything odd: a product that suddenly dropped, a day of the week that's much busier.
5. Suggest one thing to do for the slow sellers (bundle, discount, stop stocking) and say it's a suggestion.
Only use numbers from the file. If something is unclear, ask me instead of guessing.
💬 Promo for the winner
Using my brand style (logo and colours I've uploaded), make one square picture to promote [best-selling product] for a WhatsApp status and Instagram. Show the product clearly, add the words '[short offer or line]' and leave space at the bottom. Then write 3 captions under 30 words each in my tone: [e.g. friendly, local, a bit cheeky]. No prices unless I give one: [price].

⚠️ Tips & common mistakes

🌟 Why it's worth it

💡 Why it mattersSmall shops rarely look at which products actually earn money, so stock and promotion go on gut feel. A monthly 20-minute check shows what to reorder and what to discount, and gives you a ready-made post for the product people already want.
🏷️ Real exampleDonsie (@The_Donsie on X) turned Google's 20 Oct 2026 Gemini small-business announcement into a 'Wednesday workflow' for a small shop, salon or online store: export last month's sales, ask for the top 3 and the ones that sat still, upload logo and colours for one status image for the best seller, then ask for 3 captions in your own tone. His catches: it's still rolling out, strip customer names and numbers before uploading, and check the numbers yourself before ordering stock.
🔌 Connects to:Gemini appA sales spreadsheet or photos of receiptsYour logo and brand coloursWhatsApp status, Instagram or Facebook (you post yourself)
📘 Proof level: How-toA how-to guide, template or new feature from the maker or a guide site. It shows what you can set up and claims no particular results.
📰 Found via X (Twitter): Donsie: Google just gave Gemini a business hub. Here is a workflow you can try this week (X post) ↗

🔗 Helpful links

🔗 Donsie's workflow post (source) ↗🔗 Google: new Gemini tools for small business owners ↗🔗 Google AI & Gemini plans ↗

📬 Every Monday: new things AI can do for you, with the exact prompt to copy

Sign up free and get our PDF of 20 copy-paste AI prompts straight away. One short email a week, unsubscribe in one click.

← Back to all use cases