The Scenario
You lead documentation at a mid-size SaaS company. Every quarter you do a content refresh — reviewing which help center articles are stale, which are getting traffic, and which need to be archived. The review happens in a spreadsheet. The source of truth is Intercom's help center.
Getting the article list into the sheet is where the quarter always starts late.
The bad version:
- Log into Intercom, go to the help center, click into each collection one at a time, note the article title and last-updated date in a spreadsheet row.
- Realize you missed two collections and have to scroll back through the hierarchy to find them.
- Finish 40 minutes later with a list of 60 articles that is missing the author column because Intercom's UI buries that information three clicks deep.
You have a deadline for the refresh plan. The content audit was supposed to be done before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the Intercom help center and writes every article's metadata directly into the sheet.
List all published Intercom help center articles and write them to this sheet — include article ID, title, collection name, author, published status, and last updated date — start at row 2.
What You Get
- Every published article written to the sheet, one row per article.
- Article ID in column A, title in column B, collection name in column C, author in column D, published status in column E, last updated date in column F.
- All collections covered automatically — no need to navigate the help center hierarchy manually.
- Articles sorted by collection name by default, making it easy to group-review by product area.
What If the Data Is Not Quite Ready
You want draft articles included too, not just published ones
The refresh should cover everything — published, draft, and archived — so nothing gets missed.
List all Intercom help center articles regardless of published status and write them to this sheet — include article ID, title, collection name, author, published status, and last updated date — sort by status then by last updated date ascending.
You need to flag articles that have not been updated in more than 90 days
The threshold for "stale" is 90 days with no edits.
Export all Intercom help center articles with their ID, title, collection, author, and last updated date — add a column called "Stale" and mark "yes" for any article where last updated date is more than 90 days ago, otherwise leave it blank.
The audit needs to cover only one collection
You are only responsible for the "Getting Started" collection this quarter.
List all Intercom help center articles in the collection named "Getting Started" — include article ID, title, author, published status, and last updated date — write to this sheet starting at row 2.
Pull all articles, flag stale ones, and compute days-since-update in one pass
You want the complete audit-ready sheet without any post-import formulas.
Export all Intercom help center articles with article ID, title, collection, author, published status, and last updated date — compute days since last update as of today and write to a "Days Since Update" column — mark "stale" in a final column for anything over 90 days — sort by days since update descending.
One prompt delivers the list, the age calculation, and the stale flag together.
Try It
Get the 7-day free trial of SheetXAI and open a fresh Google Sheet at the start of your next content quarter — ask it to pull the full Intercom article list in one shot. For populating the Fin AI content library with updated articles, see that spoke and the Intercom hub overview.