Search API Connector Documentation
Import Pipedrive Data to Google Sheets
In this guide, we’ll walk through how to pull data from the Pipedrive API directly into Google Sheets, using the API Connector add-on for Sheets.
There are 2 ways to connect to the Pipedrive API:
- Preset "Connect" button (OAuth) premium
- Personal API token. Please check the appendix for detailed instructions to retrieve your token.
- Before You Begin
- Part 1: Connect to the Pipedrive API
- Part 2: Pull Data from Pipedrive to Sheets
- Part 3: Create a Custom API Request
- Part 4: Handle Pagination
- Part 5: API Documentation
- Appendix: Connect with a Pipedrive API Token
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Connect to the Pipedrive API
The easiest way to get started with the Pipedrive API is through API Connector’s built-in integration.
- Select Pipedrive from the drop-down list of applications
- Under Authorization, click Connect to Pipedrive
- You will see a screen asking you to log in and approve the connection. Click Allow and Install.
- You'll then be returned to your Google Sheet, and can verify that your Pipedrive connection is active.
Part 2: Pull Data from Pipedrive to Sheets
Now that we’re connected, let’s pull some data into Sheets.
- Under Endpoint, choose an endpoint. Let’s start by getting deals.
- Fill in the
fieldsparameter is optional, but we're including it because Pipedrive sends back a massive data set otherwise. If you'd like to leave it out, I suggest setting the
limitparameter to 2 for your first request, so you can add filters before retrieving data for your full set of records.
- Select a destination sheet, name your request, and click Run.
Part 3: Create a Custom API Request
Alternatively, you can create a custom request instead of using API Connector’s built-in integration, using any of the endpoints and parameters shown in the API documentation.
To create a custom request, add the complete URL into the request URL field, and select Pipedrive from the OAuth menu (or connect with an API token).
To easily convert your preset request to a custom request, click Output Options > More Options > Add Request URL before running your request. This will print your URL into your sheet where you can copy and paste it into a custom request.
Part 4: Handle Pagination
Many Pipedrive endpoints will return a limited set of data per page. To retrieve additional data, you'll need to follow the pagination links in the response, as described here. With API Connector, you can run these request URLs manually, or loop through them automatically using pagination handling (paid feature). Pipedrive uses 'start' and 'limit' parameters, so they would get entered like this:
- Pagination type:
- Offset parameter:
- Limit parameter:
- Limit value:
- Run until: choose when to stop fetching data
Part 5: API Documentation
Official API documentation: https://developers.pipedrive.com/docs/api/v1/
Field selector documentation: https://pipedrive.readme.io/docs/core-api-concepts-requests#field-selector
Appendix: Connect with a Pipedrive API Token
Pipedrive requires that all API requests are authenticated. This is the process to authenticate with a Pipedrive API token:
- While logged into your Pipedrive account, navigate to Settings > (Personal) > Personal Preferences > API, or just click here.
- You'll now see a page containing your Access Token. Copy this to your clipboard.
- That's it, you now have access to the Pipedrive API! You can use this token by appending
api_token=YOUR_TOKENto your URLs, e.g.
https://company.pipedrive.com/api/v1/deals:(id,title,active,add_time,update_time,stage_id,currency,value,status,pipeline_id)?api_token=1234567&status=open. Since you're manually including an API token, leave OAuth2 authentication set to None.