Required extension
Install the GenderAPI Google Sheets Add-On
The custom formula depends on the Add-On. Install it from Google Workspace Marketplace, authorize it in your spreadsheet and save your GenderAPI key in the formula settings.
Install from Google MarketplaceSetup
Activate the formula in four steps
- 01
Open the GenderAPI sidebar
In Google Sheets, open Extensions, select GenderAPI and choose Determine Gender.
- 02
Open the formula page
Use the sidebar menu to open the GENDER formula guide and API-key settings.
- 03
Save your API key
Select or paste your GenderAPI key and save it for the spreadsheet workflow.
- 04
Enter the formula
Use =GENDER(A2) for a name, or add parameters for email, username, country context and additional fields.
Formula reference
Choose the input method and output detail
=GENDER(A2)Analyze the name in cell A2 with default settings.
=GENDER(A5, "email", "", true)Analyze an email address and return gender plus probability, country and normalized name.
| Parameter | Purpose |
|---|---|
input | A name, email address or username |
method | name (default), email or username |
country_filter | Optional two-letter code such as US, DE or TR |
additional_info | When true, also returns probability, country and normalized name |
Example output
Fill additional result columns automatically
When additional information is enabled, the formula fills adjacent columns with the expanded result fields.
Choose with context
Use formulas for flexible, lightweight analysis
Frequently asked questions
Google Sheets GENDER formula FAQ
Why do result cells contain a JSON note?
The note caches the formula and result so Google Sheets can reuse the value instead of spending another API credit during an automatic recalculation.
Do I need the GenderAPI Add-On?
Yes. The custom GENDER formula requires the GenderAPI Google Sheets Add-On to be installed and authorized.
Can I use email addresses or usernames?
Yes. Set the method parameter to email or username for those input types.
What happens if I uninstall the Add-On?
Formula-generated values are dynamic and may no longer appear when the Add-On is removed. Copy values when you need a static result.
What limits apply to the formula?
GenderAPI plan limits and Google Apps Script quotas both apply. Google's published URL Fetch quota is currently 20,000 daily calls for consumer accounts and 100,000 for Google Workspace accounts, and Google notes that quotas can change.
Are formula results stored permanently?
No. Formula output is dynamic. Copy and paste the results as values, or use the bulk Add-On workflow when persistent output is required.
Where can I get an API key?
Create or sign in to a GenderAPI account and copy an API key from the dashboard.