Weekly Addepar concentration watchlist to Notion and Gmail

Every Monday at 9am, sweep every Addepar household for concentration risk and maintain a live Notion Concentration Watchlist that the investment and compliance teams share. This workflow is monitoring only — it must never place trades or adjust allocations.

Start in Addepar. Use List Entities to enumerate every household (client-level entity) I have access to. For each household, use List Positions to get the current owner-to-holding relationships, and then Query Portfolio Data to pull position-level market values, single-security weights, and sector weights as a share of household AUM. Prefer a single Query Portfolio Data call per household grouped by security and by sector rather than many small calls.

Apply two configurable thresholds. The defaults are 10 percent for any single security as a share of household AUM and 25 percent for any single sector as a share of household AUM. Both should be easy to change without touching the rest of the workflow. Every position that exceeds either threshold is a candidate for the watchlist.

Maintain the watchlist in a shared Notion database called Concentration Watchlist with columns for Household, Position (security or sector name), Current Weight, Threshold Breached (single-security or single-sector), Assigned Portfolio Manager (person or email), Status (active or resolved), and Last Checked timestamp. For each candidate, use Notion Query a Data Source to look up an existing row matched by household plus position. If one exists, use Update a Page to refresh the current weight, status, and last-checked timestamp. If it does not exist, use Create a Page to add a new row with status 'active'. Positions that were previously flagged but are now back under the threshold should have their row updated to status 'resolved' with the new weight and timestamp — do not delete rows, since the watchlist doubles as a compliance audit trail.

When a position crosses a threshold for the first time compared to the prior run (that is, this run creates a new row, or transitions a row from resolved back to active), also send the assigned portfolio manager a Gmail alert with Send a Message. The email should be a one-paragraph summary naming the household, the security or sector, the current weight, which threshold was breached, and a direct link to the Notion page for that row. Do not send an email when an already-active row is simply being refreshed with a new weight — portfolio managers should not be spammed every Monday for the same position.

Keep the tone factual. No trade recommendations, no rebalancing suggestions. The workflow's job is to surface concentration and hand it to a human.