How to Determine Gender in Google Sheets? Using the Gender API Add-On

Step-by-Step Guide to Using the Gender API Add-On in Google Sheets

The Gender API Google Sheets Add-On determines gender based on both names and emails. The column you want to analyze for gender can contain a mix of names and emails, and Gender API automatically detects whether the data is a name or an email.

• In Google Sheets, click on the Extensions menu at the top. From the dropdown, select GenderAPI.io Genderize Names Emails, and then click on Determine Gender to begin the gender identification process.

Once the side menu opens, you’ll see the GenderAPI.io Determine Gender interface. Here are the fields to fill out:

• Select Credits Key: Choose the API key associated with your credits.
• Select Source Field (Name or E-Mail): Select the column from your spreadsheet that contains names or emails for gender identification.
• Select a Gender Field to Write: Choose the column where you want the gender result to be displayed.
• (Optional) Select a Country Field to Write: If you want to write the country information, select the appropriate column.
• (Optional) Select a Probability Field to Write: Choose a column to display the probability of the gender determination.
• (Optional) Country Filter: Select a country if you want to apply a specific country filter.
• (Optional) Skip if gender field has value: Tick this option if you want to skip rows where the gender is already filled in.

---

How to Use Video for Gender API Google Sheets Add-On

Watch this video to learn how to use the Gender API Add-On in Google Sheets. We'll guide you through how to automatically determine gender from names and emails directly in your spreadsheet, helping you enhance your data insights and personalize customer interactions efficiently.