How to connect Google Sheets + Intercom + Pipedrive
Zapier lets you send info between Google Sheets and Intercom and Pipedrive automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Intercom + Pipedrive
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 Google Sheets, Intercom, and Pipedrive. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
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.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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 foundLead Converted to User
Triggers when a lead converts to a user.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Replied
Triggers when a Contact replies to a Conversation in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Conversation Rating
Triggers when a conversation receives a rating.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Company
Triggers when a new Company is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Ticket
Triggers when a new Ticket is created in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.UpdatesRequired
Update sample
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact identifier typeRequired
Tag selection method
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event nameRequired
Created at
Contact identifier typeRequired
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket typeRequired
Contact IDRequired
Company ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Conversation IDRequired
Reply TypeRequired
Reply BodyRequired
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FromRequired
ToRequired
Message TypeRequired
BodyRequired
Subject
Template
Create Conversation Without Contact Reply?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead ID
Full Name
Email
Phone Number
Unsubscribed From Emails
Created At
IP Address
Custom Attributes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lookup EmailRequired
Full Name
User ID
Company ID
Unsubscribed From Emails
Phone Number
Created At
IP Address
Custom Attributes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search FieldRequired
Match TypeRequired
Conversation Status
Updated After
Updated Before
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Match TypeRequired
Ticket State
Updated After
Updated Before
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Mode
Search Value
User Association Note
Company NameRequired
Plan
Size
Website
Industry
Custom Attributes
Monthly Revenue
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Deal
Triggers when a new deal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a Lead is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Organization
Triggers when a new organization is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Person
Triggers when a new person is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapScheduledZapier 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.DealRequired
ProductRequired
PriceRequired
QuantityRequired
Discount
Discount Type
Comments
Is enabled?
Tax Method
Tax Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Creation Date
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FollowerRequired
What to add follower to?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContentRequired
Deal
Pin note on specified deal?
Person
Pin note on specified person?
Organization
Pin note on specified organization?
Lead
Pin note on specified lead?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Owner
Organization
Email
Phone
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.ActivityRequired
Subject
Organization
Assign To
Person
Deal
Lead
Is Done?
Type
Use combined date and time field?
Duration
Free/Busy
Note
Public Description
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.PersonRequired
Name
Owner
Organization
Email
Phone
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
Type
Filter
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search By
Term to search forRequired
Search for an Exact Match?
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 appNote IDRequired
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 termRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
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 appSearch for an Exact Match?
TitleRequired
Creation Date
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
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 for an Exact Match?
TitleRequired
Person
Organization
Owner
Note
Pin Note to Lead?
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
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 for an Exact Match?
NameRequired
Owner
Organization
Email
Phone
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Search TermRequired
Exact Match
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.Search or writeFind existing data in your app, or create a new record if no data is found
No 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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
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.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
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 foundLead Added Email
Triggers when a Lead enters an email address.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a new Lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Conversation
Triggers when a new Conversation is created by a User in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New User
Triggers when a new User is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact
Triggers when a Contact is updated in Intercom.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
Note TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact TypeRequired
Message BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User Association Note
CompanyRequired
Warning
Name
Website
Size
Monthly Revenue
Plan
Industry
Custom Attributes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact identifier typeRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Identifier
Message BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Tag NameRequired
Untag?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
Title
Description
State
Is Open
Snoozed Until
Assigned Admin
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Custom Attributes
Created At
User ID
Full Name
IP Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search Mode
Search Value
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ModeRequired
Search ValueRequired
Lead ID
Full Name
Email
Phone Number
Unsubscribed From Emails
Created At
IP Address
Custom Attributes
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Note
Triggers when a new note is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Organization
Triggers when an existing organization is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPersonRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Organization
Assign To
Person
Deal
Lead
Is done?
Type
Use combined date and time field?
Duration
Free/Busy
Note
Public Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File NameRequired
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Owner
Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Code
Unit
Tax percentage
Is active?
Owner
Currency
Price
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.DealRequired
Title
Status
Stage
Owner
Organization
Person
Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Owner
Name
Address
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.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson
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 for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Product(s)
Finds a product or products by name, ID, or product code (with line item support).
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
Assign To
Type
Filter
Is done?
Organization
Person
Deal
Lead
Use combined date and time field?
Duration
Free/Busy
Note
Public Description
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search By
Term to search forRequired
Search for an Exact Match?
TitleRequired
Creation Date
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
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 for an Exact Match?
NameRequired
Owner
Address
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
NameRequired
Code
Unit
Tax percentage
Is active?
Owner
Currency
Price
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 found
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Google Sheets + Intercom + Pipedrive Integrations Work
- Step 1: Authenticate Google Sheets, Intercom, and Pipedrive.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.