How to connect Pipedrive + Google Sheets + Google Drive
Zapier lets you send info between Pipedrive and Google Sheets and Google Drive automatically—no code required. With 8,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Pipedrive + Google Sheets + Google Drive
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Pipedrive, Google Sheets, and Google Drive. And don’t forget that you can add more apps and actions to create complex workflows.
New Lead
Triggers when a lead is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Note
Triggers when a new note is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Organization
Triggers when a new organization is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Person
Triggers when an existing person is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter ID
Status
Board ID
Phase ID
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planFilter By
Field to Watch for Changes On
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.PersonRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IdRequired
Product Variation IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FollowerRequired
Choose where to add the followerRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContentRequired
Deal
Pin note to deal
Person
Pin note to person
Organization
Project
Pin note to organization
Lead
Pin note to lead
Pin note to project
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Emails
Phones
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Project Template
Project BoardRequired
Project PhaseRequired
Description
Status
Owner
Start Date
End Date
Deals
Organization
Person
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Remove All Existing Labels?
Labels to Remove
Labels to Add
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Null
DealRequired
Title
Status
Stage
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Null
ProductRequired
Product Name
Product Code
Description
Unit
Tax percentage
Category
Owner
Is Linkable
Currency
Price
Direct cost
Overhead Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
Title
Project
Description
Done
Due Date
Assignee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Search Type
Assigned To
Filter
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search By
Term to search forRequired
Search type
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appNote IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch By
Search TermRequired
Exact Match
ActionThis is an event a Zap performs.SearchFind existing data in your appField to search byRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search By
Term to search forRequired
Search type
TitleRequired
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
TitleRequired
Person
Organization
Owner
Note
Pin note to lead
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
Source Channel ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
Name
Emails
Phones
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
Folder
Include Deleted Files?
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
Folder
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Drive
FolderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File to ReplaceRequired
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Drive
Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete File
This action will delete a file in Google Drive. You will need to provide the file ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FilenameRequired
Search Type
Drive
Folder
File Types
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder NameRequired
Search Type
Drive
Parent Folder
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder NameRequired
Search Type
Drive
Parent Folder
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deal
Triggers when a new deal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new person is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DealRequired
Discount DescriptionRequired
Discount AmountRequired
Discount TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Add Multiple Products?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subject
Owner
Organization
Deal
Lead
Project
Mark as done
Type
Use combined date and time field?
Duration
Is Busy?
Note
Public description
Primary Participant
Participants
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File Name
Deal
Person
Organization
Product
Activity ID
Note ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Person
Organization
Owner
Note
Pin note to lead
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
Source Channel ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product NameRequired
Product Code
Description
Unit
Tax percentage
Category
Owner
Is Linkable
Currency
Price
Direct cost
Overhead Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
ProjectRequired
Description
Done
Due Date
Assignee
Parent Task
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ActivityRequired
Subject
Owner
Organization
Deal
Lead
Project
Mark as done
Type
Use combined date and time field?
Duration
Is Busy?
Note
Public description
Primary Participant
Participants
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Title
Owner
Organization
Person
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Null
PersonRequired
Name
Emails
Phones
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProjectRequired
Title
Project Board
Project Phase
Description
Status
Owner
Start Date
End Date
Deals
Organization
Person
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PersonRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch termRequired
Exact Match
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TermRequired
Exact Match?
Assignee
Project
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appSubjectRequired
Search Type
Owner
Filter
Mark as done
Organization
Deal
Lead
Project
Type
Use combined date and time field?
Duration
Is Busy?
Note
Public description
Primary Participant
Participants
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
TitleRequired
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
NameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch termRequired
Exact Match
Product NameRequired
Product Code
Description
Unit
Tax percentage
Category
Owner
Is Linkable
Currency
Price
Direct cost
Overhead Cost
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFileRequired
Convert to Document?
File Name
Drive
Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Parent Folder
Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File NameRequired
File ContentRequired
Convert to Document?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
File IdRequired
Sharing PreferenceRequired
Organization Domain
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File to Replace
File/Folder Name
Rename Folder?
Extension Copy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Retrieve Files from Google Drive
This action sends a GET request to the Google Drive API to retrieve a list of files based on specific query parameters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
File or Folder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Filename
Search Type
Drive
Folder
File Types
Maximum Number of Results
ActionThis is an event a Zap performs.SearchFind existing data in your appFilenameRequired
Search Type
Drive
Folder
File Types
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Pipedrive + Google Sheets + Google Drive Integrations Work
- Step 1: Authenticate Pipedrive, Google Sheets, and Google Drive.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.