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

Zapier · Finance

How to Use EIA dataset filter codes in Zapier

Fetch the codes, names, and aliases available for a dataset filter, such as an electricity customer sector. Use it to select the right category before requesting observations.

Prompts to try with EIA dataset filter codes in Zapier

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

Each month, use EIA dataset filter codes to review the balancing authorities available in the hourly grid dataset. Report any added, removed, or renamed entries.

EIA dataset filter codesZapier
Try asking
  • Every Monday at 9am: use EIA dataset filter codes to look this up and give me the result as a table.

  • Pull the latest numbers from EIA dataset filter codes and tell me what changed since last week.

  • Check EIA dataset filter codes and summarize what you find in three bullet points.

  • Pull the newest data from EIA dataset filter codes and give me the result as a table.

How to set up EIA dataset filter 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 EIA dataset filter codes in a workflow step

    Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds EIA dataset filter 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 EIA dataset filter 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": "eia-gov/energy-data/facet_values",
        "input": {
          "route": "<route>",
          "facet_id": "<facet_id>"
        }
      }'

Then paste one of the prompts above: Zapier finds EIA dataset filter codes on Spiral, shows the price and runs it.

EIA dataset filter codes providers and prices

Spiral runs EIA dataset filter codes through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance

What can you do with EIA dataset filter codes in Zapier?

Maintain a recurring briefing on electricity use or natural gas storage with EIA data. The agent can check dataset coverage and category labels, then compare newly available observations with earlier periods.

Compare state electricity consumption

Find the retail sales dataset, resolve state and customer-sector codes, and compare monthly residential electricity sales in California, Texas, and Florida over the same period.

Compare commercial and industrial demand for electricity

Identify the retail sales measurements and sector labels, then compare commercial and industrial electricity sales in Ohio. Calculate each sector's year-over-year change.

Measure changes in a state's generation mix

Locate monthly generation by state and fuel, resolve the fuel categories, and calculate how Texas generation shares changed between 2023 and 2024.

Review power plant operating history

Find the plant generation dataset and the code for Palo Verde, then compare monthly generation across 2023 and 2024 to identify seasonal changes.

Check grid demand forecasts against reported demand

Locate hourly balancing-authority measurements and resolve PJM's reporting code. Compare reported demand with demand forecasts for a completed week and calculate the largest hourly differences.

Compare seasonal natural gas storage

Find weekly underground storage data and its regional categories, then compare working gas levels for the same weeks in successive years.

Questions about EIA dataset filter codes in Zapier

Can Zapier use EIA dataset filter codes?

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

How much does EIA dataset filter 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 EIA dataset filter codes in Zapier?

No. Spiral runs EIA dataset filter 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 EIA dataset filter 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 EIA dataset filter codes runs?

EIA dataset filter codes runs in the background. Zapier starts the run, checks on it and gives you the json when it's ready.

What detail does EIA provide for electricity customers?

EIA's retail sales dataset includes monthly customer counts, electricity sales, revenue, and average prices by state and customer sector.

Does EIA update every dataset on the same schedule?

No. EIA says its API accesses public-facing databases directly and updates constantly rather than at regular intervals.

Can one response contain every matching observation?

EIA caps observation responses at 5,000 rows. The total count can exceed the returned count, so larger requests need pagination or narrower filters.

How far back does the hourly grid API go?

EIA says historical EIA-930 submissions through the API begin January 1, 2019. This collection covers grid operations reported by balancing authorities in the Lower 48 states.

Does hourly generation include rooftop solar?

Hourly generation captures generators managed by, or visible to, balancing authorities. Those authorities typically do not meter distribution-system generators, so rooftop solar is often excluded.

Get started

Start using EIA dataset filter 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