Pardot connector set up guide

Matthias Kraaz

COO at Windsor.ai

Last updated: 24 September 2025

To integrate your Pardot (also known as Salesforce Pardot) data with Windsor.ai and utilize it across various data destinations such as Google Sheets, Looker Studio, Google BigQuery, Excel and data warehouses follow these instructions. Additionally, you can establish connections with data sources available in Windsor.ai.

Before proceeding with the Pardot-Windsor.ai connection, ensure you have the following prerequisites:

A user account within a Salesforce instance that is linked to Pardot.
The business unit ID specific to your Pardot account.
A Pardot instance that supports the usage of Pardot API versions 4 (V4) and 5 (V5).
AMPSEA (Authentication and Authorization for Pardot Marketing Data via Salesforce Enhanced Analytics) is required for utilizing Pardot API versions 4 and 5. If you encounter the error message “Pardot error: 89 Your account is unable to use version 4 of the API,” it is likely that AMPSEA is not enabled for your Pardot instance. For more information on AMPSEA, refer to the Salesforce documentation.

In Salesforce, click on Setup (gear icon in the top-right corner).
In the left-hand menu, under Platform Tools → Account Engagement, select Business Unit Setup.
In the Business Unit Setup screen, locate the Business Unit ID field (it looks like 0Uv1...).
Copy the Business Unit ID and save it in a safe place (e.g., a notepad).
- You will need this ID when authenticating Salesforce Account Engagement (Pardot) in Windsor.ai for the first time.

If the installation is not successful it can happen that Windsor.ai been blocked in Salesforce, you need to unblock it so users can connect again.

In Salesforce, go to Setup.
In the left-hand menu, under Apps → Connected Apps → Connected Apps OAuth Usage.
Find Windsor.ai in the list of connected apps.
Under Actions, click Unblock.
In the confirmation popup, click OK.
- This allows users to reconnect and use the Windsor.ai integration.

Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.

You might also be interested in…

Tired of juggling fragmented data? Get started with Windsor.ai today to create a single source of truth