Turn a Spreadsheet Analysis into a Three-Finding Executive Summary Email
Get a short executive email with three numbered findings backed by your data, one clear recommendation, one open question, and a note on data gaps.
You getSubject line, greeting and bottom line
Prompt
You are a senior business analyst who writes summary emails for busy executives.
Right after this prompt I will paste my spreadsheet analysis: a table, pivot output, results or rough notes. If I have not said who the email is for and what decision it supports, ask me those 2 questions first and wait for my answers.
Turn the analysis into a short email for a reader who will never open the file.
Rules:
1. Include exactly three findings. Each states a number from my data plus a comparison (vs. last period, target or another segment).
2. Use only figures that appear in what I paste. If you calculate something, show the math in parentheses. Never estimate missing data.
3. Give one recommendation that starts with a verb and names an owner or deadline if I provided one.
4. End with one open question the reader can answer in a single reply.
5. Keep the body under 180 words. Spell out terms like YoY once. Never mention tab names, cell ranges or column letters.
Output format:
- Subject line (under 60 characters, includes the main number)
- Greeting
- Bottom line: one sentence
- Findings: three numbered bullets
- Recommendation: one sentence
- Open question: one sentence
- Sign-off
Below the email, separately, list up to three data gaps or assumptions you made.Example output
Tips and common edits
Why this works
- Capping it at three findings, each with a number and a comparison, forces the model to pick what matters instead of dumping every metric.
- Banning cell ranges and tab names keeps the email readable for someone who will never open the spreadsheet.
- Ending with one answerable question and a separate gaps list gets you a decision back and flags weak spots before the reader does.
Use after you finish a pivot table or analysis and need to report it upward. Paste the summary table or key numbers into ChatGPT, Claude or Gemini, and know who reads it and what decision it informs.
Common edits
- Change the body limit to 100 words for a Slack or Teams update instead of email.
- Ask for two versions of the recommendation, one cautious and one bold, so you can choose before sending.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Design a One-Page Manager Dashboard in Excel or Google Sheets
Get a buildable one-page dashboard plan with a layout grid, a spec for each tile (metric, chart, filter, source range, formula) and numbered build steps.
Plan a Pivot Table That Answers a Specific Business Question
Get a pivot table plan mapping your fields to rows, columns, values and filters, with aggregation choices, data shape fixes and build steps.
Write a Weekly or Monthly KPI Report Narrative from Your Excel Numbers
Turns your pasted KPI numbers into a report narrative where each metric states the change, the likely driver and a next action, with every claim tied to a figure.
Build a Break-Even and Pricing Calculator Spreadsheet in Excel
You get an Excel layout that separates fixed and variable costs, formulas for break-even and margin at three prices, and a ranking of which inputs move the result most.
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.