)
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 News Feed data from Intercom into Excel helps you analyze customer communications and optimize engagement strategies. Coefficient makes this process seamless and automatic.
This guide will show you how to import your Intercom News Feed 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 Feed 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 Feed 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 News Feed 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 Feed” 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 News Feed 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 News Feed from Intercom?
To get News Feed data from Intercom, you would typically need to navigate through their interface or use their API. This process can be technical and time-consuming.Coefficient simplifies this by providing a direct connection between Intercom and Excel, allowing you to import News Feed data with just a few clicks.
-
How do I get a list of News Feed in Intercom?
In the Intercom platform, you can access the News Feed section to view recent updates. However, extracting this as a comprehensive list for analysis is challenging.With Coefficient, you can pull a complete list of News Feed data from Intercom directly into Excel, making it easy to analyze and share with your team.
-
How do I import News Feed from Excel to Intercom?
Intercom allows limited data importing through CSV uploads, but the process can be cumbersome and error-prone.Coefficient’s two-way sync feature enables you to push updates from Excel back to Intercom seamlessly, ensuring your data stays consistent across platforms.
-
How do I update News Feed from Excel to Intercom?
Updating News Feed data in Intercom typically requires manual entry or complex API integration.With Coefficient, you can edit your News Feed data in Excel and sync those changes back to Intercom with a single click, saving time and reducing the risk of errors.
-
How to automate importing Intercom News Feed to Excel daily?
Manual imports from Intercom to Excel are time-consuming and need to be repeated regularly to keep data current.Coefficient offers scheduled auto-refresh functionality that automatically updates your News Feed data daily, ensuring you always have the latest information without any manual effort.
Trusted By Over 50,000 Companies
