The Scenario
You're a newsletter operator. You have 3,000 subscribers in a Google Sheet — two columns: email address in column B, username in column C. Your campaign agency just told you they need the list split by gender before they can write the variants. The send date is Thursday.
You've never needed a gender column before. Nobody thought to collect it during signup. So now you're staring at 3,000 rows with no obvious path forward.
The bad version:
- Open GenderAPI.io, paste one email address at a time, read the result, tab back to the sheet, find the row, type "male" or "female" and the confidence score into columns D and E
- Move to row 2. Repeat. Realize at row 11 that you typed the confidence score in the gender column and the gender in the confidence column and have to go back
- Get through 40 rows, decide to take a break, and calculate that at this pace you'll finish sometime next week — three days after the campaign sends
Your agency doesn't care how you produce the gender column. They just need it. And you have a lot of other things on your plate that are not data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data you're looking at and, through its built-in GenderAPI.io integration, calls the API across every row and writes the results back without you touching a single cell.
Here's the prompt for this task:
For each row in this sheet, use GenderAPI.io to determine gender from the email address in column B and write the gender and confidence score into columns D and E
SheetXAI works through all 3,000 rows, queries GenderAPI.io for each email address, and populates columns D and E. Rows where the API returns a low-confidence result get a flag rather than a silent fill — so you know which records need review before the list goes to your agency.
What You Get
- Column D: inferred gender ("male", "female", or "unknown") for every row
- Column E: the confidence score returned by GenderAPI.io, formatted as a decimal
- Rows with API errors or null responses flagged in a separate note rather than left blank
- The full 3,000-row sheet ready to filter and split into campaign variants
What If the Data Is Not Quite Ready
The username column is more reliable than the email addresses
Some subscribers signed up with generic email addresses that give the API nothing to work with. You want to fall back to the username in column C when the email lookup returns low confidence.
For each row in this sheet, query GenderAPI.io using the email in column B first; if the confidence score is below 0.7, re-query using the username in column C instead, and write the final gender and confidence into columns D and E with a note in column F indicating which input was used
Half the rows already have a gender filled in from a previous partial run
Someone started filling in the gender column manually before giving up. You don't want to overwrite correct values — you only want to fill the blanks.
For rows in this sheet where column D is empty, use GenderAPI.io to determine gender from the email in column B and fill in columns D and E — leave rows that already have a value in column D unchanged
The subscriber list spans two tabs and needs to be enriched consistently
New subscribers land in a "New Signups" tab before being reconciled with the main "Subscribers" tab. You need both enriched the same way.
Enrich the 'Subscribers' tab and the 'New Signups' tab by calling GenderAPI.io for each email in column B, writing gender into column D and confidence score into column E on each tab
The list needs cleanup, enrichment, and a deliverable summary — all at once
Before handing the list to your agency, you also need duplicate emails removed and a count of how many records landed in each gender category.
Deduplicate the email addresses in column B, use GenderAPI.io to fill in gender and confidence for any rows that don't have a value in column D, then add a summary at the top of the sheet showing the count of male, female, and unknown records
One prompt covers the dedup, the enrichment, and the summary your agency needs to understand the split before they start writing copy.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your subscriber list, then ask it to run a GenderAPI.io enrichment on your email or username column. See also: localized gender lookup by name and country and the GenderAPI.io integration overview.