The Scenario
You are a growth strategist. Your team has built a Reddit targeting matrix in Excel. Twelve ad groups, each targeting a different subreddit cluster, all planned under one awareness campaign. The campaign is live. Launch brief says ad groups go live by end of day. It is 2 PM.
The bad version of this afternoon:
- You open Reddit Ads Manager, navigate to your campaign, click "New Ad Group"
- You fill in name, bid, and target subreddits for ad group one
- You repeat for ad groups two through twelve
- On ad group seven you mis-type the bid and have to go back
- It is 5:45 PM, ad group eleven is not created yet, and the team has moved on.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the targeting matrix in the workbook and creates all twelve ad groups via the Reddit Ads API in one pass.
Open the SheetXAI sidebar and type:
For each row in the AdGroups tab of this workbook, create a Reddit Ads ad group under the campaign ID in cell A1. Use the ad group name from column A, the bid from column B, and the target subreddits from column C. Write the ad group ID into column D for each row.
SheetXAI reads the campaign ID from A1, iterates through the twelve rows, creates each ad group, and writes each ID back into column D. Twelve ad groups before 3 PM.
What You Get
Twelve live Reddit Ads ad groups with IDs logged in the AdGroups tab:
- Column A — ad group name (unchanged from matrix)
- Column B — bid as specified
- Column C — target subreddits as specified
- Column D — ad group ID from the API
Column D is your launch record. Share the workbook with QA. Use the IDs for follow-up bid adjustments. Nothing was typed into Ads Manager by hand.
What If the Data Is Not Quite Ready
Targeting matrices built collaboratively are rarely consistent. SheetXAI handles the cleanup and creation together.
When subreddit names in column C are formatted inconsistently
Some rows have "r/entrepreneur, r/smallbusiness" and some have "entrepreneur smallbusiness" without the prefix or comma separator.
For each row in the AdGroups tab, normalize the subreddit names in column C so they all start with "r/" and are comma-separated. Then create a Reddit Ads ad group under campaign ID in cell A1 using column A for name, column B for bid, and the normalized subreddits. Write the ad group ID into column D.
When some rows have blank bid values
Half the rows have a bid, half are blank. You want blank rows to use a default bid of $1.50.
For each row in the AdGroups tab, create a Reddit Ads ad group under campaign ID in cell A1. Use column A for name. If column B is blank, use a bid of 1.50; otherwise use column B. Use column C for target subreddits. Write the ad group ID into column D.
When some ad groups should start paused
Three of the twelve are holdout groups. Column E has "PAUSED" in those rows.
For each row in the AdGroups tab, create a Reddit Ads ad group under campaign ID in cell A1. Use column A for name, column B for bid, column C for subreddits. If column E says "PAUSED," create the ad group in paused status; otherwise create it active. Write the ad group ID into column D.
When you need creation plus confirmed targeting details for QA
The QA team wants a full record: what subreddits were actually applied, not just what you intended.
For each row in the AdGroups tab, create a Reddit Ads ad group under campaign ID in cell A1 using column A for name, column B for bid, and column C for subreddits. Write the ad group ID into column D. Then fetch each newly created ad group's confirmed details from the API and write the confirmed subreddit list into column E and the confirmed bid into column F.
The pattern: build the matrix in the workbook. SheetXAI does the API work. The workbook is both the brief and the QA record.
Try It
Get the 7-day free trial of SheetXAI and open any targeting matrix workbook, then ask it to create your Reddit Ads ad groups. The Reddit Ads integration is included in every SheetXAI plan. See also how to bulk-create campaigns in Excel or the Reddit Ads in Excel overview.