Nationalize in Mixed Analytics

Mixed Analytics provides API Connector for Google Sheets and an IMPORTAPI custom function. Both let you pull nationality predictions from the Nationalize API into a sheet for column-level enrichment and downstream aggregation.

Add-on: mixedanalytics.com
IMPORTAPI documentation: mixedanalytics.com/knowledge-base/importapi-custom-sheets-function
Method: GET against the Nationalize API endpoint with the name as a query parameter.

Sheets formula

With IMPORTAPI, reference the cell holding the name and concatenate it into the URL:

=IMPORTAPI("https://api.nationalize.io/?name="&A2&"&apikey=YOUR_API_KEY")

Drag the formula down a column to enrich a list. The function returns the JSON response; combine with QUERY or INDEX to extract specific fields.

API Connector add-on

The full add-on supports scheduled refreshes, multi-row imports, and OAuth — useful when the sheet is part of a recurring report rather than a one-off enrichment. Configure a request with:

Method: GET
URL: https://api.nationalize.io/?name=NAME&apikey=YOUR_API_KEY
Headers: none required (the API key travels in the query string)

For the full parameter set, response shape, and error codes, see the API reference.

When to use the Spreadsheet tool instead

Sheets formulas re-run on every recalculation, which can multiply your API usage unintentionally. For one-shot enrichment of a file, use the Spreadsheet tool — upload a CSV, pick the columns, download the enriched file in one pass.