Pipedrive is a sales CRM platform. 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. We'll first get an API key from Pipedrive, and then set up a request to pull in CRM data to your spreadsheet.

• Part 1: Get your Pipedrive API Key
• Part 2: Create your API Request URL
• Part 3: Enter values into API Connector
• Part 4: Notes and Expansions

PART 1: GET YOUR PIPEDRIVE API KEY

1. While logged into your Pipedrive account, navigate to Settings > (Personal) > Personal Preferences > API, or just click here.
2. You'll now see a page containing your Access Token. Copy this to your clipboard as you'll need it in a moment. That's it, you now have access to the Pipedrive API!
   

PART 2: CREATE YOUR PIPEDRIVE API REQUEST URL

We’ll follow the Pipedrive documentation to access a list of leads.

• API root: https://{domain}.pipedrive.com
• Endpoint: /v1/deals
• Query String: ?api_token={api token}

Putting it together, we get the full API Request URL:

https://companydomain.pipedrive.com/v1/deals?api_token={api token}

PART 3: ENTER YOUR VALUES INTO API CONNECTOR

We can now enter our values into API Connector and import Pipedrive API data into Google Sheets.

1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
2. In the Create Request interface, enter the Request URL we just created
   

3. Under Headers, enter a set of key-value pairs, like this:
   

   Content-Type

   application/json

   

4. Create a new tab. You can call it whatever you like, but here we'll call it 'Pipedrive_deals'. While still in that tab, click 'Set' to use that tab as your data destination.
5. Name your request. Again we'll call it 'Pipedrive_deals'
6. Click Run and a moment later you’ll see a list of your deals in your Google Sheet:
   

PART 4: PIPEDRIVE + SHEETS NOTES AND EXPANSIONS

1. Experiment with endpoints and query strings as described in the documentation to see other types of Pipedrive data. For example, this URL will return a list of organizations:

   https://companydomain.pipedrive.com/v1/organizations?api_token={api token}

2. 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 requests separately, or process them automatically using pagination handling (paid feature).