Google BigQuery + Intercom

Run queries in Google BigQuery whenever new companies emerge in Intercom

Streamline your data management with this workflow. Whenever a new company is added in Intercom, a corresponding query gets executed in Google BigQuery. This automation not only enhances your data analysis and reporting capabilities but also ensures complete and up-to-date records, saving you valuable time from manual work. Utilize your database to its full potential with this smart solution.

When this happens...
New Company
Triggers when a new Company is created.
TriggerInstant
automatically do this!
Run a Query
Runs a SQL query against a table in BigQuery.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

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
- EmailRequired
- Note TextRequired
Action
Write
- TitleRequired
- Description
- Body
- AuthorRequired
- State
- Parent Collection
Action
Write
- Event nameRequired
- Created at
- Contact identifier typeRequired
- Metadata
Action
Write
- Ticket typeRequired
- Contact IDRequired
- Company ID
Action
Write
- Conversation IDRequired
- Reply TypeRequired
- Reply BodyRequired
- Attachments
Action
Write
- FromRequired
- ToRequired
- Message TypeRequired
- BodyRequired
- 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 EmailRequired
- Full Name
- User ID
- Company ID
- Unsubscribed From Emails
- Phone Number
- Created At
- IP Address
- Custom Attributes
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Search FieldRequired
- Match TypeRequired
- Conversation Status
- Updated After
- Updated Before
Action
Search
- Search FieldRequired
- Match TypeRequired
- Ticket State
- Updated After
- Updated Before
Action
Search
- Conversation IDRequired
Action
Search
- Search ModeRequired
- Search ValueRequired
- Lead ID
- Full Name
- Email
- Phone Number
- Unsubscribed From Emails
- Created At
- IP Address
- Custom Attributes
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
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
- UpdatesRequired
- Update sample
Trigger
Instant
Try It
New Unsubscription
Triggers when a user unsubscribes from Intercom.io emails.
Trigger
Instant
Try It
- Contact identifier typeRequired
- Tag selection method
Action
Write
- Contact TypeRequired
- Message BodyRequired
Action
Write
- User Association Note
- CompanyRequired
- Warning
- Name
- Website
- Size
- Monthly Revenue
- Plan
- Industry
- Custom Attributes
Action
Write
- Contact identifier typeRequired
- TagRequired
Action
Write
- Contact Identifier
- Message BodyRequired
Action
Write
- CompanyRequired
- Tag NameRequired
- Untag?
Action
Write
- TicketRequired
- Title
- Description
- State
- Is Open
- Snoozed Until
- Assigned Admin
Action
Write
- EmailRequired
- Custom Attributes
- Created At
- User ID
- Full Name
- IP Address
Action
Write
- Search Mode
- Search Value
Action
Search
- Search ModeRequired
- Search ValueRequired
Action
Search
- Search ModeRequired
- Search ValueRequired
Action
Search
- Search Mode
- Search Value
- User Association Note
- Company NameRequired
- Plan
- Size
- Website
- Industry
- Custom Attributes
- Monthly Revenue
Action
Search or write
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

About Google BigQuery

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

Learn more

Related categories

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 more

Related categories

Customer Support

Similar apps

HubSpot

Marketing Automation

Inbound Now

Marketing Automation, WordPress

Related Zap Templates

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

Related Zap Templates

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

Google BigQuery + Intercom

Run queries in Google BigQuery whenever new companies emerge in Intercom

Lead Added Email

New Lead

Tag Added to Lead

New AI Summary

New Company

New Ticket

Tag Added to Conversation

Updated Contact

Tag Added to User

Add Note

Create Article

Create Data Event

Create Ticket

Reply to Conversation

Send Message to Contact

Create/Update Lead

Create/Update User

API Request (Beta)

Find Conversation

Find Ticket

Retrieve a Conversation

Find or Create Lead

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

Lead Converted to User

Contact Replied

New Conversation Rating

New Closed Conversation

New Conversation

New User

Updated Company

Updated Ticket

New Unsubscription

Add Tag to Contact

Create Conversation

Create or Update Company

Remove Tag From Contact

Send Incoming Message

Add/Remove Tag on Company

Update Ticket

Create User

Find Company

Find Lead

Find User

Find or Create Company

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

About Google BigQuery

Related categories

About Intercom

Related categories

Similar apps

HubSpot

Inbound Now

Related Zap Templates

Related Zap Templates