The Scenario
You are a growth strategist. Your team has spent a week building a Reddit targeting matrix. Twelve ad groups, each targeting a different cluster of subreddits, all planned to run under one awareness campaign. The matrix is in a Google Sheet. The campaign is live. The 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, and click "New Ad Group"
- You fill in ad group name, bid, and target subreddits for ad group one
- You repeat for ad group two, three, four
- By ad group five you realize you mis-typed the bid on ad group two and have to go back
- By ad group nine your wrist hurts
- You are still in Ads Manager at 6 PM and the team has stopped responding to Slack.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the targeting matrix and creates all twelve ad groups via the Reddit Ads API in one pass, so you never manually enter a subreddit cluster into the Ads Manager UI.
Open the SheetXAI sidebar and type:
For each row in my sheet, 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 via the Reddit Ads API, and writes each ad group ID back into column D. Twelve ad groups before 3 PM.
What You Get
Twelve live Reddit Ads ad groups, one per row, with IDs logged back to the sheet:
- Column A — ad group name (unchanged from matrix)
- Column B — bid (set as specified)
- Column C — target subreddits (applied to each ad group)
- Column D — ad group ID returned by the API
Column D is your launch record. If QA needs to verify the setups, you share the sheet. If a bid needs to be changed later, the ID is already there for a follow-up prompt.
What If the Data Is Not Quite Ready
Targeting matrices get messy when multiple people contribute to them. SheetXAI handles the cleanup and the creation in the same prompt.
When subreddit names in column C are formatted inconsistently
Some rows have "r/entrepreneur, r/smallbusiness" and some have "entrepreneur smallbusiness" without the r/ prefix or the comma. The API requires the proper subreddit format.
For each row in my sheet, normalize the subreddit names in column C so they all start with "r/" and are separated by commas. Then create a Reddit Ads ad group under campaign ID in cell A1 using the name from column A, bid from column B, and the normalized subreddits. Write the ad group ID into column D.
When some rows have blank bids
Half the rows have a bid, half are blank. You want the blank rows to use a default bid of $1.50 rather than skipping them.
For each row in my sheet, create a Reddit Ads ad group under campaign ID in cell A1. Use the ad group name from column A, and the bid from column B. If column B is blank, use a default bid of 1.50. Use the target subreddits from column C. Write the ad group ID into column D.
When some ad groups should start paused
Three of the twelve ad groups are "holdout" groups that should not serve until creative is approved. Column E has "PAUSED" in those rows.
For each row in my sheet, create a Reddit Ads ad group under campaign ID in cell A1. Use column A for name, column B for bid, and column C for subreddits. If column E says "PAUSED," create the ad group in paused status. Otherwise create it in active status. Write the ad group ID into column D and the status into column E, replacing the PAUSED label.
When you need to create ad groups AND immediately log their targeting details for QA
The QA team wants a full record of what was created and what subreddits were applied, not just the IDs.
For each row in my sheet, create a Reddit Ads ad group under campaign ID in cell A1 using name from column A, bid from column B, and subreddits from column C. Write the ad group ID into column D. Then fetch each newly created ad group's details from the API and write the confirmed subreddit list back into column E and the confirmed bid into column F, so the QA sheet is fully populated.
The pattern: build the targeting matrix in the sheet first. Then SheetXAI does the API work. The sheet is both the brief and the record.
Try It
Get the 7-day free trial of SheetXAI and open any targeting matrix sheet, 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 or the Reddit Ads in Google Sheets overview.