Airtable logo
Pipedrive
Import and sync data in Airtable

Connect Airtable and Pipedrive

Sync your deals, leads and contacts into Airtable using a simple no-code API integration. Sync data from Pipedrive and thousands of other apps into Airtable automatically with Data Fetcher.

Trusted by leading Airtable teams

IBM Logo
Amazon Logo
Warner Records Logo
Harvard Logo
Stanford Logo
NBA Logo
Time Logo
DraftKings Logo

The no-code solution for connecting Pipedrive to Airtable

It takes just 4 simple steps to get up and running with Data Fetcher’s no-code imports into Airtable

Step 1

Add the Data Fetcher extension

Get started with Pipedrive in Airtable by adding the Data Fetcher extension from the Airtable Marketplace. Create your free account directly within the extension after installation.

Add the Data Fetcher extension
Step 2

Connect to Pipedrive

Select the pre-built Pipedrive integration from our library. Data Fetcher handles all the technical API details, so you can connect without writing a single line of code.

Connect to Pipedrive
Step 3

Map the fields

Select which Pipedrive data fields you want to import and map them to your existing Airtable fields. Choose how new data should merge with existing records in your base.

Map the fields
Step 4

Automate your Pipedrive data sync

Keep your Airtable data fresh by scheduling automatic updates at any interval. You can also trigger syncs from Pipedrive when records change in your Airtable base.

Automate your Pipedrive data sync

About the tools

Pipedrive logo

Pipedrive

Pipedrive is a sales-focused customer relationship management (CRM) platform designed to help teams manage their sales pipeline with visual clarity. It offers intuitive deal tracking with customizable stages and probability-based forecasting to help sales professionals prioritize their most promising opportunities. The platform includes contact and company management, email integration, activity scheduling, and mobile accessibility for managing sales on the go.

Airtable logo

Airtable

Airtable blends spreadsheets and databases, enabling organized, collaborative workflows. It features customizable templates, multiple viewing options like grid, calendar, and kanban boards, plus powerful data types. With integration capabilities, automation tools, and team collaboration features, Airtable helps businesses of all sizes manage projects, content planning, and data without technical expertise.

Data Fetcher logo

Data Fetcher

Data Fetcher is an Airtable extension that connects your bases with external data sources and APIs. Users can pull data from REST APIs and external systems without writing code. With support for automic syncs, data transformation and mapping, Data Fetcher helps businesses make Airtable their source of truth for all their third-party data. It acts as the missing connection between Pipedrive and Airtable.

How to Connect Pipedrive to Airtable

In this guide, we’ll import Pipedrive deals to Airtable. We’ll use Data Fetcher's Pipedrive Airtable integration to fetch Pipedrive deal fields, such as Id, Status & Value. We will also cover how to find your Pipedrive API key and set up your Pipedrive deals to import to Airtable automatically.

Install Data Fetcher

Install Data Fetcher from the Airtable marketplace. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'. If you already have a Data Fetcher account, sign in using the 'Have an account?' button at the bottom left of the box.

Data Fetcher Sign Up

Import Pipedrive Deals to Airtable

On the home screen of the Data Fetcher extension, click 'Create your first request'. Requests in Data Fetcher are how you import data to or send data from your Airtable base.

Create your first request

On the create request screen in Data Fetcher, for Application, select 'Pipedrive' to use the Pipedrive Airtable integration.

application-pipedrive.png

Copy and paste your personal API token from your Pipedrive account into Data Fetcher. Your Pipedrive API key authorises Data Fetcher to read from your Pipedrive account. You can find your Pipedrive API key here.

pipedrive-authorisation.png

For Endpoint, select 'List all deals'.

You can also add a Name for your request, e.g. 'Import Pipedrive Deals'. 

Click 'Save & Continue'.

pipedrive list all deals save continue.png

The Status signifies the current state of the deal. This is where you can set preferences to only import deals that you currently have Open, Won, Lost or Deleted. The final option, ‘All not deleted’, is the default, so you do not have to select anything here unless you only want to import the deals with a particular status.

The Stage dropdown option has a similar function to Status. However, it has a broader timespan. Again, you do not need to do anything here.

Select the Output Table & View you want to import the deals into.

output-table-1.png

Click 'Save & Run'.

pipedrive deals save run.png

This request will run, and the Response Field Mapping window will open. This is where you set which fields from Pipedrive will map to which fields in the output table. 10 fields have automatically been selected, but you can turn these off using the green toggle or by clicking ‘Filter all’, then search and select which of these you would like to include.

You can easily find the fields you want to import using the Find Field search bar.

Make sure you import the 'Id' field, as we will use this to ensure the deals we import into Airtable are kept in sync with any changes in Pipedrive. 

We will import the 'Active', 'Add time', 'Id', 'Org name', 'Status', 'Value' fields. 

When you are ready, click ‘Save & Run’.

pipedrive deals rfm .png

Data Fetcher will create any fields that need to be created in the output table, then run the request and import the deals from Pipedrive to Airtable. You can now choose to view the output table.

pipedrive deals imported data.png

We'll also need to ensure Data Fetcher can match up items in Pipedrive with records in Airtable and check all data is syncing correctly. To do this, click 'Advanced settings' to open the advanced output settings. Then for Update Based on Field, select 'Id'. 

Click 'Save'.

Automatic Pipedrive Airtable integration

Instead of manually running a request to import new Airtable deals we can use Data Fetcher's scheduled Pipedrive Airtable integration to automatically import them. To enable this, you'll need a paid Data Fetcher account.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

table-1-schedule-upgrade-button.png

A new tab will open where you can select a plan and enter your payment details to upgrade.

data fetcher upgrade pricing plans.png

Return to the Data Fetcher extension and click 'I've done this'.

table-1-schedule-ive-done-this-button.png

To upgrade your account, In Data Fetcher, scroll to Schedule and click 'Upgrade'.

schedule options

Choose a plan from the different options depending on your needs and enter your payment details.

data fetcher upgrade pricing plans.png

In Data Fetcher, click 'I've done this'.

Schedule Data Fetcher

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

A window will open where you'll be prompted to authorize which Airtable bases you want Data Fetcher to have access to.

We recommended selecting 'All current and future bases in all current and future workspaces' to avoid any issues with unauthorized bases in the future.

Click 'Grant access'.

schedule-authorize-bases.jpg

Back in Data Fetcher, you'll see Schedule this request is now toggled on.

Select how often you want the Pipedrive Airtable integration to run, e.g. 'Every 15 mins'. Click 'Save'. The request will now run on the schedule and automatically import new Pipedrive deals, plus any changes you have made to existing deals.

Group 11(2).png

Ready to connect Pipedrive to Airtable?

Start syncing your data sources with Airtable today.