The Scenario
You are a media buyer managing a Reddit Ads account for an outdoor gear brand. You have ten seed subreddits in column A of an Excel workbook: communities you already know perform well. Leadership wants to expand reach with similar communities, and they want fifty candidates by Thursday.
Manual research will take most of the day.
The bad version:
- You open Reddit.com and browse each seed subreddit for similar community suggestions
- You check whether each suggestion is targetable in Reddit Ads
- You copy names and subscriber counts into the workbook by hand
- After four seeds you have lost track of which suggestions came from which seed
- You have thirty-one communities in the workbook and no record of which are original seeds versus expansions.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the seed subreddit column and calls the Reddit Ads community suggestions API for each seed in one pass.
Open the SheetXAI sidebar and type:
For the subreddit names in column A of the Seeds tab, fetch community suggestions from the Reddit Ads API and write suggested subreddit name, subscriber count, and relevance into columns B, C, and D. Use one block of rows per seed subreddit, labeled with the seed name.
SheetXAI calls the community suggestions endpoint for all ten seeds and writes the results into the workbook. Ten seeds, up to fifty suggested communities, labeled by seed.
What You Get
A structured expansion table in the Seeds tab:
- Seed label row — the original subreddit from column A
- Up to 5 suggestion rows per seed — name in column B, subscriber count in column C, relevance in column D
- Repeated for all 10 seeds — one labeled block per seed
The source of each suggestion is traceable. You know where each community came from when you present the targeting rationale.
What If the Data Is Not Quite Ready
Targeting expansion scenarios always have edge cases. SheetXAI handles them inline.
When you need to deduplicate suggestions across seeds
A community like r/hiking might appear as a suggestion for multiple seeds. You want each subreddit in the final list once.
For each subreddit in column A of the Seeds tab, fetch the top 5 community suggestions. Write results into a flat table in the Flat tab: seed subreddit in column A, suggested subreddit in column B, subscriber count in column C. Remove duplicate suggested subreddits across all seeds. Write the final unique count into cell E1.
When you only want suggestions above a minimum subscriber count
You need communities with at least 25,000 subscribers for scale.
For each seed subreddit in column A of the Seeds tab, fetch community suggestions from the Reddit Ads API. Write only suggestions with more than 25,000 subscribers into columns B, C, and D. Label each block with the seed name. Note suggestions that fell below the threshold in column E.
When some seeds return very few suggestions
Niche subreddits sometimes have few community suggestion results. You want those flagged.
For each seed subreddit in column A of the Seeds tab, fetch community suggestions from the Reddit Ads API and write results into columns B through D. If fewer than 3 suggestions are returned for a seed, write "FEW SUGGESTIONS" into column B for that seed's row after the last result.
When you need the expanded list combined with historical performance data to prioritize
You want to know which suggested communities have the best CPC history in the account.
For each seed subreddit in column A of the Seeds tab, fetch the top 5 Reddit Ads community suggestions and write suggested subreddit name into column B and subscriber count into column C. Then fetch the last 30 days of ad group performance from my Reddit Ads account. For any suggested subreddit that appears in my existing ad group targeting, write the historical CPC into column D. Leave column D blank for suggestions with no history.
The pattern: the seeds are in the workbook. SheetXAI does all ten API calls and returns a structured, labeled expansion list you can use immediately.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with seed subreddits, then ask it to expand your targeting list. The Reddit Ads integration is included in every SheetXAI plan. See also how to discover communities from keywords in Excel or the Reddit Ads in Excel overview.