Skip to content
Airtable

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

Triggers in Airtable with steps in Pipedrive
When this happens in AirtableThis runs in PipedriveHow fastStarter
A record is addedList peopleWithin 15 minutesTwo steps on the canvas
A record is addedCreate a personWithin 15 minutesTwo steps on the canvas
A record is addedUpdate a personWithin 15 minutesTwo steps on the canvas
A record is addedCreate a dealWithin 15 minutesTwo steps on the canvas
A record is changedList peopleWithin 15 minutesTwo steps on the canvas
A record is changedCreate a personWithin 15 minutesTwo steps on the canvas
A record is changedUpdate a personWithin 15 minutesTwo steps on the canvas
A record is changedCreate a dealWithin 15 minutesTwo steps on the canvas

From Pipedrive to Airtable

Triggers in Pipedrive with steps in Airtable
When this happens in PipedriveThis runs in AirtableHow fastStarter
A deal moves to a stageCreate a recordWithin secondsInstall the starter
A deal moves to a stageFind recordsWithin secondsTwo steps on the canvas
A deal moves to a stageUpdate a recordWithin secondsTwo steps on the canvas
A deal is wonCreate a recordWithin secondsInstall the starter
A deal is wonFind recordsWithin secondsTwo steps on the canvas
A deal is wonUpdate a recordWithin secondsTwo steps on the canvas
A new deal is createdCreate a recordWithin secondsInstall the starter
A new deal is createdFind recordsWithin secondsTwo steps on the canvas
A new deal is createdUpdate a recordWithin secondsTwo steps on the canvas
A new contact is addedCreate a recordWithin secondsInstall the starter
A new contact is addedFind recordsWithin secondsTwo steps on the canvas
A new contact is addedUpdate a recordWithin secondsTwo steps on the canvas
An activity is scheduledCreate a recordWithin secondsInstall the starter
An activity is scheduledFind recordsWithin secondsTwo steps on the canvas
An activity is scheduledUpdate a recordWithin secondsTwo steps on the canvas

Set up the starter

Create a record in Airtable when an activity is scheduled in Pipedrive

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Pipedrive, for “An activity is scheduled”
  3. 3Connect the client’s Airtable, for “Create a record”
  4. 4Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
  5. 5Fill in Airtable: Table (For example Leads)
  6. 6Match Airtable’s fields to the client’s own: Subject, Type call meeting, Due date, Due time
  7. 7Switch it on. Within seconds: Pipedrive tells us as it happens.
The installed workflow on the canvas: Pipedrive’s “An activity is scheduled” trigger leading to Airtable’s “Create a record” step.

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

The values Create a record in Airtable when an activity is scheduled in Pipedrive sends
Airtable valueFilled 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

The values Create a record in Airtable when a new deal is created in Pipedrive sends
Airtable valueFilled 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

The values Create a record in Airtable when a deal moves to a stage in Pipedrive sends
Airtable valueFilled 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

The values Create a record in Airtable when a deal is won in Pipedrive sends
Airtable valueFilled 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

The values Create a record in Airtable when a new contact is added in Pipedrive sends
Airtable valueFilled 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.