Import Pipedrive Deals to Airtable

In this guide, we'll import deals from Pipedrive into Airtable using the Data Fetcher app. Pipedrive is an easy-to-use CRM with a great API that lets you automatically sync your data into other tools. We'll first get an API key from Pipedrive, then set up Data Fetcher to automatically fetch Pipedrive deals in Airtable.

Get Pipedrive API Key

Install Data Fetcher

Import Pipedrive Deals to Airtable

  • On the home screen of the Data Fetcher app, click 'Create request'.

    Screenshot 2021-02-17 at 16.12.14.png
  • On the create request screen, enter the request name 'Fetch Pipedrive Deals'.
  • We're going to use the Pipedrive 'get Deals' endpoint. If you'd like, you can read the Pipedrive API documentation for this endpoint here.
  • On the create request screen, enter the following URL:

https://companydomain.pipedrive.com/api/v1/deals

  • Add a parameter called api_token with the value of your Pipedrive API key from earlier.
  • Set the 'Output Table' to the table you want to import the deals into.
  • Set the 'Output View' to the view you want to import the deals into.
Screenshot 2021-05-07 at 08.59.49.png
  • Click 'Run'. You'll see a loading message while the request runs, then the response field mapping modal will open. This is where we select which fields from Pipedrive to keep and how they should map to our Airtable fields. You can see the fields that are returned in the Pipedrive API documentation.
  • Click 'Filter all' to deselect all fields, then re-add the following fields (and any others your want to keep) and data types:

Response Field

Data type

Use table field

Or, create field:

data.id

Number

data.title

Single line text

Name

data.add_time

Date Time

Added

data.active

Checkbox

Active

data.status

Single select

Status

data.org_name

Single line text

Organization

data.value

Currency

Value

  • Click 'Confirm'. Data Fetcher will create the new fields in your output table, then the request will run again and your Pipedrive deals will be imported into Airtable!
Screenshot 2021-05-10 at 08.53.44.png
  • Click 'Advanced' to open the Advanced settings and under 'Update based on Field', select the 'Id' field. This lets Data Fetcher know that this is a unique field that can be used to keep the deals in sync with Pipedrive.
  • Click 'Save'.

Screenshot 2021-05-10 at 09.08.49.png

Import More Deals - Pagination

Pipedrive's API returns a maximum of 500 deals at once, but if you can set up offset pagination in Data Fetcher to import more than this:

  • In the Advanced settings, under 'Pagination', select 'Offset'.
  • Set 'Fetch all pages' to true.
  • Enter 'start' for the 'Offset parameter'.
  • Enter 'limit' for the 'Limit parameter'.
  • Enter '500' for the limit value.
  • Click 'Save'. When you run the request again all your deals will be imported, not just the first 500.
Screenshot 2021-05-10 at 08.49.51.png

Import only Won/Lost/Open Deals from Pipedrive

By default, all Pipedrive deals are imported. We can restrict this using a status parameter:

Screenshot 2021-05-10 at 09.01.09.png

Import Deals on a Schedule

At the moment we have to import our Pipedrive deals by manually clicking the 'Run' button. Using Data Fetcher's schedule requests feature we can import them on a schedule, e.g. every Monday.

  • In Data Fetcher, scroll to 'Schedule'.
  • You will need a paid account to use this feature, so click the link to upgrade your account if you haven't already. After upgrading, click the 'I've done this' button.
  • Add your Airtable API key if you haven't already.
  • Turn on 'Schedule this API request'.
  • Set how often you want the request to run.
  • Click 'Save'.
Screenshot 2021-05-10 at 09.07.04.png