# Quarterly review decks in Google Slides for every top household

> On the last business day of each quarter, generate a personalized Google Slides review deck for every top-tier Addepar household and drop links in your advisor Slack channel.

- Workflow type: agent
- Services: Addepar, Google Slides, Google Drive, Slack
- Categories: Finance, Operations
- Published: 2026-07-17

## What it does

- Pulls quarterly performance, allocation, and top-position data from Addepar for every top-tier household
- Builds a personalized Google Slides deck per household with cover, performance summary, allocation breakdown, top movers, and talking points
- Saves each deck into a per-household folder in Google Drive so review materials stay organized
- Posts a single Slack summary in the advisor channel with links to every deck, ready for pre-meeting review

## What you'll need

- An Addepar login with access to the households you want reviewed
- A Google account that can create presentations, folders, and files in Google Drive and Google Slides
- A Slack workspace and the name of the advisor team channel where the summary should be posted
- A rule for what counts as top-tier (an Addepar tier tag or an AUM threshold)

## Prompt

On the last business day of every quarter at 6am, generate a personalized quarterly review deck in Google Slides for every top-tier household in Addepar, save it into a per-household folder in Google Drive, and post a summary in the advisor team Slack channel with links to every deck so advisors can review before their quarterly client meetings.

Step 1 — Pick the households. Call Addepar List Entities and filter to the household (or client) entities that qualify as top-tier: for example, households flagged as tier 1 / A-tier in Addepar, or households above a configurable AUM threshold. If the firm tags households with an advisor attribute, keep that on each record so I know who owns the client.

Step 2 — Pull quarterly performance per household. For each qualifying household, call Addepar Query Portfolio Data for the trailing quarter with the columns advisors actually present in reviews: time-weighted return, benchmark return, net contribution/withdrawals, ending market value, asset-class allocation, and the top ten positions with weight and quarterly P&L. Query Portfolio Data has a 60-second sync limit — if a household times out, retry using Submit Async Portfolio Job (submit, poll for completion, then download the results) so very large households still complete.

Step 3 — Build the deck. Use Google Slides Create a Presentation to spin up a new deck titled with the household name and quarter. Then use CreateSlide, CreateShape, and CreateTable to lay out: (a) a cover page with the household name, quarter, and advisor; (b) a performance summary slide showing quarterly return vs benchmark and ending market value; (c) an allocation breakdown table by asset class; (d) a top movers slide listing the three best and three worst positions this quarter by dollar P&L; and (e) a talking-points slide.

The talking-points slide is the whole point — do not use templated boilerplate. Write three to five bullets that reference this specific household's actual movers, largest holdings, allocation drift versus target, and any notable contributions or withdrawals from the quarter. If the household lost ground to its benchmark because one concentrated position dragged, say that. If cash built up meaningfully, flag it. Every bullet must be grounded in numbers from that household's own Query Portfolio Data results.

Step 4 — File the deck. For each household, use Google Drive Create Folder to make a per-household folder (e.g. "Q3 2026 Review — Smith Family") under a shared parent folder the advisor team already uses, then move the presentation into that folder so review materials stay organized household by household.

Step 5 — Notify the team. Use Slack Send a Message to post a single roll-up in the advisor team channel: total households prepared, and a bulleted list with each household name, the owning advisor (if known), and a link to the deck. Keep it scannable so advisors can click into their own clients and start reviewing.

If a household has no advisor tagged, still generate the deck and list it under an "unassigned" section in the Slack summary. If Query Portfolio Data fails for a household even after the async retry, skip the deck and list that household under a "needs manual pull" section so nothing falls silently.

## How to customize

- Change the cadence or the time of day the decks are generated
- Adjust which households qualify as top-tier (tier tag, AUM cutoff, custom Addepar attribute)
- Tune the talking-points guidance: how many bullets, what advisors should highlight, tone for the client
- Point the decks at a different Drive parent folder or Slack channel

## FAQ

### Does every household get the same slide template?

The structure is consistent (cover, performance, allocation, top movers, talking points) so decks feel branded and predictable, but the talking-points slide and the numbers on every other slide are specific to that household — pulled straight from their own Addepar performance for the quarter.

### What happens if a household is too big to query in one shot?

Addepar's synchronous query has a 60-second limit. If a household hits it, the workflow retries using Addepar's async portfolio job — submit, poll, download — so large households still complete without the whole run failing.

### Can advisors edit the decks before their client meetings?

Yes. The decks land in Google Slides in a shared Drive folder, so advisors can tweak wording, add commentary, or drop in extra slides before their quarterly meetings. The Slack summary just gives them the starting point.

### Do we have to run this every quarter, or can we test it on one household first?

You can run it on demand against a single household to sanity-check the layout and the talking points before switching the quarterly schedule on.

### What if a household doesn't have an advisor tagged in Addepar?

The deck still gets generated. In the Slack summary it shows up under an "unassigned" section so someone on the team can claim it before the client meeting.

Use this prompt in General Input: https://www.generalinput.com/prompts/quarterly-review-decks-in-google-slides-for-every-top-household