How to Import Company Segments Data from Intercom into Google Sheets

Accessing your Intercom Company Segments data in Google Sheets helps you analyze your customer base and refine your segmentation strategy.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Company Segments data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the Company Segments object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your company segments data current automatically.

Importing your Intercom Company Segments data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom Company Segments Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “Company Segments” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom Company Segments data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Company Segments data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import All Help Centers Data from Intercom into Google Sheets

Accessing your Intercom Help Centers data in Google Sheets helps you manage your knowledge base structure and report on content organization.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Help Centers data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the All Help Centers object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your help centers data current automatically.

Importing your Intercom Help Centers data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom All Help Centers Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “All Help Centers” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom All Help Centers data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Help Centers data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import News Items Data from Intercom into Google Sheets

Bringing your Intercom News Items data into Google Sheets helps you track announcement performance and analyze engagement.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom News Items data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the News Items object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your news items data current automatically.

Importing your Intercom News Items data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom News Items Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “News Items” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom News Items data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your News Items data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import Tickets Data from Intercom into Google Sheets

Bringing your Intercom Tickets data into Google Sheets helps you analyze support volume, resolution times, and ticket trends.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Tickets data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the Tickets object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your tickets data current automatically.

Importing your Intercom Tickets data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom Tickets Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “Tickets” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom Tickets data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Tickets data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import Articles Data from Intercom into Google Sheets

Accessing your Intercom Articles data in Google Sheets helps you manage your knowledge base content and report on article performance.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Articles data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the Articles object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your articles data current automatically.

Importing your Intercom Articles data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom Articles Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “Articles” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom Articles data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Articles data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import Companies Data from Intercom into Google Sheets

Accessing your Intercom Companies data in Google Sheets helps you manage company information, analyze customer accounts, and build reports.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Companies data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the Companies object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your companies data current automatically.

Importing your Intercom Companies data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom Companies Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “Companies” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom Companies data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Companies data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import Contacts Data from Intercom into Google Sheets

Accessing your Intercom Contacts data in Google Sheets helps you manage user information, analyze customer profiles, and build reports.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Contacts data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the Contacts object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your contacts data current automatically.

Importing your Intercom Contacts data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom Contacts Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “Contacts” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom Contacts data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Contacts data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import Teams Data from Intercom into Google Sheets

Accessing your Intercom Teams data in Google Sheets helps you manage team structures and report on team performance.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom Teams data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the Teams object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your teams data current automatically.

Importing your Intercom Teams data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom Teams Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “Teams” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom Teams data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your Teams data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import News Feed Data from Intercom into Google Sheets

Bringing your Intercom News Feed data into Google Sheets helps you track announcement performance and analyze engagement.

Instead of manual exports, you can set up a live connection that updates automatically.

This guide shows you how to import your Intercom News Feed data into Google Sheets using Coefficient.

TLDR

  • Step 1:

    Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Intercom account.

  • Step 2:

    Step 2. Select Import from… and choose the News Feed object from Intercom.

  • Step 3:

    Step 3. Configure your import settings and pull the data into your sheet.

  • Step 4:

    Step 4. Set up auto-refresh to keep your news feed data current automatically.

Importing your Intercom News Feed data into Google Sheets is simple with Coefficient. Follow these steps to get started:

Step 1: Install and Connect Coefficient

First, you need to add Coefficient to your Google Sheet.

  • Open Google Sheets.
  • Go to Extensions > Add-ons > Get add-ons.
  • Search for “Coefficient” and install it from the Google Workspace Marketplace.

Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.

In the Coefficient sidebar, click “Import from…” and find Intercom in the list of connectors. You’ll be guided to connect your Intercom account securely.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Intercom News Feed Data

After connecting, you’ll see options for importing data from Intercom.

  • Select “Objects”.
  • Choose “News Feed” from the list of available objects.

You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.

Your Intercom News Feed data will load directly into your Google Sheet.

CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your News Feed data in Google Sheets always up to date, set up an automatic refresh schedule.

In the Coefficient sidebar, find your imported data.

  • Click the “Refresh” button or the three-dot menu next to your import.
  • Select “Schedule Refresh”.
  • Choose your desired frequency (e.g., daily, hourly, weekly) and time.

Coefficient will now automatically update your sheet with the latest data from Intercom based on your schedule.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts

How to Import News Items Data from Intercom into Excel

Importing News Items data from Intercom into Excel helps you analyze announcement performance and optimize your communication strategy. Coefficient makes this process seamless and automatic.

This guide will show you how to import your Intercom News Items data into Excel using Coefficient.

TLDR

  • Step 1:

    Step 1. Open Excel > Insert tab > Get Add-ins > Install Coefficient from Office Add-ins store.

  • Step 2:

    Step 2. Connect your Intercom account and select the News Items object to import.

  • Step 3:

    Step 3. (Optional) Enable auto-refresh to keep your data updated automatically.

Step-by-Step Guide to Import Intercom News Items Data into Excel

Step 1: Install Coefficient in Excel

First, you need to install the Coefficient add-in from the Office Add-ins store:

  • Open Excel
  • Go to the Insert tab
  • Click on Get Add-ins
  • Search for “Coefficient”
  • Click Add to install the add-in
  • Once installed, click on the Coefficient icon to open the sidebar
Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Connect to Intercom and Import News Items Data

Now, connect Coefficient to your Intercom account:

  • In the Coefficient sidebar, click on “Import from…”
  • Scroll to find and select “Intercom” from the list of available connectors
  • Log in with your Intercom credentials when prompted
  • Once connected, select “News Items” from the list of available objects
  • Choose the fields you want to import
  • Click “Import” to bring the data into your Excel spreadsheet
CRM and sales connectors like Salesforce, HubSpot, Pipedrive, and Gong shown in list view.

Step 3: Set Up Auto-Refresh (Optional)

To keep your News Items data up to date automatically:

  • Click on the three dots (…) next to your imported data
  • Select “Auto-refresh”
  • Choose your preferred refresh schedule (hourly, daily, or weekly)
  • Click “Save” to activate auto-refresh
Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

Available Intercom Objects

  • Teams
  • Company Segments
  • Conversations
  • All Help Centers
  • All Collections
  • News Items
  • Tickets
  • Articles
  • Companies
  • Contacts