Nationalize in Apipheny

Apipheny is a Google Sheets add-on that calls REST APIs and writes the response into a sheet. Use it to enrich a column of names with nationality predictions, then summarise the result alongside the rest of your sheet.

Add-on: apipheny.io
Apipheny docs: apipheny.io/api-connector-docs
Method: GET against the Nationalize API endpoint, with the name passed as a query parameter.

Request URL

In Apipheny, set the API URL Path to:

https://api.nationalize.io/?name=NAME&apikey=YOUR_API_KEY

To enrich a column rather than a single cell, use Apipheny's multiple query in one request mode and substitute the cell range for NAME. Apipheny iterates the column and writes one response per row.

Response

The endpoint returns JSON. Apipheny flattens the top-level fields into sheet columns. The country array nests one row per candidate; Apipheny expands it into multiple rows per name.

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

When to use the Spreadsheet tool instead

Apipheny works well for live, in-sheet enrichment up to a few hundred rows. For larger files, use the Spreadsheet tool — it processes a CSV in batched API calls and counts the work against your monthly quota in one round.