HubSpot is a business-critical platform for contact management (CRM), marketing, sales, and...
HubSpot is a business-critical platform for contact management (CRM), marketing, sales, and customer service. The reports and dashboards available in HubSpot make it simple to measure and report on KPIs in all of these business units. In fact, I use them every day! Once you have built reports or dashboards in HubSpot, you may want to insert those charts into presentations and reports. Unfortunately, there was no way to easily export HubSpot charts to Google Slides, PowerPoint, or other documents, until Slideform!
Slideform integrates the data you need directly into your custom presentations & reports. This is especially useful for reports that you create on a recurring basis each month or week. Let's see how to use Slideform to put your reporting on auto-pilot!
How to embed HubSpot charts into Google Slides or PowerPoint
Slideform uses automation to map your HubSpot charts directly to your pre-formatted slides. You can embed multiple charts and combine HubSpot with other data sources as well. For a weekly or monthly report, you can generate a new presentation with updated data on a schedule.
-
Connect your HubSpot dashboard
Slideform uses the HubSpot dashboard emails to capture the charts from your dashboard for use in reports and presentations.
In Slideform, go to Data Sources > Add Data Source and click Add Integration under HubSpot. You will need to set up dashboard emails in HubSpot and then auto-forward those emails to the Slideform system.
Once the data is connected, you can view, rename, and manage all your charts in Slideform. -
Link your report template
Create a template for your report in Google Slides or PowerPoint. The template is a repeatable presentation with placeholders where you want to insert the charts or other content. The template specifies the colors, formatting, and layout that you want in each version of the presentation. This is an example template.
Each placeholder in the template will be filled with content from one of your linked Data Sources, including HubSpot dashboards. Chart and table placeholders must be associated with a shape in the template to set the size and placement of the content on the slide. Read more about the slide template: How to create a slide template
Upload your PowerPoint template in the New Project menu in Slideform, or Authorize your Google account to access your Google Slides and select the correct presentation. -
Send data to the slides
The final step is to match the correct content from HubSpot to each placeholder in your template.
Go to the Data Sources page and click Configure. Then, in the Charts section, select the worksheet (name of your dashboard) and click Preview. This will display each of the charts available for embedding.
You can rename the charts, click the star to "favorite", and send the chart to the slides from this page. To send a chart to your project, click the airplane "send" icon.
In the popup, select the project and slide to embed the chart. For more information about data mapping, see: How to Configure the Data Mapping -
Generate presentations and reports automatically on a schedule
You can generate a presentation with updated data any time you want by clicking the Generate button. Or set a schedule and have the slides emailed to you or another recipient.
Here is an example of my slides with content filled in from HubSpot:
To export the charts to Word, Excel, Google Docs, or Sheets, just create a template in that format. Step through an example here.
Slideform puts your reporting on auto-pilot!
- No screenshots! And no copying & pasting.
- Set recurring presentations to auto-generate on a schedule!
- Slides are viewable by all recipients; no HubSpot access required.
- Data (charts, graphs, tables) automatically update when you generate a presentation.
- Combine HubSpot with other data sources and content including spreadsheets, images, and text.
- Use your own custom slide template in the format of your choice.
Did you know? Slideform can also embed HubSpot CRM data (metrics, numbers, text) into your reports. Check it out here.
Start your free Slideform trial today!
