← All use cases · Shops & e-commerce
Let your store's AI flag reorders, forecast with Gemini in Google Sheets, and have your email tool draft low-stock campaigns
Steffy Lee Simms, founder of Guava Jammies, an eco-conscious children's clothing brand she runs on her own, in Business Insider
She relies largely on Shopify's built-in AI tools, which show product performance, tell her when it's time to reorder and suggest products worth scaling. She uses Gemini in Google Sheets to suggest custom tables and formulas for her decisions, and places specific order quantities based on the forecasts. Her email tool, Klaviyo, uses her Shopify inventory data to suggest campaigns for the products she has in stock, which she finds especially useful for items with only a few left.
Google Gemini $4.99/mo (Google AI Plus); free plan available · Shopify and Klaviyo: no price in our data
Medium · or we set it up for $197
Google Gemini, Shopify built-in AI, Klaviyo
The problem
Managing inventory alone meant building her own spreadsheets, deciding which metrics mattered and crunching numbers to decide what to buy and when; all those small decisions became a bottleneck, and items with only a few pieces left were hard to sell.
What happened
Self-reported: she says forecasting has made her more efficient in communicating with her manufacturer and helped reduce textile waste, and that she moves inventory faster: "What's better than logging into your email management system and seeing three campaigns already made based on your current inventory?" She says the lighter mental load gave her room to plan a women's wear line. No sales or savings figures are given.
Quoted in the source: Steffy Lee Simms, founder, Guava Jammies. Source: Business Insider: solopreneurs use generative AI for inventory management (Erin Greenawald, The AI-Powered Solopreneur series) (2026-05-22) · Added 2026-10-21.
How to set it up yourself
- What Guava Jammies does: Shopify's built-in AI flags reorders and best sellers, Gemini in Google Sheets helps build the forecasting tables and formulas, and Klaviyo suggests email campaigns from what's in stock; she decides the order quantities and which campaigns go out.
- Export 12 months of sales by product (units per month) and current stock from your store into Google Sheets.
- Open Gemini in Google Sheets (the Gemini button in the side panel; it needs a Google plan with Gemini) and paste the prompt below to build a reorder table. Check a few rows by hand before you trust the formulas.
- Turn the table into a purchase order you review yourself, then list the items with only a few pieces left and draft one email campaign for them (Klaviyo's AI can suggest it if you use Klaviyo); read it before it's sent.
Copy-paste prompt
This sheet has monthly unit sales by product for the last 12 months (columns {COLUMNS}) and current stock in column {COLUMN}. Add columns for: average monthly sales over the last 3 months, months of stock left, and a suggested reorder quantity to cover {MONTHS} months plus a {X}% safety buffer, rounded to the manufacturer's minimum of {MOQ}. Use formulas, not typed numbers, and explain each formula in one line. Flag products with fewer than {N} units left as 'low stock' and products with no sales in 90 days as 'slow'.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-18)
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-18)
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 Shops & e-commerce
Use ChatGPT to bulk-add book listings and spot titles to feature
The owner uses ChatGPT to fill in book details in bulk, uses AI on Google Analytics data to spot rising interest (romance before Valentin…
ChatGPT
Canva AI (Magic Studio)GAGoogle AnalyticsAdd a catalogue-only AI 'librarian' to your bookshop website
'Ask the Librarian' answers in the reader's language, only recommends books in the store's catalogue with live price and stock, and puts …
Use AI to research, price and catalogue thousands of used books before opening
AI helps find prices for comparable copies, check whether sets are complete, decipher old inscriptions, and turn his dictated book detail…
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.