How to connect Google Sheets + Intercom + Salesforce
Zapier lets you send info between Google Sheets and Intercom and Salesforce 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 + Salesforce
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 Salesforce. 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.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
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.TitleRequired
Description
Body
AuthorRequired
State
Parent Collection
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.Api Docs Info
Apply standard error handling?Required
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.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 appConversation IDRequired
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 Contact
Triggers when a new Contact is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
Record (Optional)
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Outbound Message
Triggers when a new outbound message is received in Salesforce.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Disclaimer
Salesforce ObjectRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCampaignRequired
ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
LeadRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Salesforce ObjectRequired
Description
Attachment visibility
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Contact
Creates a new contact.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Title
Description
Salesforce Object
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note TitleRequired
Note
Salesforce ObjectRequired
Note Visibility
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Use Assignment Rules
Allow Duplicates
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ToRequired
CC
BCC
SubjectRequired
Email FormatRequired
Sender TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Record to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent ObjectRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Search Results
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
SOQL WHERE ClauseRequired
Sort by
Sort Order
Maximum Number of Records
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Search ValueRequired
Second Field to Search By
Second Search Value
Search Operator
Use Assignment Rules
Allow Duplicates
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.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.Apply standard error handling?Required
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 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.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 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 Case Attachment
Triggers when a new Attachment is added to a case.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Lead
Triggers when a new Lead is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
RecordRequired
FileRequired
VisibilityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
AccountRequired
Opportunity
Create new opportunity?
Converted StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent ObjectRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note TitleRequired
Note ContentRequired
Salesforce Object
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Use Assignment Rules
Allow Duplicates
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Warning
Salesforce ObjectRequired
Record IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact to UpdateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Record to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Apply standard error handling?Required
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.Salesforce ObjectRequired
Search ValueRequired
Second Field to Search By
Second Search Value
Search Operator
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
SOQL WHERE clauseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Record IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
SOQL WHERE ClauseRequired
Sort by
Sort Order
Maximum Number of Records
Use Assignment Rules
Allow Duplicates
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 + Salesforce Integrations Work
- Step 1: Authenticate Google Sheets, Intercom, and Salesforce.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.