)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Importing Articles data from Intercom into Excel helps you analyze content performance and optimize your knowledge base strategy. Coefficient makes this process seamless and automatic.
This guide will show you how to import your Intercom Articles 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 Articles object to import.
-
Step 3:
Step 3. (Optional) Enable auto-refresh to keep your data updated automatically.
Step-by-Step Guide to Import Intercom Articles 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
Step 2: Connect to Intercom and Import Articles 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 “Articles” from the list of available objects
- Choose the fields you want to import
- Click “Import” to bring the data into your Excel spreadsheet
Step 3: Set Up Auto-Refresh (Optional)
To keep your Articles 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
Available Intercom Objects
- Teams
- Company Segments
- Conversations
- All Help Centers
- All Collections
- News Items
- Tickets
- Articles
- Companies
- Contacts
Related Intercom Use Cases
How to Import Company Segments Data from Intercom into Google Sheets
Learn how to import live Intercom Company Segments data into Google Sheets using Coefficient for better segmentation analysis and reporting.
How to Import All Help Centers Data from Intercom into Google Sheets
Learn how to import live Intercom Help Centers data into Google Sheets using Coefficient for better knowledge base management and reporting.
How to Import News Items Data from Intercom into Google Sheets
Learn how to import live Intercom News Items data into Google Sheets using Coefficient for better announcement tracking and analysis.
Frequently Asked Questions
-
How to get Articles from Intercom?
Accessing article data in Intercom requires navigating through their help center management interface, which doesn’t easily provide comprehensive metrics for analysis.Coefficient creates a direct connection between Intercom and Excel, allowing you to import Articles data with just a few clicks for immediate performance analysis.
-
How do I get a list of Articles in Intercom?
Within Intercom, you can browse through articles in their help center interface, but compiling a complete list with performance metrics for analysis is challenging.With Coefficient, you can pull a comprehensive list of all Articles from Intercom directly into Excel, making it easy to track view counts and optimize your content strategy.
-
How do I import Articles from Excel to Intercom?
Creating new articles in Intercom typically requires working through their content management interface, which is time-consuming for planning comprehensive documentation.Coefficient’s two-way sync functionality allows you to draft article content and metadata in Excel and push it back to Intercom, streamlining your content creation workflow.
-
How do I update Articles from Excel to Intercom?
Updating article details in Intercom requires navigating through their content management system for each individual change.With Coefficient, you can make bulk edits to your Articles data in Excel and sync those changes back to Intercom in one action, saving significant time for content teams.
-
How to automate importing Intercom Articles to Excel daily?
Manually exporting article data from Intercom on a regular basis is time-consuming and often results in outdated content performance analysis.Using Coefficient’s auto-refresh feature, you can schedule daily updates of your Articles data, ensuring your content reports always reflect the most current performance metrics.
Trusted By Over 50,000 Companies
