Apollo as the orchestrator, not the data source: how we built a renewal journey for our AM team
Most people think of Apollo as a data platform. You go there, pull contacts, get account info, move on...but we built something a little different.
I work on the AI team at Apollo and I just finished putting together a journey-based renewal series for our account managers that uses Apollo as the actual orchestrator of the whole workflow and not just the data source.
Here's how it works:
The anchor: Salesforce
We pull contract end dates from Salesforce and use those as the anchor for everything downstream. From there, Apollo kicks off a series of timed flows that notify the AM at the right moments leading up to the renewal.
At each stage, four things happen in sequence:
- Apollo runs AI research on the account and surfaces strategic guidance: who to reach out to, how to position the conversation, what the renewal narrative should be.
- The right contact (the admin at the account) gets enrolled into a sequence automatically.
- A Slack message goes out to a shared channel where the AM and their manager can both see it.
- That Slack message includes a link to the account, what the rep needs to do, the AI guidance, and a direct link to the sequence task.
The interesting part: the Claude project
The Slack message also links to a Claude project that is connected to Snowflake data and Apollo's MCP. The rep opens it, pastes in a prompt, and Claude generates the actual artifact (executive brief, 6-month EBR, or end-of-year EBR) and handles creating the Google Slide deck.
Here is what the actual Slack notification looks like:
u/Account Manager. Contract ends on [Date]. Time to send the Executive Brief
to [Account Name].
AI strategic guidance on who to reach out to and how to position the brief:
Strategic angle: With [X] seat upside identified and a team actively ramping
new reps, this check-in is best positioned around ensuring the team has the
foundation to hit pipeline targets as the renewal approaches. Demonstrating
measurable outbound progress from the ramp investment strengthens the
renewal narrative.
Who to reach out to: Reach out to [Contact Name]. They are directly
overseeing end-user ramp sessions and have visibility into team performance
and capacity gaps that justify expanding the seat count.
Next steps:
1. Review the contact added to the sequence via the link below
2. Replace [email] with the correct recipient
3. Prompt Claude with: "Executive summary for [Account ID] to [email]"
Sequence task: [link]
Claude Project: [link]
Prerequisites: Snowflake access approved, Snowflake MCP connected,
Apollo MCP connected.
The whole thing is measurable! Contacts are in sequences, tasks are logged, reps have a clear action every time they get pinged.
Happy to share the Claude project file if anyone wants to set up something similar. Drop a comment.
Noah