The Scenario
You are a marketing ops manager at a DTC brand. You have a Excel workbook with 5,000 customer emails in column A of the Emails tab. These are existing buyers you want to retarget on Reddit with a win-back campaign.
The campaign needs the custom audience live before Monday's paid review. It is Thursday afternoon.
The bad version:
- You discover the Reddit Ads custom audience UI requires a hashed email CSV in a specific format
- You write a script to hash 5,000 emails, export the CSV, and upload it
- The upload fails because the encoding is wrong
- You fix the encoding, re-upload, and wait for the audience to process
- The audience shows "Estimating size" for two hours and you cannot tell if it worked.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the email column from the workbook and creates the Reddit Ads custom audience directly, so you never write a hashing script or format a CSV upload.
Open the SheetXAI sidebar and type:
Create a Reddit Ads custom audience named 'Customer Retargeting — Win-Back' and add all email addresses from column A of the Emails tab to it. Write the audience ID into cell B1 and the estimated audience size into cell B2 once processing completes.
SheetXAI hashes the emails, creates the audience via the Reddit Ads API, and writes the audience ID and estimated size back into the workbook. The paid team has what they need before end of day.
What You Get
One live Reddit Ads custom audience built from the email column:
- Cell B1 — audience ID for use in campaign targeting
- Cell B2 — estimated audience size returned by the API
The ID in B1 is your reference. Pass it to the campaign manager. You do not navigate the Ads Manager UI at all.
What If the Data Is Not Quite Ready
Email lists from CRM exports are rarely clean. SheetXAI handles the cleanup and the upload together.
When the email column has duplicates
Your CRM export had duplicate rows. Loading duplicates wastes audience size.
Deduplicate the email addresses in column A of the Emails tab. Then create a Reddit Ads custom audience named 'Customer Retargeting — Win-Back' from the deduplicated list. Write the audience ID into cell B1 and the final email count into cell B2.
When you only want to target a specific customer segment
Column B has customer tier (Bronze, Silver, Gold) and you only want to target Gold-tier customers.
Filter column A of the Emails tab to rows where column B equals "Gold." Create a Reddit Ads custom audience named 'Gold Customer Retargeting' from the filtered list. Write the audience ID into cell C1 and the email count into cell C2.
When you need multiple audiences from different segments in one pass
You want a separate retargeting audience per customer tier.
For each unique tier value in column B of the Emails tab (Bronze, Silver, Gold), filter column A to that tier's emails and create a separate Reddit Ads custom audience named 'Retargeting — [Tier].' Write the audience ID and email count for each tier into a summary table starting at cell E1, with columns for tier name, audience ID, and email count.
When you need the audience created AND attached to a campaign ad group immediately
The campaign is live and you want the retargeting audience applied without a separate step.
Create a Reddit Ads custom audience named 'Customer Retargeting — Win-Back' from the emails in column A of the Emails tab. Write the audience ID into cell B1. Then update the ad group whose ID is in cell C1 to include this custom audience as a targeting layer.
The pattern: the email list is in the workbook. The audience creation and targeting update are API calls. You describe both in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a customer email list, then ask it to create a Reddit Ads custom audience. The Reddit Ads integration is included in every SheetXAI plan. See also how to discover targetable communities from keywords in Excel or the Reddit Ads in Excel overview.