Skip to main content

Make Waves ’26 Step into AI’s glass box. Prague, 19–20 Oct.

Register now (opens in a new tab)
Google Sheets
Pipedrive CRM

Connect Google Sheets and Pipedrive CRM integrations

Discover the potential of integrating Google Sheets with Pipedrive CRM. Simplify deal tracking, improve data accuracy, and elevate sales performance. Manage workflows and tailor lead engagement for better outcomes.

Get started free

Create a custom workflow

Improve your business operations by connecting Google Sheets with Pipedrive CRM through Make, automating data synchronization while eliminating manual entry errors.

Create a custom workflow

Every automation starts with a trigger and an action. Select one from each app to generate a workflow tailored to your needs.

Google Sheets
Trigger: Perform a Function
Pipedrive CRM
Action: Select an action
1. Select a trigger

  • Receives data from the MAKE_FUNCTION or INTEGROMAT functions used in a sheet. Please note, the Sheets Add-On is required.

  • Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

  • Triggers when a new row is added.

2. Select an action

  • Add follower to an object of selected type (deals, organizations, persons).

  • Add follower to an object of selected type (deals, organizations, persons).

  • Adds a participant to a deal.

  • Adds a product to the deal.

  • Adds a new recurring subscription to a deal.

  • Adds a new installment subscription.

  • Adds an installment to a deal.

  • Cancels a recurring subscription.

  • Creates a deal.

  • Creates a deal.

  • Creates a new deal field.

  • Creates a lead.

  • Creates a new lead label.

  • Creates a note.

  • Creates a person.

  • Creates a person.

  • Creates a product.

  • Creates a product.

  • Creates a new project.

  • Creates a new task.

  • Creates an activity.

  • Creates an activity.

  • Creates an organization.

  • Creates an organization.

  • Deletes a deal.

  • Deletes a deal field by its ID.

  • Delete a follower from a deal.

  • Delete a follower from a deal.

  • Deletes a lead.

  • Deletes lead label by its ID.

  • Marks mail thread as deleted.

  • Deletes a note.

  • Deletes a person.

  • Deletes a product.

  • Deletes or archives a project by its ID.

  • Marks an installment or a recurring subscription as deleted.

  • Deletes task by its ID.

  • Deletes an activity.

  • Deletes a product attachment from a deal.

  • Deletes an installment.

  • Deletes an organization.

  • Downloads a file.

  • Returns details of a specific deal.

  • Returns details of a specific deal.

  • Gets a Deal field.

  • Gets filter by its ID.

  • Gets a lead.

  • Returns specific mail thread.

  • Returns data about specific mail message.

  • Returns details about a specific note.

  • Returns details of a person.

  • Returns details of a person.

  • Returns data about a specific product.

  • Returns data about a specific product.

  • Gets a project by its ID.

  • Returns details of an installment or a recurring subscription.

  • Gets task by its ID.

  • Returns data about a specific user within the company.

  • Returns details of a specific activity.

  • Returns details of a specific activity.

  • Returns details of an organization.

  • Returns details of an organization.

  • Gets deals summary.

  • Performs an arbitrary authorized API call.

  • Performs an arbitrary authorized API call.

  • Updates a deal.

  • Updates a deal.

  • Updates Deal field by its ID.

  • Updates a lead.

  • Updates lead label by its ID.

  • Updates the properties of a mail thread.

  • Updates a note.

  • Updates a person.

  • Updates a person.

  • Updates a product.

  • Updates a product.

  • Updates project by its ID.

  • Updates a recurring subscription.

  • Updates task by its ID.

  • Updates an activity.

  • Updates an activity.

  • Updates an installment added to a deal.

  • Updates an installment subscription.

  • Updates an organization.

  • Updates an organization.

  • Updates an organization field value.

  • Updates product attachment details of the deal-product (a product already attached to a deal).

  • Lets you upload a file, and associate it with a Deal, a Person, an Organization, an Activity or a Product.

Select a trigger and an action

Create workflow (opens in a new tab)

Triggers and actions

Utilize the Make platform to integrate Google Sheets as a trigger and Pipedrive CRM as an action, automating your data workflows. When a new entry is added in Google Sheets, it can automatically trigger updates in Pipedrive CRM, removing the need for manual entry and reducing errors. This connection ensures sales and customer data remain synchronized, improving efficiency and allowing your team to focus on strategic activities. Experience automation between Google Sheets and Pipedrive CRM, managing your business data seamlessly.

Add a Conditional Format Rule
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Action
Add a Follower
Add follower to an object of selected type (deals, organizations, persons).
Action
Add a Follower (Deprecated)
Add follower to an object of selected type (deals, organizations, persons).
Action
Add a Participant to a Deal
Adds a participant to a deal.
Action
Add a Product to a Deal
Adds a product to the deal.
Action
Add a Recurring Subscription (Deprecated)
Adds a new recurring subscription to a deal.
Action
Add a Row
Appends a new row to the bottom of the table.
Action
Add a Sheet
Adds a new sheet.
Action
Add an Installment Subscription (Deprecated)
Adds a new installment subscription.
Action
Load more

How to set up Google Sheets and Pipedrive CRM in 5 easy steps

Date

·

Duration

Step 1

Access your Make workspace

Start by logging into your Make account to access your workspace where you'll create application connections.

Date

·

Duration

Step 2

Connect Google Sheets

Add a Google Sheets module in your Make workspace to begin connecting Google Sheets to your scenario.

Date

·

Duration

Step 3

Allow Google Sheets access

Sign into your Google account when prompted so Make can access your Google Sheets data.

Date

·

Duration

Step 4

Prepare Pipedrive access

Log into Pipedrive and find your API token under your account settings, which will allow Make to connect to your Pipedrive data.

Date

·

Duration

Step 5

Establish Pipedrive connection

Add a Pipedrive module in Make and use your API token to connect, ensuring Make can communicate securely with Pipedrive.

Enhance sales management with Google Sheets and Pipedrive integration

Integrating Google Sheets with Pipedrive CRM enables automated deal tracking, precise data management, and better sales performance analysis for more efficient workflow and personalized lead engagement.

Date

·

Duration

Automated deal tracking

Automatically log and track Pipedrive deals in Google Sheets for better sales management.

Date

·

Duration

Reliable data accuracy

Maintain accurate and up-to-date deal records through integration between Pipedrive and Google Sheets.

Date

·

Duration

Effective sales performance monitoring

Evaluate sales performance effectively with organized and comprehensive data in Google Sheets.

Date

·

Duration

Efficient workflow management

Reduce manual data entry and increase workflow productivity by automating the addition of new deals to Google Sheets.

Popular Google Sheets and Pipedrive CRM workflows

Connect Google Sheets and Pipedrive CRM with Make. Automate manual tasks, sync real-time data, and build more efficient workflows.

App Families

Add new Pipedrive deals to a Google Sheets spreadsheet as new rows

Every time a new deal is created in Pipedrive, Make will automatically add that deal to a new row in a Google Sheets spreadsheet. The template uses this example spreadsheet.

Add new Pipedrive deals to a Google Sheets spreadsheet as new rows
Use template
AI

Personalize an introduction message with ChatGPT for new Pipedrive CRM leads and store them on a Google Sheet for review

Optimize your Pipedrive CRM lead engagement using ChatGPT to craft personalized introduction messages, while organizing and reviewing them on Google Sheets.

Personalize an introduction message with ChatGPT for new Pipedrive CRM leads and store them on a Google Sheet for review
Use template
App Families

Watch Pipedrive deals and update Google Sheets rows accordingly

Automatically track Pipedrive deals and update corresponding Google Sheets rows. Streamline sales data management by syncing deal changes with your spreadsheets.

Watch Pipedrive deals and update Google Sheets rows accordingly
Use template
Load more

Support

FAQs

Everything you need to know about Make. Can't find the answer you're looking for? Please chat to our team.

Integrating Google Sheets with other apps using Make simplifies your workflow by automating repetitive tasks such as data entry or updates. This connection supports hundreds of applications like Shopify, Discord, and WooCommerce, improving efficiency and freeing your time for more important tasks.

Integrating Pipedrive CRM with Make helps automate your sales and customer relationship processes by connecting Pipedrive to various apps you use. This allows for better management of leads, contacts, and deals by automatically synchronizing information, thus reducing manual work and potential errors.

Yes, integrating both Google Sheets and Pipedrive CRM using Make offers features like automatic data sharing between your CRM and spreadsheets. For instance, sales data in Google Sheets can be updated whenever new information is added to Pipedrive, keeping your data aligned and easy to access for analysis and reporting.

Setting up integrations in Make is accessible for everyone thanks to its user-friendly, visual interface. You can simply drag and drop elements to create automated workflows without needing any coding skills, making it accessible for users of all technical backgrounds.