The Scenario
The VP of Marketing at a media company is putting together the annual content report for the board. The company publishes under a DEV Community organization account. Sixty articles over the past year. She's been handed a template — an Excel workbook with five columns waiting to be filled: title, published date, reactions, comments, URL. She needs everything in it before Thursday.
She logs into DEV Community and navigates to the organization's article listing. The interface shows twelve articles per page. There are five pages.
The bad version:
- Click into article one. Note the title, published date, and URL. Navigate to the article stats to get reaction count. Write them into the workbook. Go back. Find your place in the listing.
- Repeat fifty-nine times over the next two hours, realizing midway that the listing doesn't sort by date and you have no idea if you've missed any articles from the early months.
- Finish and then discover the template also wants reading time, which you didn't record and now have to go back through.
The board report is not going to write itself. The two hours it took to fill the workbook are two hours that aren't going to analysis, narrative, or the actual slides.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to the Dev.to API and pulls the complete article list for any DEV organization account — with engagement data per post — into your workbook in one pass.
Open the SheetXAI sidebar and paste:
List all articles published by DEV organization 'mycompany' and write them to the ContentPerformance worksheet — title in column A, published_at in column B, reactions_count in column C, comments_count in column D, reading_time_minutes in column E, article URL in column F. Sort by published_at descending.
What You Get
- One row per article published under the DEV organization account.
- Columns A–F populated with title, published date, reactions, comments, reading time, and URL.
- Sorted newest-first so the current year's content sits at the top of the workbook.
- All articles captured — the API pages through the full listing regardless of how many there are.
What If the Data Is Not Quite Ready
You only want articles from the current calendar year
The organization has three years of posts. The board report covers 2025 only.
List all articles published by DEV organization 'mycompany' from January 1, 2025 through December 31, 2025. Write them to ContentPerformance — title in A, published_at in B, reactions_count in C, comments_count in D, reading_time_minutes in E, URL in F.
You want a summary row at the bottom with totals
The template needs totals — total reactions, total comments, average reading time.
List all articles from DEV organization 'mycompany' into ContentPerformance — title in A, published date in B, reactions in C, comments in D, reading time in E, URL in F. After the last article row, add a totals row: "TOTAL" in column A, sum of reactions in C, sum of comments in D, average reading time in E.
You want to identify top-performing articles by a combined engagement score
The board wants to know which articles performed best, defined as reactions plus (comments × 2).
List all articles from DEV organization 'mycompany' into ContentPerformance — title in A, reactions in B, comments in C, URL in D. In column E, compute an engagement score as reactions + (comments × 2). Sort by column E descending so the top performers are at the top.
Pull full org history, score engagement, tag by topic cluster, and build a pivot summary
The board presentation needs: all articles scored, each one tagged to a topic cluster based on tags, and a separate summary table showing average engagement score per cluster.
List all articles from DEV organization 'mycompany' into ContentPerformance — title in A, tags in B, reactions in C, comments in D, reading time in E, URL in F. In column G, compute engagement score as C + (D × 2). In column H, classify each article as "product" if tags include "product" or "release", "engineering" if tags include "backend", "frontend", or "devops", or "community" otherwise. In a second worksheet ClusterSummary, show each cluster name with article count, average engagement score, and average reading time.
That one prompt fills the board template, scores every article, categorizes them, and builds the summary — without a single manual lookup.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you're using for your annual content report — then ask SheetXAI to pull your full DEV org article history with engagement scores and topic classifications already applied. The Dev.to integration is included in every SheetXAI plan.
See also: Pull your own DEV article engagement metrics into an Excel workbook and the Dev.to integration hub.