The Scenario
You are a documentation manager. Your team published 100 pages across three Confluence spaces over the past year. The Head of Content wants to know which pages are actually being used before budget discussions next month, and she wants the data in a sheet with pages ranked by popularity.
You have a sheet with 100 page IDs in column A. You need like counts and last-modified dates for all of them.
The bad version of the next two hours:
- Open the first Confluence page by ID, scroll to the bottom, count the likes, note the last-modified date
- Switch to your sheet, type the numbers into columns B and C
- Repeat 99 more times
- Realize Confluence does not display like counts prominently on every page type
- Spend 30 minutes figuring out where the counts are for a specific page format
- Finish with a partially filled sheet and no confidence in the numbers.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the page ID column and fetches the engagement metrics from Confluence directly into the sheet.
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. Then sort the entire sheet by column B descending so the most popular pages are at the top.
SheetXAI calls Confluence once per row, pulls the like count and last-modified date for all 100 pages, fills columns B and C, and sorts the sheet. You hand the ranked list to the Head of Content.
What You Get
A ranked engagement report in the sheet:
- Column B — like count per page
- Column C — last-modified date
- Rows sorted by like count — most popular at the top
- 100 rows filled — no manual navigation required
You can see immediately which pages have zero likes and which have forty. The pages that nobody uses are at the bottom. The pages worth investing in are at the top.
From here, you can add a second SheetXAI prompt to pull the page titles and URLs from the IDs in column A, or to flag pages with zero likes as candidates for archiving.
What If the Data Is Not Quite Ready
Engagement reports have their own wrinkles. SheetXAI handles them in the same prompt.
When you need to pull titles alongside the metrics
The sheet only has page IDs. The Head of Content needs to see page names in the report, not just numbers.
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 to split the results into a separate ranked tab
The current sheet already has data you do not want to disturb. You want the results in a new tab.
For each page ID in column A, fetch the page title, like count, and last-modified date. Create a new sheet tab called "Engagement Ranking" and write the results there with headers. Sort by like count descending.
When you want to flag zero-like pages for archiving
Pages with no engagement are candidates for removal. You want them flagged before you share the report.
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 engagement data plus a summary and a Confluence page for the Head of Content
The Head of Content wants the data in a sheet and a summary page in Confluence she can share with her manager.
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 — [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 sheet 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 sheet of Confluence page IDs you want to analyze by engagement, 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 Google Sheets overview.