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

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

At a glanceQ3 regional sales headline figuresThree findings from the executive summary email
Total Q3 revenue
$4.82M
Up 6% on Q2's $4.55M
Northeast and Midwest new revenue
$0.31M
More than the company's entire net gain
Southwest vs $1.00M target
$0.86M
A 14% miss
Southwest average deal size
$15,100
Down 18% from $18,400

Example for: a sales operations analyst at a mid-size furniture distributor reporting Q3 regional sales to the VP of Sales, who is deciding where to add one new sales rep.

Subject: Q3 sales up 6%, but the Southwest missed target by 14%

Hi Dana,

Bottom line: Q3 revenue grew to $4.82M, but nearly all growth came from two regions, and the Southwest is falling behind fast enough to justify the new rep going there.

Findings:

  1. Total Q3 revenue was $4.82M, up 6% on Q2's $4.55M ($4.82M − $4.55M = $0.27M).
  2. The Northeast and Midwest produced $0.31M of new revenue combined, more than the company's entire net gain, so other regions shrank slightly overall.
  3. The Southwest closed $0.86M against a $1.00M target, a 14% miss, and its average deal size fell from $18,400 to $15,100 quarter over quarter (down 18%).

Recommendation: Assign the open sales rep position to the Southwest and have Marco Ruiz present a deal-size recovery plan by November 15.

Open question: Do you want the Southwest target for Q4 kept at $1.00M, or reset to reflect the smaller deal sizes we are seeing?

Best,
Priya Shah
Sales Operations


Data gaps and assumptions

  • The pasted table had no headcount by region, so I could not compare revenue per rep; the case for the Southwest rests on target miss and deal size only.
  • I assumed the $1.00M Southwest target is the current approved figure, not a draft.
  • Deal size drop could reflect product mix; the data did not include a category breakdown to check this.
Written by AI from this prompt. Your results will vary.

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 in Excel & Spreadsheets