Back to Blog

Pipedrive – Google Sheets Integration to Automatically Export Data to Spreadsheets

Pipedrive provides an extensive list of features for managing your sales pipeline, but has a limited reporting functionality. In contrast, Google Sheets is a perfect tool for reporting and gives you lots of opportunities to visualize and manipulate your data. You can take advantage of both tools if you set up Pipedrive – Google Sheets integration. It’s fully automatic, and you won’t need to manually export Pipedrive data and then import it into Google Sheets. Check out how you can do this.

How to set up a Pipedrive to Google Sheets integration

No coding or magic skills are required. All you need is Coupler.io, a solution to import data into Google Sheets from different sources including Pipedrive. You can install Coupler.io from the G Suite Marketplace.

Visit the Coupler.io homepage to check out other available integrations.

Pipedrive importer

An importer is an integration that connects Google Sheets to a specific app. In our case, this is Pipedrive, so you will need to add a Pipedrive importer. Open Coupler.io in the Add-ons tab and click on the +Add Importer button.

After that select Pipedrive and complete the following steps:

1. Enter the name of your importer in the “Title” field

2. Set up Source

2.1. Connect your Pipedrive Account

Click Connect => Pick the Pipedrive account => Sign in => Click Allow to grant access.

2.2. Select Data Entity to import: Deals, Persons, Organizations, or Files

3. Set up Destination

3.1. Connect your Google Account

Click Connect => Pick the Google account => Sign in => Click Allow to grant access.

3.2. Enter the name of the sheet that will be receiving data in the “Sheet name” field

4. Configure Settings

4.1. Enable the “Automatic data refresh”

In this section you can:

For more on the Settings, as well as advanced parameters, refer to the Coupler.io knowledge base.

Once you’ve completed these steps, click Save & Run to save your Pipedrive to Google Sheets integration and export Pipedrive data to your spreadsheet.

Export the filtered Pipedrive data

Pipedrive importer lets you export data filtered by a preset or custom filter in Pipedrive. For this, click Show advanced in the Source section and insert the ID of your Pipedrive filter in the “Filter ID” field.

How to get the filter ID

  • Navigate to the Pipedrive interface and choose the data entity you need to filter.
  • Click on the Filter button in the top right corner (under your User account icon).
  • In the drop-down menu pick a predefined filter or create a custom one by clicking Add new filter.
  • Configure your filter: set up conditions and click Save.
  • Once your filter is ready, get the Filter ID from the URL – it is a numeral that stands after the slash “/” symbol in a resulting filter URL.

Export specific columns from Pipedrive

Having run the first import of Pipedrive data, you’ll get the names of all columns. After that you can specify which columns you need for recurrent data imports. For this, click Show advanced in the Source section and enter the names of the columns (each on a new line) in the order you want to see them in your spreadsheet. Leave this field empty if you need to pull all columns.

Note: The name of the column should correspond to the name Pipedrive gave it during the import, for example, creator_user_id, customer_id, creator_user_id.name, etc. If Coupler.io is not able to find any data in Pipedrive that corresponds to the column’s name you input into this field, it will create a column with the name but have no data in it.

Forget about the manual export of Pipedrive contacts and deals 

It takes you literally a few minutes to integrate Pipedrive and Google Sheets. During the setup, you can schedule the Automatic data refresh and forget about manual data export. With Coupler.io, you can connect your spreadsheet to another CRM, for example HubSpot to Google Sheets, as well as Airtable, Xero, and other data sources your company uses. And it’s definitely great to have all data in one place. Good luck!

Back to Blog

Comments are closed.

Access your data
in a simple format for free!

Start Free