How to Turn a Client KPI Export Into a Quarterly Business Review Deck With NotebookLM

The problem and who this is for

You need a quarterly business review deck that shows results, explains what changed, and opens the door to more work. Most freelancers delay this because the data lives in too many places: analytics exports, project trackers, approval emails, and scattered notes.

This is for freelancers and consultants who already send recurring updates, own a monthly retainer, or want a clean way to frame a renewal or expansion conversation.

Prerequisites

• A NotebookLM account.
• One KPI export for the review period in CSV, XLSX, or Google Sheets format.
• A short win log or deliverables list for the same period.
• Any client goals, original scope notes, or kickoff summary that explains what success was supposed to look like.
• A presentation tool for final delivery if you want to restyle the deck after generation.

How to capture or gather the source material

1. Export the metrics for one clearly defined period. Quarterly business review decks fall apart when the date range changes across sources. Use one quarter or one fixed 90 day span and name the file clearly, such as q1-2026-kpis.csv.
2. Create a one page wins document before you upload anything. Include major deliverables shipped, decisions approved, deadlines met, and any client-visible milestones.
3. Pull in the original goals. If the client said the project was meant to increase leads, shorten turnaround time, or improve conversion quality, capture that in a short note. NotebookLM is much more useful when it knows what the client cared about, not just what happened.
4. If your KPI export is messy, clean column names first. Replace vague headers like metric_1 or custom_12 with plain labels. Remove hidden tabs, duplicate totals, and irrelevant columns.
5. If your reporting data is split across tools, do a simple merge outside the AI tool first. One clean sheet beats five half-related uploads.

Step-by-step workflow

1. Create a notebook for the account or project. Upload the KPI export, the win log, and the goal or scope note as separate sources.
2. Ask NotebookLM for a plain-English briefing document first, not a deck. The goal is to pressure test the narrative before you spend time on slide structure.
3. Review that briefing for three things: whether the main outcomes are accurate, whether the causal story is believable, and whether any metric claims are missing timeframes.
4. Once the narrative is solid, generate a Slide Deck from the same notebook. Give NotebookLM explicit instructions about audience, tone, and slide count.
5. Revise the deck before sending it. Tighten slide titles, remove weak claims, and add or trim slides as needed. NotebookLM can revise slide text and layouts, but it does not support adding or removing slides during revisions, so regenerate a fresh deck if the structure is off.
6. Download the deck as a PDF if you want a quick sendable version. If you need your own branding, move the deck into Google Slides, PowerPoint, or another presentation tool and restyle there.
7. End with a next-quarter section that is tied to the evidence in the sources. This is where retention and upsell happen. Do not bolt on random add-on ideas. Recommend the next phase that logically follows from the results and open gaps.

Tool-specific instructions

NotebookLM

• Use NotebookLM as the primary workflow because it can take multiple sources, generate reports, and generate Slide Decks from the same source set.
• Start with a briefing document. That lets you check the story before you generate slides.
• Then generate the Slide Deck in the Studio panel. You can customize format, language, length, and prompt guidance before generation.
• Use a clean prompt that tells NotebookLM to separate results, interpretation, and next-step recommendations.

Gemini

• Gemini is a good fallback if you want fast multi-file analysis and a draft outline you can export to Docs.
• Upload the KPI file, win log, and goals note together. Ask for an 8 to 10 slide outline first, then expand each slide.
• Gemini is useful when you want a strong first draft but plan to build the final slides yourself.

ChatGPT

• ChatGPT works well if you want to upload the files, draft the narrative, and then manually build the deck in your slide tool.
• Use ChatGPT when you want more back-and-forth iteration on slide titles, objections, or speaking notes.
• If you use screenshots instead of a spreadsheet export, ChatGPT can still help, but a real export usually produces cleaner claims.

Claude

• Claude is useful when you want a polished narrative or a downloadable presentation file. It supports uploads and can create PowerPoint files when code execution and file creation are available.
• Use Claude after you already know the core story. It is best as a drafting and packaging fallback here, not the source-grounded first pass.

Copy/paste prompt blocks

NotebookLM deck brief

{
  "role": "client_reporting_analyst",
  "goal": "Create a source-grounded quarterly business review narrative from the uploaded KPI export, win log, and project goal documents.",
  "audience": "existing client decision-maker",
  "instructions": [
    "Use only information supported by the uploaded sources.",
    "State the reporting period clearly.",
    "Separate three things: results, what those results likely mean, and what should happen next quarter.",
    "Flag weak or incomplete evidence instead of guessing.",
    "Pull out 3 to 5 proof points that show value delivered.",
    "List any missing metrics or unanswered questions that should be resolved before the deck is sent."
  ],
  "output_format": {
    "sections": [
      "executive_summary",
      "top_results",
      "work_completed",
      "risks_or_gaps",
      "recommended_next_quarter_focus"
    ]
  }
}

NotebookLM slide deck prompt

{
  "role": "quarterly_business_review_deck_builder",
  "goal": "Generate a client-ready slide deck from the notebook sources.",
  "instructions": [
    "Create 8 to 10 slides.",
    "Use direct slide titles that state the point of each slide.",
    "Include one slide on goals, one on results, one on work completed, one on risks or open gaps, and one on next-quarter recommendations.",
    "Avoid marketing fluff and avoid unsupported claims.",
    "Make the final slide a practical next-phase recommendation tied to the evidence."
  ],
  "style": {
    "tone": "plain_english",
    "audience": "busy_client_leadership",
    "length": "default"
  }
}

Quality checks

• Every metric has a timeframe.
• Every claim of impact can be traced back to a source.
• The deck does not confuse activity with outcomes.
• The next-quarter recommendation follows naturally from the evidence instead of feeling like a generic upsell.

Common failure modes and fixes

The deck feels vague

Upload the original goals note and ask for a briefing document first. Vague decks usually come from missing context about what success meant.

The metrics look impressive but do not support the story

Rewrite the win log so it explains which deliverables mattered and why. Then regenerate.

The deck is too long

Regenerate with an explicit 8 slide limit and remove detail-heavy appendices from the source set.

The upsell slide feels pushy

Reframe it as a logical next-phase plan linked to open gaps, risks, or opportunities named in the reporting period.

Sources Checked

• Google NotebookLM Help - Create a notebook in NotebookLM: https://support.google.com/notebooklm/answer/16206563 (accessed 2026-03-24)
• Google NotebookLM Help - Add or discover new sources for your notebook: https://support.google.com/notebooklm/answer/16215270 (accessed 2026-03-24)
• Google NotebookLM Help - Generate a Slide Deck in NotebookLM: https://support.google.com/notebooklm/answer/16757456 (accessed 2026-03-24)
• Google Gemini Apps Help - Upload & analyze files in Gemini Apps: https://support.google.com/gemini/answer/14903178 (accessed 2026-03-24)
• Google Gemini Apps Help - Export responses from Gemini Apps: https://support.google.com/gemini/answer/14184041 (accessed 2026-03-24)
• OpenAI Help Center - File Uploads FAQ: https://help.openai.com/en/articles/8555545-file-uploads-faq (accessed 2026-03-24)
• Claude Help Center - Uploading files to Claude: https://support.claude.com/en/articles/8241126-uploading-files-to-claude (accessed 2026-03-24)
• Claude Help Center - Create and edit files with Claude: https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude (accessed 2026-03-24)

Quarterly Refresh Flag

Review this article by 2026-06-22. Re-check tool capabilities, source limits, mobile support, export behavior, and any changes to file upload or output features before republishing unchanged.