Connect Airtable and Pipedrive
Start a client’s workflow in Airtable and act in Pipedrive, or the other way round, on the client’s own accounts.
Each app by itself: Airtable integration and Pipedrive integration, with how to connect it, its scopes and its limits.
What the pair is used for
- In the Web design agency pack, Airtable holds the quotes, which are nudged two, five and ten days after they were sent, and a deal won in Pipedrive starts the kickoff. See it in the library
- The Paid-ads agency pack reads unpaid invoices from an Airtable table each day to chase them at one, seven, fourteen and twenty-one days, while a won Pipedrive deal opens the new client’s kickoff. See it in the library
- Without a pack, each Pipedrive deal (new, won or moved into a stage) can be logged as an Airtable row within seconds, and scheduled calls and meetings land as rows with their subject and due date.
Every way Airtable and Pipedrive join
A workflow starts from a trigger in one app and runs a step in the other, on the client’s accounts. Where the library has a starter for it, it installs that pairing into a client switched off; any other pairing is two steps on the canvas.
From Airtable to Pipedrive
| When this happens in Airtable | This runs in Pipedrive | How fast | Starter |
|---|---|---|---|
| A record is added | List people | Within 15 minutes | Two steps on the canvas |
| A record is added | Create a person | Within 15 minutes | Two steps on the canvas |
| A record is added | Update a person | Within 15 minutes | Two steps on the canvas |
| A record is added | Create a deal | Within 15 minutes | Two steps on the canvas |
| A record is changed | List people | Within 15 minutes | Two steps on the canvas |
| A record is changed | Create a person | Within 15 minutes | Two steps on the canvas |
| A record is changed | Update a person | Within 15 minutes | Two steps on the canvas |
| A record is changed | Create a deal | Within 15 minutes | Two steps on the canvas |
From Pipedrive to Airtable
| When this happens in Pipedrive | This runs in Airtable | How fast | Starter |
|---|---|---|---|
| A deal moves to a stage | Create a record | Within seconds | Install the starter |
| A deal moves to a stage | Find records | Within seconds | Two steps on the canvas |
| A deal moves to a stage | Update a record | Within seconds | Two steps on the canvas |
| A deal is won | Create a record | Within seconds | Install the starter |
| A deal is won | Find records | Within seconds | Two steps on the canvas |
| A deal is won | Update a record | Within seconds | Two steps on the canvas |
| A new deal is created | Create a record | Within seconds | Install the starter |
| A new deal is created | Find records | Within seconds | Two steps on the canvas |
| A new deal is created | Update a record | Within seconds | Two steps on the canvas |
| A new contact is added | Create a record | Within seconds | Install the starter |
| A new contact is added | Find records | Within seconds | Two steps on the canvas |
| A new contact is added | Update a record | Within seconds | Two steps on the canvas |
| An activity is scheduled | Create a record | Within seconds | Install the starter |
| An activity is scheduled | Find records | Within seconds | Two steps on the canvas |
| An activity is scheduled | Update a record | Within seconds | Two steps on the canvas |
Set up the starter
Create a record in Airtable when an activity is scheduled in Pipedrive
- 1Install the starter into the client from Templates → Library. It lands switched off.
- 2Connect the client’s Pipedrive, for “An activity is scheduled”
- 3Connect the client’s Airtable, for “Create a record”
- 4Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
- 5Fill in Airtable: Table (For example Leads)
- 6Match Airtable’s fields to the client’s own: Subject, Type call meeting, Due date, Due time
- 7Switch it on. Within seconds: Pipedrive tells us as it happens.

What it produces
The Airtable step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.
- Base ID
- appXXXXXXXXXXXXXX
- Fields
- {"Due date":"{{ trigger.payload.due_date }}","Due time":"{{ trigger.payload.due_time.value }}","Subject":"{{ trigger.payload.subject }}","Type call meeting":"{{ trigger.payload.type }}"}
- Table
- Leads
Setup notes for this pair
- The starters write to columns named Deal, Value, Currency and “Status open won lost” (Subject, “Type call meeting”, Due date and Due time for activities). Airtable needs field names that match the table’s columns, so rename one side to match the other.
- A row for a new person carries Pipedrive’s organisation and owner as ID numbers.
Field mapping, starter by starter
Each value a starter’s step is given, and where it comes from. Words in brackets are filled in when it runs; change any of it after installing.
Create a record for scheduled activities
Create a record in Airtable when an activity is scheduled in Pipedrive
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Due date":"[the activity’s due date, from Pipedrive]","Due time":"[the activity’s value, from Pipedrive]","Subject":"[the activity’s subject, from Pipedrive]","Type call meeting":"[the activity’s type, from Pipedrive]"} |
| Table | [Airtable: Table] |
Create a record for new deals
Create a record in Airtable when a new deal is created in Pipedrive
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Currency":"[the deal’s currency, from Pipedrive]","Deal":"[the deal’s title, from Pipedrive]","Status open won lost":"[the deal’s status, from Pipedrive]","Value":"[the deal’s value, from Pipedrive]"} |
| Table | [Airtable: Table] |
Create a record for deal stage moves
Create a record in Airtable when a deal moves to a stage in Pipedrive
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Currency":"[the deal’s currency, from Pipedrive]","Deal":"[the deal’s title, from Pipedrive]","Status open won lost":"[the deal’s status, from Pipedrive]","Value":"[the deal’s value, from Pipedrive]"} |
| Table | [Airtable: Table] |
Create a record for won deals
Create a record in Airtable when a deal is won in Pipedrive
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Currency":"[the deal’s currency, from Pipedrive]","Deal":"[the deal’s title, from Pipedrive]","Status open won lost":"[the deal’s status, from Pipedrive]","Value":"[the deal’s value, from Pipedrive]"} |
| Table | [Airtable: Table] |
Create a record for new contacts
Create a record in Airtable when a new contact is added in Pipedrive
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Label":"[the contact’s label, from Pipedrive]","Name":"[the contact’s name, from Pipedrive]","Organisation ID":"[the contact’s org id, from Pipedrive]","Owner ID":"[the contact’s owner id, from Pipedrive]"} |
| Table | [Airtable: Table] |
Airtable and Pipedrive and their logos are trademarks of their owners, used here only to say what Thrum works with; no endorsement is implied.
Thrum is cooking.
Get early access and you’ll be among the first in. Early members get a launch perk.