Connect Pipedrive and Google Sheets
Start a client’s workflow in Pipedrive and act in Google Sheets, or the other way round, on the client’s own accounts.
Each app by itself: Pipedrive integration and Google Sheets integration, with how to connect it, its scopes and its limits.
What the pair is used for
- A Google Sheet can log every Pipedrive deal (new, won or entering a stage) as a row, giving the owner a sales sheet to filter or chart.
- Scheduled activities can fill another tab with subject, type, due date, due time, duration and location.
- New people land as rows with their name, organisation ID, owner ID, label and the time they were added.
Every way Pipedrive and Google Sheets 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 Pipedrive to Google Sheets
| When this happens in Pipedrive | This runs in Google Sheets | How fast | Starter |
|---|---|---|---|
| A deal moves to a stage | Add a row | Within seconds | Install the starter |
| A deal moves to a stage | Update a row | Within seconds | Two steps on the canvas |
| A deal is won | Add a row | Within seconds | Install the starter |
| A deal is won | Update a row | Within seconds | Two steps on the canvas |
| A new deal is created | Add a row | Within seconds | Install the starter |
| A new deal is created | Update a row | Within seconds | Two steps on the canvas |
| A new contact is added | Add a row | Within seconds | Install the starter |
| A new contact is added | Update a row | Within seconds | Two steps on the canvas |
| An activity is scheduled | Add a row | Within seconds | Install the starter |
| An activity is scheduled | Update a row | Within seconds | Two steps on the canvas |
From Google Sheets to Pipedrive
| When this happens in Google Sheets | This runs in Pipedrive | How fast | Starter |
|---|---|---|---|
| A row is added | List people | Within 15 minutes | Two steps on the canvas |
| A row is added | Create a person | Within 15 minutes | Two steps on the canvas |
| A row is added | Update a person | Within 15 minutes | Two steps on the canvas |
| A row is added | Create a deal | Within 15 minutes | Two steps on the canvas |
| A row is changed | List people | Within 15 minutes | Two steps on the canvas |
| A row is changed | Create a person | Within 15 minutes | Two steps on the canvas |
| A row is changed | Update a person | Within 15 minutes | Two steps on the canvas |
| A row is changed | Create a deal | Within 15 minutes | Two steps on the canvas |
Set up the starter
Add a row in Google Sheets 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 Google Sheets, for “Add a row”
- 4Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>
/edit) - 5Fill in Google Sheets: Sheet (tab) (For example Sheet1)
- 6Check the order of Google Sheets’s values, column by column against the client’s columns
- 7Switch it on. Within seconds: Pipedrive tells us as it happens.

What it produces
The Google Sheets step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.
- Sheet
- Lakeview leads
- Spreadsheet ID
- Lakeview leads
- Values
- Emma Collins · new · 2026-10-21T09:05:00Z · 240 · 240 · example
Setup notes for this pair
- Six values go in for a deal, in order (title, value, currency, status, stage ID, pipeline ID), so the tab’s first six headings should follow that order.
- An activity’s due time and duration arrive from Pipedrive as plain numbers, and a deal that is created, moved and won takes three rows.
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.
Add a row for scheduled activities
Add a row in Google Sheets when an activity is scheduled in Pipedrive
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the activity’s subject, from Pipedrive] [the activity’s type, from Pipedrive] [the activity’s due date, from Pipedrive] [the activity’s value, from Pipedrive] [the activity’s value, from Pipedrive] [the activity’s location, from Pipedrive] |
Add a row for new deals
Add a row in Google Sheets when a new deal is created in Pipedrive
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the deal’s title, from Pipedrive] [the deal’s value, from Pipedrive] [the deal’s currency, from Pipedrive] [the deal’s status, from Pipedrive] [the deal’s stage id, from Pipedrive] [the deal’s pipeline id, from Pipedrive] |
Add a row for deal stage moves
Add a row in Google Sheets when a deal moves to a stage in Pipedrive
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the deal’s title, from Pipedrive] [the deal’s value, from Pipedrive] [the deal’s currency, from Pipedrive] [the deal’s status, from Pipedrive] [the deal’s stage id, from Pipedrive] [the deal’s pipeline id, from Pipedrive] |
Add a row for won deals
Add a row in Google Sheets when a deal is won in Pipedrive
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the deal’s title, from Pipedrive] [the deal’s value, from Pipedrive] [the deal’s currency, from Pipedrive] [the deal’s status, from Pipedrive] [the deal’s stage id, from Pipedrive] [the deal’s pipeline id, from Pipedrive] |
Add a row for new contacts
Add a row in Google Sheets when a new contact is added in Pipedrive
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the contact’s name, from Pipedrive] [the contact’s org id, from Pipedrive] [the contact’s owner id, from Pipedrive] [the contact’s label, from Pipedrive] [the contact’s add time, from Pipedrive] |
Pipedrive and Google Sheets 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.