Connect Google Sheets and Intercom to unlock the power of automation
- No credit card required
- Free forever for core features
- 14-day trial for premium features and apps
Set up your first integration
Quickly connect Google Sheets to Intercom with a Zapier template.
Our most popular template
How Zapier works
Zapier makes it easy to integrate Google Sheets with Intercom - no code necessary. See how you can get setup in minutes.
Choose a trigger
A trigger is the event that starts your Zap—like a "New Spreadsheet Row (Team Drive)" from Google Sheets.
Add your action
An action happens after the trigger—such as "Add Note" in Intercom.
You’re connected!
Zapier seamlessly connects Google Sheets and Intercom, automating your workflow.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Frequently Asked Questions about Google Sheets + Intercom integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google Sheets and Intercom
How can I set up a trigger in Google Sheets to create a contact in Intercom?
You can set up a trigger in Google Sheets so that when a new row is added, it automatically creates a contact in Intercom. You would define the trigger based on the addition of rows and map the relevant Google Sheets columns to the Intercom fields for contact creation.
What actions are supported when integrating Google Sheets with Intercom?
We support actions like creating or updating contacts, adding notes, and tagging contacts in Intercom directly from changes made in your Google Sheets. You can also send lead data from Sheets to automatically populate within Intercom.
Is it possible to update an existing contact in Intercom via changes made in Google Sheets?
Yes, you can update an existing contact by setting up an action that syncs changes in specified Google Sheets cells directly to the fields of a contact already existing in your Intercom database.
Can I use data from multiple columns in Google Sheets to trigger actions in Intercom?
Certainly! Our integration allows mapping multiple columns from your spreadsheet as inputs for various actions within Intercom. For instance, you could use several data points such as name, email, and phone number all at once when creating or updating contacts.
How do I configure automated notes addition to contacts on Intercom using data from Google Sheets?
Automated note addition involves setting a trigger when specific data is added or modified in your sheet. This data can then be formatted as notes which are appended automatically to corresponding contacts within your Intercom system.
What happens if there are duplicates while importing contacts from Google Sheets into Intercom?
When duplicates are encountered during importation, we provide options for either overwriting existing information or ignoring duplicates based on unique identifiers like email addresses. You choose how best to handle these scenarios through our settings.
Are there limitations on the amount of data that can be synchronized at one time between Google Sheets and Intercom?
While we handle significant volumes of data efficiently, we recommend batching large updates due to potential rate limits imposed by APIs. Segmenting larger datasets into smaller portions ensures smoother synchronization processes without interruptions.
Practical ways you can use Google Sheets and Intercom
Track new customer conversations in a spreadsheet
For business owners who want to analyze customer interactions, when a new conversation is initiated in Intercom, Zapier can log essential details into a Google Sheet automatically. This helps in identifying trends and improving future communication strategies.
Business OwnerUpdate support spreadsheet with new Intercom tickets
Enhance support tracking by automatically adding new Intercom tickets to a Google Sheet. Zapier ensures every ticket is recorded for proper task assignment and progress visibility.
Customer Support OpsLog new marketing leads from Intercom into Google Sheets
For keeping marketing organized, when a new lead is created in Intercom, Zapier records the details into a Google Sheet. This ensures transparency and easy accessibility for the marketing team to manage leads better.
Marketing & Marketing OpsSupported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerPolling- Drive
Try ItTriggerPolling- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerInstant- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionWrite
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerInstant- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerPolling- Drive
- SpreadsheetRequired
Try ItTriggerPolling- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionWrite
