The Scenario
You run developer relations at an open source company. Three days ago someone posted a detailed "Show HN"-style thread about your project on Reddit and it blew up — 400 comments, lots of technical debate, some sharp criticism, and what looks like a handful of genuine power users who went deep. Your job is to figure out who the most engaged voices are so you can follow up, invite them to your Discord, and turn the hottest critics into contributors. You need every comment pulled into a sheet, sorted by score, so you can work down the list.
The bad version:
- Open the thread, sort by "Top," start copying commenter usernames and comment text into the sheet manually
- Discover that Reddit's "Top" sort flattens the nested replies so you're only seeing top-level comments and missing the deep technical exchanges that happened two or three levels down
- Copy 40 rows, realize you forgot to capture the score for the last 12, go back and try to match them up by username
This is the kind of engagement opportunity that only comes around a few times a year. Spending it on data entry is the wrong use of the next three hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the post URL from a cell and through its built-in Reddit integration it can fetch every comment, sort them by score, and write the results into a structured table.
Retrieve all comments from the Reddit post URL in cell A1, sort by score descending, and write author username, score, and comment text into columns A through C — skip deleted or removed comments
What You Get
- Column A: author username
- Column B: upvote score
- Column C: full comment body text
- Results sorted by score so the highest-signal contributors appear first
- Deleted and removed comments excluded from the output
What If the Data Is Not Quite Ready
You want to include reply depth so you can filter to top-level only
Some of your most useful contributors were responding to other comments, not posting top-level.
Retrieve all comments from the Reddit post URL in cell A1 — include top-level and nested replies — write author username, score, comment depth (0 for top-level, 1 for first-level reply), and comment text into columns A through D sorted by score descending
You only want comments above a minimum score threshold
You're only interested in comments that got meaningful upvotes — below 5 is noise.
Retrieve all comments from the Reddit post URL in cell A1 where score is at least 5 — write author, score, and comment text into columns A through C sorted by score descending — skip deleted comments
You want to capture the first 200 characters of each comment for a quick-scan view
Reading 400 full comments is too much. You want a preview column for scanning before diving deep.
Retrieve all comments from the Reddit post URL in cell A1, sort by score descending — write author, score, and the first 200 characters of the comment text into columns A through C — skip deleted comments — add the full comment text into column D for reference
Full outreach-ready table: comments pulled, scored, and tagged by engagement tier
Retrieve all comments from the Reddit post URL in cell A1, sort by score descending — write author username, score, comment text, and a tier label into columns A through D — label "High Value" for score above 50, "Mid" for 10-50, "Noise" for below 10 — skip deleted or removed comments
One prompt builds a prioritized outreach list sorted and labeled so you start the right conversations first.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a Reddit post URL in cell A1, then ask it to pull all comments sorted by score and label them by engagement tier. Related spoke: Extract All Comments From a Reddit Post. Back to the overview: Reddit + Google Sheets.