The Scenario
You are a documentation manager at an enterprise software company. Your team published 100 pages across three Confluence spaces in the past year. The VP of Documentation wants to know which pages are driving value before the annual budget review. She wants like counts and last-modified dates for all 100 pages in an Excel workbook, ranked by popularity, by Thursday.
You have 100 page IDs in column A of the workbook. It is Tuesday morning.
The bad version of the next two days:
- Open the first Confluence page, scroll to the bottom, find the like count
- Note it in the workbook, note the last-modified date
- Repeat 99 more times
- Wednesday afternoon, realize Confluence does not display like counts prominently on some page types
- Spend an hour figuring out where the counts live for those pages
- Hand in a partially complete workbook Thursday and ask for more time.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the page ID column and fetches engagement metrics from Confluence directly into the workbook.
Open the SheetXAI sidebar and type:
For each Confluence page ID in column A, fetch the like count and write it to column B. Also fetch the last-modified date and write it to column C. Sort the entire workbook by column B descending so the most popular pages are at the top.
SheetXAI calls Confluence once per row, fills columns B and C for all 100 pages, and sorts the workbook. You hand the ranked list to the VP by Wednesday afternoon.
What You Get
A ranked engagement report in the workbook:
- Column B — like count per page
- Column C — last-modified date
- Rows sorted by like count — highest engagement at the top
- 100 rows filled — no manual navigation
Zero-like pages are at the bottom. Pages worth investing in are at the top. You can see the distribution in one glance.
From here, run a second prompt to pull page titles and URLs alongside the IDs, or flag pages with zero likes as archive candidates.
What If the Data Is Not Quite Ready
Engagement reports have their own layers. SheetXAI handles them in the same prompt.
When you need page titles alongside the metrics
The VP wants page names in the report, not just numeric IDs.
For each page ID in column A, fetch the page title, like count, and last-modified date. Write the title into column B, the like count into column C, and the last-modified date into column D. Sort by like count descending.
When you want results in a separate ranked tab
The workbook already has data you do not want to disturb. Put the engagement report in a new tab.
For each page ID in column A, fetch the page title, like count, and last-modified date. Create a new tab called "Engagement Ranking" and write the results there with headers. Sort by like count descending.
When you want to flag zero-like stale pages for archiving
Pages with no engagement and no recent edits are the strongest archive candidates.
For each page ID in column A, fetch the like count and last-modified date. Write them into columns B and C. For any page with zero likes and a last-modified date more than one year ago, write "archive candidate" into column D. Sort by column B descending.
When you need the engagement data plus a summary Confluence page for the VP
The VP wants a Confluence page she can share with her manager without sending the workbook.
For each page ID in column A, fetch the page title, like count, and last-modified date. Write them into columns B, C, and D. Sort by like count descending. Then create a Confluence page in the Documentation space titled "Content Engagement Report — [current month and year]" summarizing the top 10 pages by likes, the count of zero-like pages, and the average like count across all 100 pages. Write the Confluence URL into cell E1.
The pattern: pull the engagement data and publish the report in one prompt. The workbook is both the source of truth and the working layer for the Confluence output.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Confluence page IDs, then ask it to pull the like counts. The Confluence integration is included in every SheetXAI plan. For related workflows, see how to export a Confluence space inventory for a content audit or the Confluence in Excel overview.