Retrieve Sales Sequence emails

[CCrafton]

Hello,

My team is using Sales Sequences to send emails. We would like to retrieve the emails sent and replies received that are related to a specific sequence. To do this now, I am querying for 

hs_sequences_enrolled_count to get the contacts for a sequence, and then pulling the email history. I then have to make api requests per contact to get the email history which is way to expensive at scale.

Is there a better way to fetch the emails for a specific sales sequence ID?

[RubenBurdin · Accepted solution]

Hi @CCrafton  this is a great question and you’re not the only one running into the “too many API calls per contact” wall with sequences.

Right now there isn’t a first-class API that says “give me all emails and replies for sequence X” in a single query. The Sequences API beta will let you list sequences, inspect a given sequence, and manage enrollments, but it stops at configuration and status, not engagement events like individual sends or replies (https://developers.hubspot.com/docs/api-reference/automation-sequences-v4/guide )

On the flip side, the reporting layer in the UI lets you analyze reply/open/click metrics per sequence, but that’s exposed as sequence analytics rather than raw email objects you can pull programmatically (https://knowledge.hubspot.com/sequences/analyze-sequence-enrollment-and-performance-data )

So what you’re doing now, using sequence-related properties or enrollments to find the relevant contacts and then digging into their email history, is unfortunately still the standard pattern if you need message-level detail. You can soften the load a bit with batch read/search on email engagements plus some caching, but there isn’t an officially supported shortcut by sequenceId today. If the real need is to centralize sequence email activity in another system at scale, Stacksync can mirror HubSpot engagements and contact data into your source of truth so you query once there instead of fanning out calls per contact.

[CCrafton]

@RubenBurdin  Thank you!! Yes, I do need the email objects. I will investigate further and look at StackSync.

[CCrafton]

Thank you, @Jaycee_Lewis. 
@MichaelMa @GiantFocal  @ShubhamPradhan do you have any other thoughts on a possible solution?

Thank you!

[Jaycee_Lewis]

Hi, @CCrafton 👋 Thanks for your question. I'd like to invite some of our community members to the conversation —  hey @MichaelMa @GiantFocal  @ShubhamPradhan do you have any thoughts on more efficient queries? — Jaycee