Google BigQuery + Intercom

Google BigQuery + Intercom integrations

Create or update Intercom users whenever new rows are added to Google BigQuery

This workflow helps you streamline your user management in Intercom by capturing new row information from Google BigQuery. As soon as fresh data appears there, this automation instantly creates or updates a user profile in Intercom. It is an efficient solution for maintaining up-to-date communication with your users by utilizing your BigQuery data.

When this happens...
New RowTriggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
TriggerPolling
automatically do this!
Create/Update UserUpdate a user within Intercom given their e-mail address.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google BigQuery and Intercom

Discover other triggers and actions you can use with Google BigQuery and Intercom

- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write

- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

Lead Added Email
Triggers when a Lead enters an email address.
Trigger
Instant
Try It
New Lead
Triggers when a new Lead is created.
Trigger
Instant
Try It
- Which Tag?
Trigger
Instant
Try It
New AI Summary
Triggers when an AI-generated summary is created for a conversation in Intercom.
Trigger
Instant
Try It
New Company
Triggers when a new Company is created.
Trigger
Instant
Try It
New Ticket
Triggers when a new Ticket is created in Intercom.
Trigger
Instant
Try It
- Tag
Trigger
Instant
Try It
Updated Contact
Triggers when a Contact is updated in Intercom.
Trigger
Instant
Try It
- Which Tag?
Trigger
Instant
Try It
- Email
  Required
- Note Text
  Required
Action
Write
- Title
  Required
- Description
- Body
- Author
  Required
- State
- Parent Collection
Action
Write
- Event name
  Required
- Created at
- Contact identifier type
  Required
- Metadata
Action
Write
- Ticket type
  Required
- Contact ID
  Required
- Company ID
Action
Write
- Conversation ID
  Required
- Reply Type
  Required
- Reply Body
  Required
- Attachments
Action
Write
- From
  Required
- To
  Required
- Message Type
  Required
- Body
  Required
- Subject
- Template
- Create Conversation Without Contact Reply?
Action
Write
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
Action
Write
- Lookup Email
  Required
- Full Name
- User ID
- Company ID
- Unsubscribed From Emails
- Phone Number
- Created At
- IP Address
- Custom Attributes
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Search Field
  Required
- Match Type
  Required
- Conversation Status
- Updated After
- Updated Before
Action
Search
- Search Field
  Required
- Match Type
  Required
- Ticket State
- Updated After
- Updated Before
Action
Search
- Conversation ID
  Required
Action
Search
- Search Mode
  Required
- Search Value
  Required
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
Action
Search or write

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write
Lead Converted to User
Triggers when a lead converts to a user.
Trigger
Instant
Try It
Contact Replied
Triggers when a Contact replies to a Conversation in Intercom.
Trigger
Instant
Try It
New Conversation Rating
Triggers when a conversation receives a rating.
Trigger
Instant
Try It
- Message body format
Trigger
Instant
Try It
New Conversation
Triggers when a new Conversation is created by a User in Intercom.
Trigger
Instant
Try It
New User
Triggers when a new User is created.
Trigger
Instant
Try It
Updated Company
Triggers when a company is updated.
Trigger
Instant
Try It
- Updates
  Required
- Update sample
Trigger
Instant
Try It
New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Trigger
Instant
Try It
- Contact identifier type
  Required
- Tag selection method
Action
Write
- Contact Type
  Required
- Message Body
  Required
Action
Write
- User Association Note
- Company
  Required
- Warning
- Name
- Website
- Size
- Monthly Revenue
- Plan
- Industry
- Custom Attributes
Action
Write
- Contact identifier type
  Required
- Tag
  Required
Action
Write
- Contact Identifier
- Message Body
  Required
Action
Write
- Company
  Required
- Tag Name
  Required
- Untag?
Action
Write
- Ticket
  Required
- Title
- Description
- State
- Is Open
- Snoozed Until
- Assigned Admin
Action
Write
- Email
  Required
- Custom Attributes
- Created At
- User ID
- Full Name
- IP Address
Action
Write
- Search Mode
- Search Value
Action
Search
- Search Mode
  Required
- Search Value
  Required
Action
Search
- Search Mode
  Required
- Search Value
  Required
Action
Search
- Search Mode
- Search Value
- User Association Note
- Company Name
  Required
- Plan
- Size
- Website
- Industry
- Custom Attributes
- Monthly Revenue
Action
Search or write

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

About Intercom

Intercom is the Engagement OS, an open channel between customer and business that is in the product, in the moment, and on their terms. We break down silos, unifying data and systems to create an ongoing dialogue, so companies can make the most of every opportunity.

Learn moreLearn moreHelpHelp

Related categories

Customer Support

Similar apps

HubSpot

Marketing Automation

Inbound Now

Marketing Automation, WordPress

Related Zap Templates

Run queries in Google BigQuery whenever new companies emerge in Intercom

Create new rows in Google BigQuery when new tags are added to users in Intercom