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

n8n · Finance

How to Use BEA county economic data tables in n8n

Returns BEA county statistics across a state and selected years, including income, population, earnings, and GDP measures. Use it for county rankings and historical comparisons; pagination keeps the collection tied to one publication.

Prompts to try with BEA county economic data tables in n8n

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

Every quarter, use BEA county economic data tables to refresh Delaware counties' personal income per person for the latest available year and report changes from the previous collection.

BEA county economic data tablesn8n
Try asking
  • Every quarter, use BEA county economic data tables to refresh real GDP comparisons across Texas counties for the latest available year.

  • Every Monday at 9am: use BEA county economic data tables to look this up and give me the result as a table.

  • Pull the latest numbers from BEA county economic data tables and tell me what changed since last week.

  • Check BEA county economic data tables and summarize what you find in three bullet points.

How to set up BEA county economic data tables in n8n

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

Use the Spiral skill

  1. Send n8n 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. Create a key

    Create a key under API keys in the console.

  2. Add an MCP Client node

    In a workflow, add an MCP Client node (or, under an AI Agent node, an MCP Client Tool) and set:

    https://api.spiral.ai/mcp
  3. Pick a tool

    The node lists Spiral's tools. In an MCP Client node pick one, such as run, and give it its arguments:

    {
      "provider": "fal",
      "model": "fal-ai/flux/schnell",
      "input": { "prompt": "a lighthouse at dawn" },
      "wait": true
    }
  4. Run BEA county economic data tables in a workflow step

    Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds BEA county economic data tables, 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 BEA county economic data tables

    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": "apps-bea-gov/economic-statistics/records_list",
        "input": {
          "state": "<state>",
          "table": "CAINC1"
        }
      }'

Then paste one of the prompts above: n8n finds BEA county economic data tables on Spiral, shows the price and runs it.

BEA county economic data tables providers and prices

Spiral runs BEA county economic data tables through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance

Settings you can ask for

Ask n8n for any of these in your prompt.

SettingAllowed valuesDefaultDescription
TableCAINC1, CAINC4, CAINC5N, CAINC6N, CAINC30, CAINC91, CAGDP1, CAGDP2 and 3 more

BEA Regional county table name (see source_status).

Every API field of BEA Regional Economic Accounts (county personal income, employment, GDP) · Records list is on its tool page: open its card above.

What can you do with BEA county economic data tables in n8n?

Keep a county economic briefing aligned with the latest available BEA publication. A scheduled agent can check publication details before refreshing income and GDP comparisons or verifying selected observations.

Compare counties for a business expansion

Compare county personal income, population, and GDP across a target state. Check the available publication first, collect the comparison table, and verify the figures used in the final shortlist.

Prepare a county economic briefing

Build a briefing with income, population, and GDP trends for a county and nearby counties. Confirm the available years and check the headline observations individually before publishing.

Study the sources of local income

Compare income components and industry earnings across counties. Check table availability, collect the relevant history, and verify the observations behind the largest differences.

Compare industry output across counties

Use county GDP tables to compare industry output across a state and over time. Confirm the available publication and years, then inspect individual observations behind the comparison.

Analyze long-term county income trends

Use CAINC1 history beginning in 1969 to compare county income and population trends. Check the available publication, collect the history, and verify selected turning points.

Refresh a public county comparison

Check whether a newer BEA publication is available before rebuilding county tables. Refresh the data and verify the observations shown in headlines and charts.

Questions about BEA county economic data tables in n8n

Can n8n use BEA county economic data tables?

Yes. Add Spiral to n8n as an MCP server, and n8n can find and run BEA county economic data tables like any built-in tool.

How much does BEA county economic data tables cost in n8n?

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

Do I need an Alexandria account to use BEA county economic data tables in n8n?

You need no Alexandria account. n8n uses one Spiral API key for every tool, and Spiral runs BEA county economic data tables on its own Alexandria account.

How long does it take to set up BEA county economic data tables in n8n?

About two minutes: create a key, then add an MCP Client node, then pick a tool.

Does n8n wait while BEA county economic data tables runs?

BEA county economic data tables runs in the background. n8n starts the run, checks on it and gives you the json when it's ready.

Which places does BEA cover?

BEA's regional accounts cover all 50 states, Washington, DC, and U.S. counties and county equivalents. County equivalents matter when matching BEA observations to a geographic lookup table.

How far back do the county statistics go?

CAINC1 personal income, population, and per capita income history begins in 1969. CAINC5N industry earnings and CAGDP9 real county GDP begin in 2001.

What is the latest published county data year?

The current county GDP and personal income release covers 2024 and was published February 5, 2026. BEA lists December 2, 2026 as the next release date.

Does every table have the same historical coverage?

No. CAINC1 starts in 1969, while CAINC5N starts in 2001, so an industry earnings comparison cannot use the full CAINC1 income history.

Are all returned observations numeric?

No. BEA values can include (D) and (NA), and those markers are preserved in the returned data. A calculation should keep those observations separate from numeric values.

Get started

Start using BEA county economic data tables in n8n

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

Paste this into n8n:

Set up n8n

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