DOCUMENT OPS

Quarterly board deck assembler from KPIs, narrative, and risks

On a quarterly schedule, pulls the latest KPI tables from Snowflake, the prior-quarter narrative from Coda, and the open risk register.

CategoryDocument Ops
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerQuarterly board-prep schedule fires
  • ActionQuery current-quarter KPI table from SnowflakeSnowflakeSnowflake
  • ActionRead prior-quarter narrative from CodaCodaCoda
  • ActionPull open items from risk register in CodaCodaCoda
  • ActionAssemble versioned deck draft in Google DriveGoogle DriveGoogle Drive
  • OutputNotify board-prep channel with draft linkSlack

What it does

Automatically drafts the recurring board deck so the operator starts from a populated document instead of a blank slide. It gathers the three inputs every board pack needs — current quarter KPIs, last quarter's written narrative, and the live risk register — and lays them into a versioned deck file ready for editing.

When to use it

Run it the week before each board meeting when you want the data and prior context already in place. Best for finance or chief-of-staff teams who rebuild the same deck structure every quarter and waste hours copy-pasting numbers.

How it works

  1. 1A quarterly schedule fires the workflow on the board-prep date.
  2. 2It queries Snowflake for the current-quarter KPI table (revenue, retention, burn).
  3. 3It reads the prior-quarter narrative section from the board Coda doc.
  4. 4It pulls all open items from the risk register table in Coda.
  5. 5It assembles a new versioned deck draft in Google Drive, slotting KPIs, last-quarter narrative for continuity, and the risk list onto their respective slides.
  6. 6It posts a Slack message to the board-prep channel with the draft link and a checklist of sections still needing human input.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SnowflakeWarehouses, queries, shares.
  2. 2
    Connect CodaDocs, packs, automations.
  3. 3
    Connect Google DriveDocs, sheets, slides, files.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.