Role guide · Ecommerce ops · Gemini · Workspace · Oct 2026
Gemini for ecommerce ops (Oct 2026): Sheets inventory trackers, Docs product briefs, and Gmail supplier replies
Ecommerce ops role guide for inventory leads, merchandisers, buyers, and wholesale coordinators whose company runs on Google Workspace — Gemini lists low-stock SKUs in a sanitized inventory Sheet, builds a reorder review, turns approved spec sheets into Docs product briefs, and drafts supplier and wholesale replies in Gmail. You check ten rows by hand before anyone raises a purchase order, the merchandiser approves every product claim, and a named person sends every email. Companion to ChatGPT for ecommerce ops and Stack map for ecommerce ops.
Who this guide is for
Inventory leads, merchandisers, buyers, and wholesale coordinators — the person who exports stock and sales into a Sheet, writes product briefs in a Doc, and answers supplier email — at a brand that already pays for Google Workspace. If your inventory system already forecasts demand and suggests reorders, use that first: see Cin7 AI. If your store platform drafts product copy in the catalog, see BigCommerce AI or Wix AI. If your team drafts in ChatGPT instead, see ChatGPT for ecommerce ops.
What Google documents (its Gemini in Sheets, Gemini in Docs, and Help me write help pages and its pricing page, read 16 October 2026): in Sheets, Ask Gemini opens a side panel that can create tables and formulas, analyze data, and take actions such as conditional formatting, pivot tables, and inserting or deleting rows, and Undo reverses an action. In Docs, Gemini shows edits as suggestions you accept or reject, and you can add files as Sources. In Gmail, Help me write drafts or refines a message and can pull details from your other emails and Drive files — Sources shows what it used. Google's pricing page lists Gemini in Gmail on every Business plan, and Gemini in Docs and Sheets on Business Standard and above.
Ground rules for every section below: Gemini never sends a supplier or customer email, never changes a price or discount in the store, never publishes a product page, and never places a purchase order. It lists, drafts, and suggests; the inventory lead, merchandiser, or buyer makes each change in the system that owns it, and a named person sends each email. Work from sanitized exports — SKU, units on hand, units sold, supplier, lead time — with no customer PII (names, emails, phones, addresses), no card number, no full order export, no supplier bank details or tax ID, and no passport or ID scans from a supplier onboarding pack. Social security numbers from payroll never belong in a prompt either.
Major features (with how someone uses them)
Examples at a glance: each feature has a concrete example from a real job plus a short Try this you can run this week.
1. Inventory Sheet: SKUs under 14 days of stock (primary)
What it is: Export units on hand and last month's units sold by SKU from your store platform or inventory system, open it as a native Google Sheet, and keep only SKU, product name, units on hand, units sold last month, and supplier lead time — no customer or order columns. Open Ask Gemini and ask it to list SKUs with fewer than 14 days of stock at last month's sales rate, showing the formula it used. Before anyone raises a purchase order, check ten rows by hand: some it flagged and some it didn't.
A low-stock flag is a question, not a purchase order. The inventory lead knows about the inbound shipment, the discontinued colorway, or the bundle that double-counts units — and raises any PO in the inventory system.
Primary workflow:
In a sanitized inventory Sheet, ask Gemini to list SKUs with fewer than 14 days of stock at last month's sales rate. Check ten rows by hand.
2. Reorder review by supplier with a decision column
What it is: On a copy of the same Sheet, ask Gemini for a pivot table of low-stock SKUs by supplier with each supplier's lead time, then ask it to highlight SKUs whose days of stock are shorter than the lead time. Add an Inventory lead decision column yourself. Use Undo if an action touched the wrong rows, and insert anything you want to keep — Google says the side-panel history is lost when you reload the browser.
The pivot shows where to look; it does not set quantities. The inventory lead decides each reorder and raises it in the inventory system.
Pivot, then decide:
On a copy of your sanitized inventory Sheet, ask Gemini for a pivot of low-stock SKUs by supplier with lead times and add an Inventory lead decision column. Undo anything that changes the source rows.
3. Product briefs in Docs from approved sources
What it is: In Docs, add the approved sources — supplier spec sheet, brand style guide, the category's sizing chart — as Sources, and ask Gemini for a product brief: positioning, key materials, sizing notes, care, and photo needs, with the source named under each line and a list of anything the sources do not cover. Gemini's edits appear as suggestions; the merchandiser accepts or rejects each one. Health, safety, and “made in” lines come only from the spec sheet.
Mark, don't fill. Ask Gemini to label any line it cannot tie to a source as Not in sources — merchandiser to confirm.
Source every line:
Add one supplier spec sheet as a Source in Docs and ask Gemini for a product brief that names the source under every line. Have the merchandiser reject every line marked not in sources.
4. Supplier and wholesale replies in Gmail
What it is: For a supplier delay or a wholesale inquiry, draft with Help me write from facts you already confirmed — PO date, quantity, the minimum order, the wholesale terms sheet — not from pasted bank details or customer data. Open Sources, remove anything that pulled the wrong Drive file (an old line sheet, last season's terms), and have the buyer or wholesale coordinator send the email.
Gemini drafts; people send. Never paste supplier bank details, tax IDs, or customer lists into Gmail prompts.
You send:
Draft one supplier or wholesale reply with Help me write from confirmed facts only. Open Sources, remove anything from an old line sheet, check the terms in this season's sheet, and have a named person send it.
5. Which Workspace plan includes Gemini in Sheets
What it is: As listed on 16 October 2026, Google's pricing page shows Business Starter at $7 per user per month, Business Standard at $14, and Business Plus at $22 (list prices with a one-year commitment, before tax). For new customers it also shows introductory discounts for three months, running Oct 30, 2026 – Jan 30, 2027 (20% off Starter, 30% off Standard, 50% off Plus). Gemini in Docs and Sheets is on Business Standard and above; Gemini in Gmail is on all Business plans. Business plans top out at 300 users; Enterprise is via sales.
If your inventory and merchandising team is on Business Starter, the Sheets workflow above needs an upgrade or another tool — check before you promise it.
Check the plan grid:
Open workspace.google.com/pricing and confirm whether your inventory lead and merchandisers are on Business Standard or above before you standardize on Sheets Gemini workflows.
6. Sanitized exports and privacy
What it is: Google's generative AI privacy page says your data, including personal and business data in products such as Gmail, is not reviewed by humans or otherwise used for generative AI model training outside your domain without permission. That does not make it safe to paste customer PII or a full order export. Keep names, emails, shipping addresses, card numbers, subscriber lists, and supplier bank details out of prompts. If someone pastes them, delete the copy, tell whoever owns that data, and re-export a sanitized file.
Deleting a prompt does not undo an exposure. Customer records belong in the store platform and help desk; supplier payment details belong in accounting.
Strip before you prompt:
Before any Gemini prompt, open your export and delete customer names, emails, addresses, order numbers, card data, and supplier bank details. Keep SKUs, units, dates, lead times, and counts only.
Pricing context (October 2026)
As listed on 16 October 2026 at workspace.google.com/pricing (Oct 2026): Business Starter $7, Business Standard $14, Business Plus $22 per user per month (list, one-year commitment, before tax). Gemini in Docs/Sheets requires Business Standard or above; Gemini in Gmail is on all Business plans.
Introductory three-month discounts for new customers appear on the pricing page (Oct 30, 2026 – Jan 30, 2027); budget from your invoice and the plan grid, not from memory.
Uncertainty: Workspace list prices and promo bands change, and the page shows prices for your region. Confirm the live pricing page and your admin console before budgeting. Gemini suggests; it does not send supplier or customer mail, change prices, publish products, or place purchase orders. Feature availability can vary by language and admin settings.
When it’s useful (honest take)
Useful when your brand already works in Google Workspace on Business Standard or above and the inventory lead and merchandiser will decide in the inventory system and store platform.
Less useful when your inventory system already forecasts and suggests reorders (Cin7 AI), your PIM already drafts briefs (Salsify AI, Akeneo AI), or the team is on Business Starter without Sheets Gemini.
Paying for Gemini and a few other AI tools? The $9 AI toolkit spreadsheet lists every AI subscription you have, what each one costs, and how fast it pays for itself, so you can see which ones are worth the money.
Want someone to do it for you? AI toolkit audit — $19
Related options (educational)
| Need | Better home | Why |
|---|---|---|
| Low-stock lists in Sheets | Gemini for ecommerce ops (this page) | Business Standard $14+ |
| CX macros in a Project | ChatGPT for ecommerce ops | Business seats |
| Demand forecasts and reorder suggestions | Cin7 AI | Add-on, price not public |
| Product data enrichment | Akeneo AI | Quote-based |
| Marketing twin guide | Gemini for marketing ops | Workspace Standard+ |
FAQ
How should an ecommerce team start with Gemini?
Start with a sanitized inventory export in a native Google Sheet: SKU, product name, units on hand, units sold last month, lead time — no customer or order columns. Ask Gemini to list SKUs with fewer than 14 days of stock at last month's sales rate and check ten rows by hand. The inventory lead decides any purchase order in the inventory system.
Can Gemini send supplier replies or place orders for us?
Not in this guide. Gemini drafts with Help me write; a named person checks the facts, opens Sources, reads the email, and sends it. Purchase orders are raised by the inventory lead in the inventory system.
Which Workspace plan do we need for Gemini in Sheets?
As listed on 16 October 2026, Google's pricing page shows Gemini in Docs and Sheets on Business Standard ($14 per user per month), Business Plus ($22), and Enterprise, but not on Business Starter ($7), which gets Gemini in Gmail. Check workspace.google.com/pricing before budgeting.
Is our store data used to train Gemini?
Google's privacy page says Workspace data is not reviewed by humans or otherwise used for generative AI model training outside your domain without permission. That covers the company account; personal accounts have different terms. Still never paste customer PII or order exports.
What if someone pastes customer emails or card numbers into a prompt?
Delete the copy, tell whoever owns that data, and re-export a sanitized file. Deleting a prompt does not undo the exposure. The Sheet should hold SKUs, units, dates, lead times, and counts only.
Optional next step (if seats overlap)
If ecommerce ops pays for Gemini, a chat assistant, an inventory system with its own forecasting AI, and a PIM that drafts the same briefs, fix that overlap before adding another seat. Map the overlap with the $19 AI toolkit audit or the $9 AI toolkit spreadsheet. Email Audit $19 or Toolkit spreadsheet $9.
Checkout is live via Stripe. After you pay, we email delivery (spreadsheet) or intake next steps (audit).