The Scenario
You run growth at a DTC brand and your team has been posting on Reddit for three months. You've also been watching competitor threads. You have 20 post URLs in column A — a mix of your own posts and competitor posts — and you need to benchmark them: current score, upvote ratio, comment count, award count. The goal is to figure out what formats and topics generate the most engagement in your communities before your Q3 content planning meeting next week.
The bad version:
- Open each URL, note the score and comment count, go back to the sheet, paste them in
- Realize the score on post number 3 has changed by the time you finish entering post number 7 — all your data was captured at different moments
- Go back to recheck five posts, find that post 12 has been removed and returns an error — leave that row blank and hope nobody notices
Twenty posts shouldn't require an hour of browser work. The analysis should take longer than the data collection.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the URLs in column A and through its built-in Reddit integration it can fetch the engagement data for each post and write it back into adjacent columns in a single pass.
For each Reddit post URL in column A, retrieve the post data and write title, current score, upvote ratio, comment count, and award count into columns B through F
What You Get
- Columns B through F: post title, current score, upvote ratio (0 to 1), comment count, award count
- All posts fetched in a single pass for consistent data capture time
- Removed or deleted posts flagged in column B rather than left blank
What If the Data Is Not Quite Ready
Some URLs in column A are not Reddit posts
Your list has a mix of Reddit URLs and non-Reddit URLs that crept in from copy-paste.
For each URL in column A, check if it is a Reddit post URL — skip non-Reddit URLs and write "Not Reddit" in column B — for valid Reddit URLs fetch post title, score, upvote ratio, and comment count into columns B through E
You want to add a performance label based on score thresholds
Your team categorizes posts as "high," "mid," or "low" performers based on score cutoffs you've defined.
For each Reddit post URL in column A, fetch the post title, score, upvote ratio, and comment count and write them into columns B through E — in column F label the post "High" if score is above 500, "Mid" if between 100 and 500, and "Low" if below 100
The posts span multiple subreddits and you want subreddit captured too
Your benchmark table needs to be filterable by community.
For each Reddit post URL in column A, fetch post title, subreddit, current score, upvote ratio, comment count, and award count and write them into columns B through G
Full competitive benchmark: fetch, label, and rank all posts in one shot
For each Reddit post URL in column A, fetch post title, subreddit, current score, upvote ratio, comment count, and award count — write them into columns B through G — label each post in column H as "High" (score above 500), "Mid" (100-500), or "Low" (below 100) — sort the output rows by score descending
One prompt builds the benchmark table, applies the performance labels, and sorts the output — nothing to do afterward except read it.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with Reddit post URLs in column A, then ask it to pull the engagement metrics and label each post by performance tier. Related spoke: Pull Top Posts From a List of Subreddits. Back to the overview: Reddit + Google Sheets.