How to Export Intercom Data to Google BigQuery?

Question

We’re trying to export Intercom data to Google BigQuery to run more advanced analytics. Right now, we can only view basic reports in Intercom, but we want to analyze conversation trends, response times, and customer behavior alongside other data in BigQuery.Ideally, we need a way to:Regularly sync Intercom conversations, user attributes, and events into BigQuery.	Structure the data properly so it’s easy to query.	Avoid manual exports and keep everything automated.	What’s the best approach to get this data into BigQuery?

TomOlis · Accepted Answer

One option is using Intercom’s API to extract data and load it into BigQuery, but this requires setting up a custom pipeline and ongoing maintenance. Another approach is using Google Cloud Functions to pull data on a schedule, but that still requires coding. If you're looking for an automated solution without manual work, Skyvia can sync Intercom data with BigQuery without coding.

RobertYoung · Answer

One option is using Intercom’s API to extract data and load it into BigQuery, but this requires setting up a custom pipeline and ongoing maintenance. Another approach is using Google Cloud Functions to pull data on a schedule, but that still requires coding. If you're looking for an automated solution without manual work, Skyvia can sync Intercom data with BigQuery without coding.Thanks, we'll try these options!

Join the Intercom Community 🎉

Intercom Customers and Employees

Login to the community

Intercom Customers and Employees

Scanning file for viruses.

This file cannot be downloaded