Search for Hubspot Data in Confluence

1. Embedding HubSpot Content

To include HubSpot content into any of your Confluence pages, you need to switch to the edit mode of the page first.
Type /Hubspot on the page ...

... or use the macro menu ...

 to open the configuration:

2. Choose Element Type

Hubspot CRM for Confluence allows you to query data by three types of elements:

  • Contact
  • Company
  • Deal

Within these elements, you can view and search data from their corresponding columns

  • Contact: Name, Email, Phone Number, etc
  • Company: Name, Industry, Country, etc
  • Deal: Deal Name, Deal Stage, Associated Contact, etc

Alternatively, you can choose All Elements to view corresponding data from all three (Name, Company, Deal).

The lists include all HubSpot default properties and custom-defined properties selected on the initial configuration.


3. Choose a search term

A search will look for results that match a string or partial string of data from all of the columns within an element

For example, in the below query we searched “ha” for all elements and although it was a partial string, it matched data from the Contacts: Name and Email columns as well as Company’s Name column



Special Searches:

  • * queries all data 
  • *string queries data that contains the string
    • example: *ry will populate the string harry

Embedding Hubspot data

1. Selecting Data:

After performing a search, results can be selected and embedded directly or you can perform another search and add more data to embed.

Simply click on the data you want to select and it will be added to a list at the top of the macro

In the example below, Harry Potter has been selected and added to the Selected Contacts

2. Adding more data to Selected contacts

Once data is selected and added to the Selected Contacts list, another search can be performed and data from that search can additionally be added to the Selected Contacts list.

3. Deselecting Data:

Selected data can be deselected from the Selected Contacts list by unchecking the tick box icon on the left of each individual row of data.

By unchecking the check box, Hermine is removed from the Selected Data list.

4. Selecting Multiple Element types:

Because elements have different data columns, you can’t select rows from different elements and add them to the same Selected list.

If you want to add more than one type of element to the same Confluence page, you must save the embedded data and then add the different element type from a new Hubspot macro menu.

5. View on page:

After configuring the macro and closing the edit window, you can view the data on your confluence page.

In this view, some data are clickable and redirects to a new tab:

  • A contact-, company, or deal name redirects to the corresponding element in your Hubspot account.
  • Email opens your email app with the email address.
  • Phone Number opens your phone app with the phone number.
  • Website Url opens a new tab with the website.
  • Country / City / Street opens a new tab with the location in google maps


Advanced and custom filtering page: Filter your search results based on rules.


A new filtering option has been released to easily access HubSpot information based on different rules. 



On the left-hand side of your window, under  the "Apps" section you can click on "HubSpot Search" 



Select the "Element" you want to search for. 



Click on "Add filter" to see the filtering options. 



After you have applied your filtering options, click "Apply" to view your results.