How to Auto-Generate Meeting Agendas from Portfolio Data

The meeting agenda writes itself when your portfolio data is connected.

That's the premise. Here's the execution.

Most RIAs have everything they need to run a great client review: transaction history in the custodian portal, a living financial plan in eMoney or MoneyGuidePro, CRM notes going back years, and a task list of open action items. The problem isn't the data. It's that none of it moves on its own.

The advisor — or more often their CSA — manually opens each system, assembles the relevant information, formats it, and gets it ready before the meeting. When we ask advisors to time this step, the reported median is 25-40 minutes per review meeting. For a firm running 80-100 review meetings per quarter, that's 35-65 hours of assembly work per quarter. None of it requires judgment. All of it requires time.

This guide builds the workflow to make that assembly automatic.

What the Auto-Generated Agenda Contains

Before building the workflow, define what "done" looks like. A complete auto-generated meeting agenda for a client review should include five components:

Account summary — Current portfolio value, allocation, and recent significant transactions (from Schwab, Fidelity, or Pershing)
Financial plan status — Open goals, upcoming milestones, gaps from plan targets (from eMoney or MoneyGuidePro)
Recent meeting history — Summary of last two to three meeting outcomes and unresolved discussion items (from Redtail or Wealthbox)
Open action items — Tasks assigned to the advisor, client, or CSA that are still pending
Pending documents — DocuSign envelopes awaiting signature or documents outstanding from the client

This is the Five-Source Agenda: custodian + planning software + CRM notes + task list + pending documents. When all five are populated, the advisor walks in already briefed.

The Five-Source Agenda System: Step-by-Step

Step 1: The Meeting Trigger

The workflow starts when a client review meeting is created or confirmed on the calendar.

Redtail CRM: Use a workflow rule tied to activity type = "Client Review" and status = "Scheduled." Set the workflow to fire 48 hours before the meeting date. Redtail's native workflow engine handles this without Zapier — the trigger fires, passes the contact ID and meeting date to the next step, and the workflow proceeds.

Wealthbox CRM: Wealthbox does not have a native equivalent to Redtail's workflow rules. Use a Zapier trigger on new calendar events matching "review" or "annual" in the event name. This requires a Zapier Business plan for multi-step Zaps. Alternative: the Wealthbox API exposes an events endpoint that can be polled by a scheduled job.

Both approaches produce the same output: a trigger containing the client ID, advisor name, and meeting date that kicks off the remaining steps.

Step 2: Pull Account Data from the Custodian

This is where most DIY automation efforts stall. Schwab, Fidelity, and Pershing all provide API access, but the requirements differ.

Schwab Advisor Services: The Schwab Advisor Services API uses OAuth 2.0 and provides account balance, position, and transaction data. Access requires enrollment in the Schwab API program, available to RIAs with a primary custodian relationship. Pull: account value, asset allocation breakdown, last 30-day transactions filtered by amount threshold.

Fidelity Wealthscape: WealthscapeAPI provides similar capabilities under an approved data aggregation agreement. Pull: account summary, performance vs. benchmark for the period, pending or recently settled transactions.

Pershing NetX360: API access through BNY Mellon's infrastructure. More restrictive direct access; commonly handled through intermediaries like Envestnet | Tamarac or Orion, which expose their own APIs with normalized data across custodians.

For firms not yet enrolled in direct custodian APIs, data aggregators (Orion, Tamarac, Riskalyze) often act as intermediaries with Zapier integrations or well-documented REST APIs — a lower-friction entry point.

Step 3: Pull Financial Plan Status

eMoney: eMoney's API is available to enterprise subscribers and provides read access to client plan data including goal status, net worth summary, cash flow projections, and scenario comparisons. Query: open goals, projected shortfalls, recent plan changes. Output: a two to three sentence status summary — "Plan is tracking at 91% probability for retirement goal. Life insurance gap identified in last review remains open."

MoneyGuidePro: Supports data export through their integration layer. API access varies by subscription tier. Zapier integration is available for basic event triggers and summary exports. For firms on standard tiers, a scheduled export to a shared folder combined with an automated parsing step is a practical alternative to direct API access.

Step 4: Summarize CRM Meeting History

Redtail: The Redtail API's activity and notes endpoints return timestamped entries per contact. Query the last three meeting notes. Pass the raw text to a summarization step — either a templated format ("Last meeting covered X, Y, Z; open items: A, B") or an LLM API call for natural language output.

Wealthbox: The notes endpoint returns similar data. The Wealthbox data model is contact-centric, which makes it straightforward to retrieve all notes for a given contact ID sorted by date.

The output target: three to five sentences covering the main themes from recent meetings, any decisions made, and open items that were not resolved.

Step 5: Pull Open Tasks and Pending Documents

Tasks: Both Redtail and Wealthbox return open tasks filtered by contact ID. Include tasks assigned to any team member associated with this client — advisor, CSA, paraplanner.

DocuSign: The DocuSign Envelopes API returns envelope status by recipient email address. Query for envelopes in "sent" or "delivered" status (meaning the client has not yet signed). Output: a list of document names and the date they were sent.

Step 6: Assemble and Deliver

With all five sources populated, assemble the agenda into a formatted document and deliver it:

Format: Structured HTML email works best for advisors who live in their inbox. Alternatively, Markdown rendered to PDF for firms that prefer file-based delivery.
Timing: Deliver 24 hours before the meeting, not same-day. The advisor needs time to review and adjust.
Destination: Advisor's inbox as primary. CRM as a pinned note on the contact for record-keeping.

Redtail vs. Wealthbox as Trigger Source: Comparison

Feature	Redtail	Wealthbox
Native workflow automation	Yes (built-in engine)	No (requires Zapier)
API access	REST API available	REST API available
Meeting type filtering	Native (activity type field)	Via event name matching (Zapier)
Multi-step workflow support	Native	Zapier Business plan required
Task management depth	Strong (categories, assignees, due dates)	Moderate
Ease of API integration	Moderate	Easier (cleaner data model)

For firms on Redtail, building this workflow natively is practical without additional middleware. For firms on Wealthbox, Zapier adds cost and a dependency, but the Wealthbox API is well-documented and the REST implementation is cleaner for custom builds.

What Changes When This Works

When advisors stop spending pre-meeting time assembling data, two things happen.

First, prep quality improves. Time previously spent pulling information shifts to thinking about it. The advisor who used to open Schwab 20 minutes before the meeting now opens the agenda and thinks about what to say to this specific client about their specific situation.

Second, CSA capacity opens. The assembly work that typically falls to the CSA — when the advisor doesn't do it themselves — is often the task they're best positioned to eliminate. A CSA who isn't assembling meeting briefs can handle more advisors, process paperwork faster, and spend their time on work that requires judgment rather than logistics.

Clients notice both of these things. Not the workflow. The outcome of the workflow.

Frequently Asked Questions

Does auto-generating meeting agendas require custom development?

It depends on your tech stack and how connected your systems already are. Firms on Redtail with Schwab and eMoney can build a version using Redtail's native workflow engine plus Zapier for custodian and planning data pulls. A fully connected version across all five sources — including LLM-based summarization and CRM write-back — typically requires development work or a platform like Systemaic that handles the integrations end to end.

Is the client data involved in this workflow secure?

Yes, when built correctly. The workflow reads from existing secure systems (CRM, custodian portal, planning software) and writes to internal channels (advisor inbox, CRM notes). No client data leaves your environment or passes through unsecured third-party services, provided you're using APIs with proper authentication and your orchestration layer operates within your infrastructure or a compliant cloud environment.

How is this different from what my CRM already does?

Most CRM meeting prep features show you the client's profile and past notes. The Five-Source Agenda pulls live data from the custodian and planning software at the time of the meeting — so account values, plan status, and pending documents reflect current reality, not what was last synced. That's the difference between a static profile and a dynamic briefing.

Key Takeaways

Manual meeting agenda assembly takes a reported median of 25-40 minutes per client review at most RIAs
The Five-Source Agenda System draws from five data sources: custodian, planning software, CRM notes, task list, and pending documents
Redtail supports native workflow triggers for this automation; Wealthbox typically requires Zapier or direct API work
Schwab and Fidelity both offer API access for enrolled RIAs; Pershing is commonly handled through aggregators like Orion or Tamarac
eMoney supports API access for enterprise subscribers; MoneyGuidePro integration is available through their integration layer or Zapier

Ready to build this workflow for your firm? Book a discovery call with the Systemaic team.