Daily Addepar cash drift sweep to Sheets and Slack

Every weekday at 8am, sweep Addepar for cash-position drift across every household I cover and drop the exceptions into a Google Sheet plus a Slack summary for our ops channel. This is a deterministic pipeline — list, filter by threshold, dedupe, append, notify — so build it as a code workflow with a cron trigger.

Expose these as workflow inputs so ops can tune them without editing the workflow: the saved Addepar portfolio view slug or ID, the upper cash-dollar threshold (idle-cash trigger), the lower cash-dollar threshold (drawdown-risk trigger), the target Google Sheet ID and tab name, and the target Slack channel ID.

Step 1: pull the data. Call Addepar's Get Portfolio View Results against the configured saved view. The view is set up in Addepar to include columns for Household, Advisor, Total Value, Cash Balance, and Cash Percent.

Step 2: drop closed or dormant entities. Call Addepar's List Entities for the households referenced in the view results and skip any whose status is closed or dormant before applying thresholds.

Step 3: filter deterministically. For each remaining household, flag it as an idle-cash exception if Cash Balance is above the upper dollar threshold, or as a drawdown-risk exception if Cash Balance is below the lower dollar threshold. Households inside the band produce no row.

Step 4: dedupe against yesterday's rows. Before writing, use Google Sheets Get Values to read the existing rows in the log tab. If a household already has a row from yesterday with the same Reason (idle cash vs drawdown risk), skip it. If the reason flipped, or the household is new, write a fresh row.

Step 5: append. Use Google Sheets Append Values to add one row per new exception with columns Household, Advisor, Cash Balance, Cash Percent, Reason (idle cash or drawdown risk), and Date (today, in the firm's time zone).

Step 6: post one summary. Use Slack Send a Message to post a single message to the configured ops channel with the count of idle-cash exceptions, the count of drawdown-risk exceptions, the total households scanned, and a link to the Google Sheet. If there are zero new exceptions, still post a short 'all clear' message so the team knows the sweep ran.

Keep everything human-readable: format dollar amounts with commas, format percentages to one decimal, and never post per-household details in Slack — the sheet is the source of truth, Slack is just the heads-up.