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

Zapier · Public Records

How to Use IEA country codes in Zapier

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 Zapier

Copy an example into Zapier, 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 codesZapier
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 Zapier

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

Use the Spiral skill

  1. Send Zapier 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. Add an MCP Client connection

    In Zapier open Apps, click Add connection and search for MCP Client. Fill in the form:

    https://api.spiral.ai/mcp
  2. 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; Zapier never sees it, and you can remove it under Settings › Connected apps in the console.

  3. Run a Spiral tool in a Zap

    Add an MCP Client step to a Zap and choose the Run Tool action with your Spiral connection. Pick a tool: discover finds the right model for a task, estimate_cost prices it and run runs it. For example, run with:

    {
      "provider": "fal",
      "model": "fal-ai/flux/schnell",
      "input": { "prompt": "a lighthouse at dawn" },
      "wait": true
    }
  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: Zapier 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 Zapier 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 Zapier?

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 Zapier

Can Zapier use IEA country codes?

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

How much does IEA country codes cost in Zapier?

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

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

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 Zapier?

About two minutes: add an MCP Client connection, then sign in to Spiral and approve, then run a Spiral tool in a Zap.

Does Zapier wait while IEA country codes runs?

IEA country codes runs in the background. Zapier 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 Zapier

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

Paste this into Zapier:

Set up Zapier

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