Send Pendo Aggregation Data in an Email

Last updated Wed Sep 07 2022

Set yourself up for success with this solution, which includes:

  • Easy to follow configuration steps for the connecting to the Pendo Aggregation API endpoint via the HTTP Client Connector
  • An example JSON Payload that requests the top active accounts
  • Method for creating a .xlsx files to be sent out via the Email Connector


Pendo gives its users powerful insights into data involving if their products are being used and if so, by whom. The same aggregation database that powers the data visualization in Pendo is available to you through an API endpoint and can be used to access data in a number of different ways.

This recipe starts with offering a sample JSON payload that looks to pull back the top ten active accounts within a Pendo organization. From there, the data that is received is compiled into a .xlsx file and is added as an attachment to be sent in an an email of your choosing.

The Pendo Aggregation API endpoint allows users to take sources of Pendo data and apply operators to do computations. Start automating simple and complex Pendo data operations with the help of Boomi today!

Related Solutions


Send a Welcome Email to New Visitors Created in Pendo

Create a listener for Pendo new visitor data and send them a welcome email!
Learn more


Start Connecting Pendo with Slack

Create a Slack message containing new visitor information from Pendo!
Learn more


Start Connecting Pendo with Salesforce

Create leads in Salesforce from Visitor Reports created in Pendo!
Learn more