Summarize data with formulas — AI Prompts for Google Sheets

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

I need a one-sheet summary that shows monthly active users, revenue, and average session length for…

I need a one-sheet summary that shows monthly active users, revenue, and average session length for the last 12 months. Put the totals and month-over-month percent change in row 2, use the raw data in columns A through D, and check formulas for missing rows before I send this to the CEO on Friday.

Improve — make it easier to accept

Before I hand this summary to the product lead, make the key numbers impossible to miss: move total…

Before I hand this summary to the product lead, make the key numbers impossible to miss: move total revenue and percent change to the top, highlight any month with revenue down more than 5%, and show the formula that produces the average session length so an engineer can validate it quickly.

Decide — diagnose the stuck moment

I exported last month’s events into columns A to D and the summary suddenly shows a big revenue…

I just pulled raw event logs and the summary shows a revenue spike

I exported last month’s events into columns A to D and the summary suddenly shows a big revenue spike that isn’t in the raw rows. Priya in product will assume I mis-aggregated. I don’t know whether a stray duplicate row or a SUM range error caused it. What’s the fastest diagnosis and safest fix so I can lock the sheet and tell Priya the truth?

Become — change the pattern

Every time a fresh export lands, I spend 30–60 minutes hunting broken ranges and duplicate rows…

I keep rechecking formulas after every import

Every time a fresh export lands, I spend 30–60 minutes hunting broken ranges and duplicate rows before the deck update. I’m burned out and miss deadlines. Where should I change my habit so imports are trustworthy within ten minutes and I stop doing the same manual checks?

Next to this one

Other spreadsheet work people do in Google Sheets.

Set editing and view permissions Set up automatic recalculation Share spreadsheet with colleagues Sort data by column Split text into columns Track attendance or grades Track version history Trim and clean messy text Update chart data ranges Use ARRAYFORMULA to expand results

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt