Blog/Google Sheets
Google Sheets

Describe a weekly sales sheet and let Gemini build it

Use the Gemini panel in Google Sheets to create and organize a weekly sales table. Plus the announced rollout schedule for skills.

inform.praxis Oct 4, 2026 · 4 min read
What you will take away

Start in a blank spreadsheet, ask Gemini for a weekly sales table, then organize formulas and dates. Check the calculations before using the totals for decisions.

01. The task

Ask Google Sheets to build the weekly sales table you usually create by hand. Each sale should belong to one category, with formulas calculating the totals.

Before you start: look for the Gemini icon at the top right of Sheets. Availability depends on your Google Workspace plan or Google AI subscription. If it is missing, check your plan and administrator settings.

02. Build the table

Try this sequence. Gemini’s responses may vary.

  1. Open the Gemini panel in a blank spreadsheet.
  2. Enter: Create a weekly sales table with these columns: sale date, day of week, in-store card sales excluding delivery apps, in-store cash sales excluding delivery apps, delivery-app orders, other sales excluding the previous categories, and total. Derive the weekday automatically from the date. Use a formula to add the four sales categories.
  3. Once the table is in the sheet, enter one week’s sales.
  4. Ask: Add a weekly totals row at the bottom for each sales column.
  5. Ask: Format all dates as YYYY-MM-DD, for example 2026-10-05.

You can also start with a template. → Weekly sales sheet

03. Check the result

  • Formulas: independently calculate the totals you will use for decisions. A visible formula can still be wrong.
  • Overlapping categories: if a delivery order also appears in your card terminal, record it once.
  • Flag before deleting: ask to highlight duplicates before asking to remove them.
  • Meaning of the total: this is sales revenue, not bank deposits or profit. Keep track of fees and refunds separately.

More prompts → Opening Gemini in Sheets and asking useful questions

04. Coming next: skills

You can already save instructions with Gems. On September 30, Google announced a gradual transition to skills (announcement, administrator guidance).

  • Scheduled rollout: Workspace Rapid Release, October 5–12; Scheduled Release, October 19 through mid-November. The Gemini app rollout starts October 13.
  • Gems retirement: no earlier than March 1, 2027 for business and enterprise accounts.
  • Eligibility: the announcement lists Business Starter, Standard and Plus, among others. Enterprise plan descriptions differ between guidance documents, so check your specific plan. Workspace users must be 18 or older.
  • Separate settings: skills in the Gemini app and Workspace do not sync. Docs is the app named in the announcement.
Sources: Google Workspace Updates (September 30, 2026), Workspace administrator guidance. Plan eligibility and rollout dates may change.
WORK WITH ME

Need something like this?

If you have similar repetitive work, I can build it for you. Start by telling me which files you use and how you work today.