The Scenario
Your product marketing manager pinged you on Monday with a simple ask: find out what the startup and entrepreneur communities on Reddit are talking about heading into your product launch. You have a list of 10 subreddits in column A. You need the top 25 posts from each — title, score, comment count, URL — in a clean sheet by end of day so she can scan for angle ideas before the brief goes to the agency tomorrow.
The bad version:
- Open each subreddit in a tab, set the filter to "Top / Past Week," scroll to post 25, start copying titles into column B one at a time
- Realize the scores you captured from r/entrepreneur are already stale because you left that tab open for 45 minutes while you worked through the others
- Manually deduplicate the three posts that appeared in two subreddits with different scores
You were supposed to spend this afternoon on the positioning doc. The data collection was supposed to be the easy part.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your data, understands the structure of your sheet, and through its built-in Reddit integration it can query multiple subreddits and write the results back — all from a single prompt in the sidebar.
Get the top 25 posts from each subreddit in column A for the past week and write subreddit name, post title, score, comment count, and URL into columns B through F — one row per post, starting at row 2
What You Get
- Columns B through F populated for each subreddit in column A — subreddit name, post title, current score, comment count, and permalink
- Posts ordered by score descending within each subreddit block
- Rows written contiguously so the output is ready to sort or filter without cleanup
What If the Data Is Not Quite Ready
The subreddit names in column A have inconsistent formatting
Some rows say r/entrepreneur, some say entrepreneur, some have a trailing space. SheetXAI normalizes them before querying.
The subreddit names in column A have mixed formats — some start with r/, some don't, some have spaces. Normalize them, then get the top 25 posts from each for the past week and write subreddit, title, score, comment count, and URL into columns B through F
You want fewer posts from low-traffic subreddits
Some subreddits in your list barely get 10 posts a week. You don't want empty rows stretching the sheet.
Get the top 25 posts from each subreddit in column A for the past week, but if a subreddit has fewer than 10 results write what's available — skip empty subreddits entirely and note "no results" in column B for those rows
You need to join the results against a keyword filter in a second tab
Your marketing manager only wants posts related to specific themes. The keywords live in a separate tab.
Get the top 25 posts from each subreddit in column A for the past week — then filter the results to only include posts whose titles contain any keyword from column A of the Keywords tab — write the filtered results with subreddit, title, score, comment count, and URL into columns B through F
You want the full enriched pull plus a summary row per subreddit
One prompt to get the raw data and a rollup row per community.
Get the top 25 posts from each subreddit in column A for the past week, write the individual post rows into columns B through F, then after each subreddit block add a summary row showing average score and total comment count for that subreddit
The pattern is to ask for the data fetch and the downstream analysis together — no intermediate step required.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a subreddit list in column A, then ask it to pull this week's top posts. Link to a sibling spoke: Search Reddit for Brand Mentions. Back to the overview: Reddit + Google Sheets.