Pardot connector set up guide

To integrate your Pardot (also known as Salesforce Pardot) data with 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

Before proceeding with the connection, ensure you have the following prerequisites:

  1. A user account within a Salesforce instance that is linked to Pardot.
  2. The business unit ID specific to your Pardot account.
  3. A Pardot instance that supports the usage of Pardot API versions 4 (V4) and 5 (V5).
  4. 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.

To find the business unit ID for your Pardot account, follow these steps:

  1. Log in to Salesforce.
  2. Click on “Setup” located on the top right-hand side of the page.
  3. In the left-hand menu, navigate to “Setup Assistant” and click on “Business Unit Setup.”
  4. Locate the “Business Unit ID” and copy it to a safe location, such as a notepad. These details will be required when you authenticate Pardot in for the first time.

Try today

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

Start Free Trial


You might also be interested in…