The Scenario
A developer advocate's quarterly content review is coming up and her manager wants to know which topics are actually moving the needle on DEV Community. She's published forty-three articles across the past year. The DEV dashboard shows you one article at a time. There's no built-in export, no CSV download, no sortable table of everything she's written with reaction counts side by side.
She starts clicking through articles manually.
The bad version:
- Open the DEV Community dashboard. Navigate to article one. Note the title, published date, and reaction count somewhere. Switch tabs to the workbook. Type them in.
- Repeat for forty-two more articles, losing track of which ones you've already done somewhere around article twenty.
- Realize the reaction counts changed between when you started and when you finished, because DEV updates them in real time. Your data is already stale.
Her manager needs this before Friday's leadership sync. There is no version of this that she has time to do correctly by hand.
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 through its built-in integration and pulls your published article data — all of it, in one pass — directly into your workbook without you navigating the dashboard at all.
Open the SheetXAI sidebar and paste:
Pull all my published DEV Community articles into the ContentMetrics worksheet — include title in column A, article URL in column B, published date in column C, reaction count in column D, comment count in column E, and reading time in column F. One row per article, sorted by reaction count descending.
What You Get
- One row per published article in the ContentMetrics worksheet.
- Columns A–F populated with title, URL, published date, reactions, comments, and reading time.
- Sorted by reaction count so the highest-performing articles are at the top without any manual reordering.
- No articles missed — the API page-fetches until all results are returned.
What If the Data Is Not Quite Ready
You also want page view estimates
DEV Community's API returns a positive_reactions_count and a page_views_count field. You want both, plus the ratio between them.
Pull all my published DEV Community articles into ContentMetrics — title in A, URL in B, published date in C, positive_reactions_count in D, comments_count in E, page_views_count in F. Then add a formula in column G that computes reactions divided by page views as a percentage, formatted to two decimal places.
You want articles filtered to a specific year
The full history goes back four years. Your manager only wants 2025 data.
Fetch all my published DEV Community articles published between January 1, 2025 and December 31, 2025, and write them to the ContentMetrics worksheet — title, URL, published date, reaction count, and comment count. Skip anything outside that date range.
You want to compare performance across tags
You publish across three topic areas — Python, DevOps, and career. You want a separate summary row at the bottom for each.
Pull all my published DEV Community articles into ContentMetrics — title in A, URL in B, tags in C, reactions in D, comments in E. After the last article row, add three summary rows: one for articles whose tags include "python", one for "devops", one for "career" — showing average reactions and average comments for each group.
Pull the data, compute percentile ranks, and flag low performers
You want to know which articles are in the bottom 20% by reactions so you can decide whether to update or archive them.
Fetch all my published DEV Community articles into ContentMetrics — title in A, reactions in B, comments in C, published date in D, URL in E. In column F, compute the percentile rank for each article based on reactions. In column G, flag any article in the bottom 20th percentile with "review" and leave others blank.
One prompt does the pull, the math, and the categorization — so Friday's review starts from an already-analyzed workbook, not a raw export.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook where you want your DEV Community engagement history to land — then ask SheetXAI to pull everything with reaction counts, sort it, and add whatever summary logic your report needs. The Dev.to integration is included in every SheetXAI plan.
See also: Bulk publish drafts to DEV Community from an Excel workbook and the Dev.to integration hub.