Spiral gives your agent every tool with one account. Browse the tools →

Notion · Public Records

How to Use IEA country codes in Notion

Returns country names and code mappings used by IEA energy datasets, with regional aggregates identified. Use it to match countries across datasets and check coverage before comparing energy figures.

Prompts to try with IEA country codes in Notion

Copy an example into Notion, or ask in your own words.

Each month, use IEA country codes to check whether France, Germany, Norway, and Japan appear in Monthly Electricity Statistics coverage and report changes from the previous check.

IEA country codesNotion
Try asking
  • Every Monday at 9am: use IEA country codes to look this up and give me the result as a table.

  • Pull the latest numbers from IEA country codes and tell me what changed since last week.

  • Check IEA country codes and summarize what you find in three bullet points.

  • Pull the newest data from IEA country codes and give me the result as a table.

How to set up IEA country codes in Notion

Pick the way that suits you. Each takes about two minutes.

Use the Spiral skill

  1. Send Notion this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use Spiral's MCP server

  1. Allow custom MCP servers

    A workspace owner opens Settings › Connections, then the Manage tab, and turns on Enable custom MCP servers. Where members may install only approved connections, also add Spiral under Approved connections › Add approved connection › Custom MCP server with the URL below.

  2. Add Spiral to a custom agent

    Open the custom agent (or create one), then Settings › Tools & Access › Add connection › Custom MCP server. Paste this URL, name it Spiral, keep OAuth and click Connect.

    https://api.spiral.ai/mcp
  3. Sign in to Spiral and approve

    Spiral opens: sign in, pick the organization and click Authorize. No API key. Spiral gives the connection its own key; Notion never sees it, and you can remove it under Settings › Connected apps in the console.

  4. Run IEA country codes in a workflow step

    Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds IEA country codes, prices it and runs it each time the step fires.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run IEA country codes

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "iea-org/energy/countries",
        "input": {
          "query": "<query>"
        }
      }'

Then paste one of the prompts above: Notion finds IEA country codes on Spiral, shows the price and runs it.

IEA country codes providers and prices

Spiral runs IEA country codes through Alexandria. Open a card for today's price, with every fee included.

AlexandriaPublic Records
IEA · Countries
iea-org/energy/countries

Settings you can ask for

Ask Notion for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Page size1 to 100020

page_size

Include aggregateson or off

include_aggregates

Every API field of IEA · Countries is on its tool page: open its card above.

What can you do with IEA country codes in Notion?

Maintain a recurring electricity briefing for a country watchlist using IEA's monthly series. Check available reporting periods before refreshing the comparison and summarize newly available observations.

Compare national electricity mixes

Find an electricity dataset, check its available years, resolve France and Germany, and compare generation by source over a shared reporting window.

Build an energy consumption benchmark

Identify the relevant energy balance series, verify country coverage and history, and compare total final consumption for Japan, Germany, and France using the returned units.

Prepare a monthly electricity briefing

Resolve the countries in a European market watchlist, confirm the latest available period, and summarize changes in wind, solar, hydro, and nuclear generation.

Compare fuel combustion emissions

Find the emissions dataset and its reporting window, match France and Germany to IEA country codes, and compare reported emissions by sector.

Check a hydro generation shortfall

Check Norway's monthly electricity coverage, retrieve hydro generation for matching months across two years, and calculate the change in reported output.

Scope an energy research project

Find datasets relevant to electricity and consumption, then compare their frequencies, available years, units, and country coverage before choosing the analysis period.

Questions about IEA country codes in Notion

Can Notion use IEA country codes?

Yes. Add Spiral to Notion as an MCP server, and Notion can find and run IEA country codes like any built-in tool.

How much does IEA country codes cost in Notion?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Notion plan is separate.

Do I need an Alexandria account to use IEA country codes in Notion?

No. Spiral runs IEA country codes on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up IEA country codes in Notion?

About two minutes: allow custom MCP servers, then add Spiral to a custom agent, then sign in to Spiral and approve.

Does Notion wait while IEA country codes runs?

IEA country codes runs in the background. Notion starts the run, checks on it and gives you the json when it's ready.

Does every IEA dataset cover the same countries?

No. The Energy Statistics Data Browser covers over 170 countries and regions, while Monthly Electricity Statistics advertises 47 countries. Check coverage for the dataset you intend to use.

How often does IEA monthly electricity data change?

Monthly Electricity Statistics is updated monthly. Use the dataset details lookup to check current availability, since the catalog's update date is not populated.

How far back does monthly electricity history go?

Coverage generally starts in January 2010 for OECD countries and January 2015 for non-OECD countries. Confirm the available years for the specific dataset before choosing a comparison period.

Can I retrieve a large historical table in one extraction?

Observation pagination stops at an offset of 200,000. Divide broad requests into smaller country or year ranges before reaching that boundary.

Get started

Start using IEA country codes in Notion

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Notion:

Set up Notion

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options