The Scenario
You are a media planner building a Reddit Ads targeting plan for a B2B software client. Your brief specifies twenty topic keywords you want to map to subreddit targets. The keywords are in column A of a Google Sheet. You have until Wednesday noon to send the targeting plan to the client.
It is Tuesday morning.
The bad version:
- You open Reddit.com and search for each keyword manually
- For each keyword you browse the results and try to identify subreddits with enough subscriber count to be targetable
- You log into Reddit Ads Manager to verify whether each subreddit is actually available for targeting (not all public subreddits are)
- You copy and paste subreddit names and subscriber counts into the sheet by hand, twenty keywords × five subreddits each
- Two hours later you are on keyword eleven and you have misspelled two subreddit names.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the keyword column and queries the Reddit Ads community search API for each keyword in one pass, so you never manually browse Reddit to build a targeting list.
Open the SheetXAI sidebar and type:
For each keyword in column A, search Reddit Ads for targetable communities and write the top 5 matching subreddit names and subscriber counts into columns B and C. Use one block of rows per keyword, with the keyword label in the first row of each block.
SheetXAI calls the Reddit Ads community search API for each of the twenty keywords and writes the results into the sheet. Twenty keywords, up to 100 subreddit matches, all in the columns you specified.
What You Get
A structured targeting discovery table in the sheet:
- Keyword label row — the keyword from column A
- Up to 5 rows per keyword — subreddit name in column B, subscriber count in column C
- Repeated for all 20 keywords — one clean block per keyword
The subreddits are confirmed as targetable via the Reddit Ads API, not just public Reddit search results. You are not guessing whether a community is available.
Want a flat table instead of keyword blocks? Ask SheetXAI to write keyword name in column A, subreddit name in column B, and subscriber count in column C for every match, one row per subreddit. It adjusts.
What If the Data Is Not Quite Ready
Keyword lists from briefs are always imperfect. SheetXAI handles edge cases in the same prompt.
When some keywords return no targetable communities
Some niche topics have no matching communities in Reddit Ads. You want those flagged so the brief does not have a silent gap.
For each keyword in column A, search Reddit Ads for targetable communities. Write the top 5 results into columns B and C. If no communities are found for a keyword, write "NO RESULTS" into column B for that keyword's row.
When you need to filter by minimum subscriber count
Your media plan requires subreddits with at least 50,000 subscribers to ensure enough reach.
For each keyword in column A, search Reddit Ads for targetable communities. Write only communities with more than 50,000 subscribers into columns B and C. If fewer than 3 qualifying communities are found for a keyword, note "UNDER THRESHOLD" next to that keyword.
When the client wants the results in a flat table for sorting and filtering
Blocks per keyword are hard to sort. The client wants one row per subreddit match, with the keyword column attached, so they can pivot the data.
For each keyword in column A, search Reddit Ads for the top 5 targetable communities. Write the results flat: one row per subreddit, with keyword name in column A, subreddit name in column B, subscriber count in column C, and community ID in column D. Sort by subscriber count descending.
When you need to combine keyword discovery with community suggestions to maximize the targeting list
You want to find direct keyword matches AND use the top results per keyword to seed community suggestions, all in one pass.
For each keyword in column A, search Reddit Ads for the top 3 targetable communities and write them into columns B through D (subreddit name, subscriber count, community ID). Then for each of those communities, fetch the top 3 community suggestions from the Reddit Ads API and write them into columns E through G. Label column E "Suggested Subreddit," column F "Suggested Subscriber Count," column G "Suggested Community ID."
The pattern: the keywords are in the sheet. The community discovery is an API operation. SheetXAI does both without you opening Reddit or Ads Manager once.
Try It
Get the 7-day free trial of SheetXAI and open any keyword list sheet, then ask it to find targetable Reddit communities for each keyword. The Reddit Ads integration is included in every SheetXAI plan. See also how to expand a targeting list with community suggestions or the Reddit Ads in Google Sheets overview.