Skip to content
Google Sheets

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

Triggers in Pipedrive with steps in Google Sheets
When this happens in PipedriveThis runs in Google SheetsHow fastStarter
A deal moves to a stageAdd a rowWithin secondsInstall the starter
A deal moves to a stageUpdate a rowWithin secondsTwo steps on the canvas
A deal is wonAdd a rowWithin secondsInstall the starter
A deal is wonUpdate a rowWithin secondsTwo steps on the canvas
A new deal is createdAdd a rowWithin secondsInstall the starter
A new deal is createdUpdate a rowWithin secondsTwo steps on the canvas
A new contact is addedAdd a rowWithin secondsInstall the starter
A new contact is addedUpdate a rowWithin secondsTwo steps on the canvas
An activity is scheduledAdd a rowWithin secondsInstall the starter
An activity is scheduledUpdate a rowWithin secondsTwo steps on the canvas

From Google Sheets to Pipedrive

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

Set up the starter

Add a row in Google Sheets 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 Google Sheets, for “Add a row”
  4. 4Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
  5. 5Fill in Google Sheets: Sheet (tab) (For example Sheet1)
  6. 6Check the order of Google Sheets’s values, column by column against the client’s columns
  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 Google Sheets’s “Add a row” step.

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

The values Add a row in Google Sheets when an activity is scheduled in Pipedrive sends
Google Sheets valueFilled 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

The values Add a row in Google Sheets when a new deal is created in Pipedrive sends
Google Sheets valueFilled 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

The values Add a row in Google Sheets when a deal moves to a stage in Pipedrive sends
Google Sheets valueFilled 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

The values Add a row in Google Sheets when a deal is won in Pipedrive sends
Google Sheets valueFilled 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

The values Add a row in Google Sheets when a new contact is added in Pipedrive sends
Google Sheets valueFilled 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.