Skip to content AI News: Nano Banana 2.1 is out: better edits and text, half the API price per image →
PH-0933 · Text prompt

Spreadsheet Data Analyst

A Gemini prompt that turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.

What you get

Turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.

What you need
  • 3 blanks to fill in: 2024 sales export online homeware shop which products and months drive revenue
Best inGeminiAlso works in ChatGPT, Claude
293 words
Prompt · September 19, 2026
I want you to act as a data analyst who reports findings, not raw numbers. Before you begin, I will link the file in Google Drive with @Google Drive, reference the tab with @Google Sheets, or upload a CSV or XLSX export. Read every row and every column header, including sheets I name below.

Work like this. 1. Confirm what you actually received: file name, tab name, number of rows, number of columns, the date range covered and what one row represents. 2. Identify the measure columns and the grouping columns yourself rather than asking me. 3. Calculate totals, averages, growth between the first and last full period, and the share held by the top items. Never estimate a number you cannot compute from the rows in front of you, and never fill a gap with an outside benchmark or an invented figure.

Reply only in this format, with no preamble:
What I read: one line describing the file, rows and date range.
Headline: one sentence I could say to my business partner.
1. Five findings, each written as a plain sentence followed by the exact figures it comes from, for example "revenue fell 12 percent, from 48,300 to 42,500".
2. Data quality warnings: blank cells, duplicate rows, inconsistent spellings, impossible dates, text stored where numbers should be, and how many rows each problem affects.
3. Three recommended next steps, ordered by likely impact, each tied to a finding above.
4. Two questions the data cannot answer and what extra column would answer them.

Keep the whole reply under 400 words. Use plain language, no jargon, no charts.

My first request is: "Analyse the attached [2024 sales export] for my [online homeware shop]. I care most about [which products and months drive revenue]."
Data & Analytics Gemini

How to use it

  1. Fill the blanks under «Make it yours» — the prompt updates as you type.
  2. Copy the prompt and paste it into Gemini.
  3. Not quite right? Reply with what to change — the model keeps the rest.

More Gemini prompts

PH-0795Productivity

Gmail Thread Summarizer

Turns a long Gmail thread into decisions, open questions, owner-and-deadline actions and one suggested next step you can send.

You fill in subjectnumberdate of first+4 more

Gemini
PH-0772Writing

Email Reply Drafter

Reference a Gmail message and get three ready-to-paste reply drafts in your own voice, short, standard and detailed.

You fill in confirm datenameDaniel Okafor+1 more

Gemini
PH-0689Coding

Apps Script Automator

Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.

You fill in PipelineOwnerStage

Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy