Pack Builder Agent

Auto-assembles your recurring board pack, LP update, or QBR from live data into a review-ready draft.

Updated

Connects with

Google SheetsGoogle SheetsBigQueryBigQuerySnowflakeSnowflakeRedshiftRedshiftSalesforceSalesforceHubSpotHubSpotQuickBooksQuickBooks

The problem it solves

Every reporting cycle, the days before a board meeting or LP update vanish into copy-paste assembly: opening five tabs, hunting for the right figures, pasting them into the right slots, refreshing charts, and writing a first pass of commentary. Pack Builder does that grunt work for you, dropping the latest numbers into a fresh copy of your branded template and tracing every figure back to its source. You get a review-ready draft instead of a blank deck and a long evening.

Who it's for

  • Founders preparing monthly or quarterly board decks
  • Finance and FP&A leads assembling board packs
  • VC and PE firms sending LP updates
  • Customer success managers running client QBRs
  • Consultants rebuilding recurring status decks

What it does

  1. 1

    Make a fresh draft from your template

    The agent copies your branded master template into your draft location and keeps the word DRAFT in the file name until you remove it.

  2. 2

    Pull numbers from each source

    Following your section-to-source mapping, it connects to each data source and pulls the specific metric or update for the current reporting period.

  3. 3

    Trace every figure

    It records where each number came from, including the source, the exact field or query, and the date pulled.

  4. 4

    Drop content into matching sections

    Each value lands in its mapped slot, matching the template's existing number formats, units, charts, and layout exactly.

  5. 5

    Refresh charts and tables

    It updates the underlying data so visuals refresh, and flags any chart that cannot be refreshed programmatically instead of leaving it stale.

  6. 6

    Draft the narrative

    For commentary and highlights sections it writes a first pass in your tone, grounded in the pulled numbers and tagged so reviewers see what it wrote versus what came from source.

  7. 7

    Assemble a source trace and flag list

    It produces a table mapping every number to its origin plus a list of anything a human must resolve, such as unreachable sources or missing data.

  8. 8

    Hand off for review

    It posts a summary to Slack with a link to the draft, how many sections were filled, and the open flags, then stops without sending anything.

Key benefits

  • Cuts the hours of pre-report copy-paste assembly down to a review
  • Every number traces back to its source, so audits and questions are easy to answer
  • Never fabricates a missing figure, leaving a clear [MISSING] placeholder and a flag instead
  • Your master template is never touched, so it stays clean for the next cycle
  • Matches your existing branding and formatting exactly, with no restyling
  • A human always reviews and sends, keeping board and LP reporting under your control

Sample use cases

A founder needs the monthly board deck the night before the meeting

Pack Builder pulls ARR, burn, and pipeline from Sheets, Stripe, and the CRM into a fresh copy of the deck, drafts the highlights, and hands over a traceable draft to polish.

A VC firm sends quarterly LP updates across a portfolio

It rebuilds the standard LP update template with the latest fund and portfolio numbers, flags any company that did not report in time, and posts the draft for the partner to finish.

A customer success manager runs monthly QBRs for key accounts

The agent fills the QBR deck with usage, adoption, and health metrics per account and writes a first-pass narrative, leaving the CSM to add context and present.

An FP&A lead assembles the quarterly board pack from a warehouse and QuickBooks

It pulls the period numbers, refreshes the charts, builds the source trace, and flags any value that fails a sanity check before the close review.

Key integrations

  • Google Sheets

    A common source for the metrics and tables that feed each section of the pack.

  • BigQuery, Snowflake, or Redshift

    Data warehouse tables queried for period metrics in finance and analytics reporting.

  • Salesforce or HubSpot

    CRM reports pulled for pipeline, revenue, and customer metrics.

  • QuickBooks

    Finance tool used to source actuals and accounting figures.

  • Stripe

    Payments source for revenue, MRR, and billing numbers.

  • Google Slides, Google Docs, or PowerPoint

    Where your branded template lives and where the agent saves the draft copy.

  • Slack

    Used for the review handoff and to surface flags; optional, with handoff falling back to the draft itself.

Pack Builder is built for the report you rebuild from the same sources every month, quarter, or week. By mapping one source to each section, it keeps the trace clean and makes it obvious where every number originated, which matters most for board-level and regulated reporting where an unverified figure is worse than a flagged gap.

When a source is unreachable or a value fails a sanity check, the agent leaves a clear placeholder and flags it rather than guessing. That discipline, plus an untouched master template and a human-in-the-loop handoff, is what separates a trustworthy draft from a fast but risky one.

Getting started

  1. Import the workspaceAdd the Pack Builder template into Gamut to set up the agent.
  2. Run agent onboardingThe onboarding skill launches automatically and interviews you about your pack type, data sources, template location, section-to-source mapping, cadence, and reviewers.
  3. Give it a first taskAsk it to build a draft of the pack for the most recent period and report which sources it can reach and which sections it would fill, without finalizing anything.

Frequently asked questions

What is Pack Builder?

Pack Builder is an agent that assembles your recurring board pack, LP update, QBR, or status deck by pulling the latest numbers from your data sources into your branded template. It produces a review-ready draft, making it a practical kind of investor reporting software for teams that rebuild the same report every cycle.

Does it send or present the pack without my approval?

No. Pack Builder produces a draft only and never sends, presents, or shares it with a board, LP, customer, or any external audience. A human always reviews the draft and decides when it is ready to go.

Which systems does it work with?

It pulls from Google Sheets, data warehouses like BigQuery, Snowflake, and Redshift, CRMs like Salesforce and HubSpot, and finance tools like QuickBooks and Stripe. It builds drafts in Google Slides, Google Docs, or PowerPoint and hands off through Slack.

How is this different from building the report manually or with generic tools?

Unlike copy-pasting by hand, Pack Builder pulls every figure on your cadence and traces it back to its exact source. Unlike generic dashboards, it works inside your own branded template and writes a first-pass narrative, so the draft already looks like your finished report.

Can it be used as real estate or CRE investor reporting software?

Yes. Because it maps each section to a source and rebuilds your existing template, it works well as real estate investor reporting software or CRE investor reporting software, assembling property and fund updates from your sheets, warehouse, or finance tools.

Is it free, and what does it cost to run?

The template itself is free to import, and no API keys are required since accounts connect through Gamut during onboarding. You only need your existing data sources and template; ongoing cost is your Gamut usage.