Daily Addepar cash drift sweep to Sheets and Slack

PromptCreate

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.

What does this prompt do?

Runs a saved Addepar portfolio view each weekday at 8am and pulls cash balances for every household you cover
Flags households whose cash sits above the upper dollar threshold (idle cash) or below the lower dollar threshold (drawdown risk)
Appends each new exception to a Google Sheet with household, advisor, cash balance, cash percent, reason, and date
Skips closed or dormant households and avoids re-flagging the same household unless its state actually changed
Posts a single Slack summary to your ops channel with counts by exception type and a link back to the sheet

What do I need to use this?

An Addepar login with access to the household portfolios you cover
A saved Addepar portfolio view whose columns include household, advisor, total value, cash balance, and cash percent
A Google Sheet you can edit, with a header row for household, advisor, cash balance, cash percent, reason, and date
A Slack workspace and the channel where the ops team should see the daily summary

How can I customize it?

Set your upper and lower cash thresholds (in dollars) so the workflow matches your firm's cash-management policy
Swap in a different saved portfolio view, Google Sheet, or Slack channel without touching the underlying logic
Change the schedule (e.g. Monday only, or twice a day) or the wording of the Slack summary

FAQs

What counts as a cash-drift exception?

Any household whose current cash balance sits above your upper dollar threshold (idle cash that could be deployed) or below your lower dollar threshold (drawdown risk that could leave the account short). Both numbers live in the workflow settings so ops can tune them without editing anything.

Will the same household get flagged in the sheet every single day?

No. Before appending, the workflow reads yesterday's rows in the sheet and only writes a household if it wasn't already flagged, or if its state changed (for example the cash number crossed the other threshold). That keeps the sheet a useful log instead of a wall of repeats.

What happens with closed or dormant households?

They are skipped. The sweep pulls the household status alongside the cash numbers and drops anything marked closed or dormant before applying the thresholds.

Does this touch client-facing communications?

No. Everything the workflow writes goes to your internal Google Sheet and your internal Slack ops channel. Clients never see it.

Do we need to be on any specific Addepar plan?

You need a login that can run the portfolio view you point the workflow at. If you can open the view manually in Addepar and see household, advisor, total value, cash balance, and cash percent, you're set.

Related templates

Auto-fix your calendar when a flight slips, and flag what's at risk

When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.

Agentic Task

Trace phishing emails to the sending IP and report abuse

Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.

Agentic Task

Weekly Amazon S3 bucket security audit posted to Slack

Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.

Agentic Task

Turn procurement portal tenders into CRM deals each morning

Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.