[Integrations](https://spiral.ai/integrations) › [Zapier](https://spiral.ai/integrations/zapier) › [Census population estimates collection](https://spiral.ai/integrations/zapier/census-population-estimates-collection)

# How to Use Census population estimates collection in Zapier

Returns county or subcounty population estimates across a selected collection, optionally limited to one state. Use it to rank growth across places; county data also support analysis of births, deaths, and migration.

|  |  |
| --- | --- |
| Model | Census population estimates collection |
| Available through | Alexandria |
| Category | Public Records |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with Census population estimates collection in Zapier

- Each quarter, use Census population estimates collection to refresh North Carolina county population histories and report changes in the ten fastest-growing counties using one publication vintage.
- Every Monday at 9am: use Census population estimates collection to look this up and give me the result as a table.
- Pull the latest numbers from Census population estimates collection and tell me what changed since last week.
- Check Census population estimates collection and summarize what you find in three bullet points.
- Pull the newest data from Census population estimates collection and give me the result as a table.

## How to set up Census population estimates collection 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:

```text
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:

```json
{
  "provider": "fal",
  "model": "fal-ai/flux/schnell",
  "input": { "prompt": "a lighthouse at dawn" },
  "wait": true
}
```

4. **Run Census population estimates collection in a workflow step**: Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds Census population estimates collection, 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.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run Census population estimates collection**: One request; the result comes back by polling or a webhook.

```bash
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": "census-gov/census/popest_list",
    "input": {
      "file": "counties"
    }
  }'
```

Then paste one of the prompts above: Zapier finds Census population estimates collection on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/zapier

## Census population estimates collection tools and prices

- [US Census Bureau · Popest list](https://spiral.ai/tools/alexandria/census-gov/census/popest_list) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| state |  | — | Optional 2-digit state FIPS. counties: keeps that state's rows (state row included). subcounty: reads the per-state file sub-est<YYYY>_<n>.csv instead of the national file. Pattern: ^[0-9]{2}$. |
| sumlev |  | — | Optional summary level filter (050 counties only, 162 incorporated places, 061 county subdivisions ...). Pattern: ^[0-9]{3}$. |
| vintage | 2021 to 2035 | — | Vintage year YYYY of the 2020-YYYY directory. Default: the newest directory listed under popest/datasets/. |
| page_size | 1 to 2000 | — | Records (geography-years) per page; default 500. |
| continuation |  | — | Opaque cursor from the previous page's next_cursor. It pins the vintage, file, Last-Modified and size; when the source has moved on the call fails with invalid_input at /continuation (issue code publication_changed) instead of mixing versions. |

## What can you do with Census population estimates collection in Zapier?

Keep a regional Census briefing current by checking publications and refreshing county comparisons when new data appear. Track population vintages and poverty estimate years separately so revisions do not look like newly observed annual changes.

### Maintain a county community report

Build a report for Travis County, Texas, with ACS characteristics, population history, and poverty estimates. Find the datasets and variable definitions, resolve county identifiers, check publication status, compare statewide collections, and retrieve the county details for the narrative.

### Prepare a grant needs assessment

Document population change, poverty, income, and housing conditions for a proposed county service area. Use statewide collections as benchmarks, local records as evidence, dataset and variable documentation to define measures, and publication checks to keep the assessment current.

### Compare counties for business expansion

Compare North Carolina counties using population trends, household income, poverty, and ACS housing characteristics. Identify the appropriate datasets, measures, and county codes; check publication changes; rank the county collections; then examine shortlisted counties in detail.

### Plan regional library outreach

Compare Montana counties for outreach planning using population change, poverty, and ACS characteristics. Resolve service-area counties, find and define the measures, check publication status, compare the statewide collections, and add local population and income detail to each county brief.

### Rank population growth

Rank Texas counties by population change within one vintage, then inspect the annual history of the fastest-growing counties. Resolve county identifiers and check the population publication before refreshing the ranking.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All Zapier guides](https://spiral.ai/integrations/zapier)

## Census population estimates collection in other agents

- [Amp](https://spiral.ai/integrations/amp/census-population-estimates-collection)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/census-population-estimates-collection)
- [Claude](https://spiral.ai/integrations/claude-desktop/census-population-estimates-collection)
- [Claude Code](https://spiral.ai/integrations/claude-code/census-population-estimates-collection)
- [Cline](https://spiral.ai/integrations/cline/census-population-estimates-collection)
- [Codex](https://spiral.ai/integrations/codex/census-population-estimates-collection)
- [Cursor](https://spiral.ai/integrations/cursor/census-population-estimates-collection)
- [Devin](https://spiral.ai/integrations/devin/census-population-estimates-collection)
- [dots](https://spiral.ai/integrations/dots/census-population-estimates-collection)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/census-population-estimates-collection)
- [Gemini](https://spiral.ai/integrations/gemini/census-population-estimates-collection)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/census-population-estimates-collection)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/census-population-estimates-collection)
- [goose](https://spiral.ai/integrations/goose/census-population-estimates-collection)
- [Grok](https://spiral.ai/integrations/grok/census-population-estimates-collection)
- [Grok Build](https://spiral.ai/integrations/grok-build/census-population-estimates-collection)
- [Hermes](https://spiral.ai/integrations/hermes/census-population-estimates-collection)
- [Instinct](https://spiral.ai/integrations/instinct/census-population-estimates-collection)
- [Manus](https://spiral.ai/integrations/manus/census-population-estimates-collection)
- [Muse](https://spiral.ai/integrations/muse/census-population-estimates-collection)
- [Muse Code](https://spiral.ai/integrations/muse-code/census-population-estimates-collection)
- [n8n](https://spiral.ai/integrations/n8n/census-population-estimates-collection)
- [Notion](https://spiral.ai/integrations/notion/census-population-estimates-collection)
- [OpenClaw](https://spiral.ai/integrations/openclaw/census-population-estimates-collection)
- [opencode](https://spiral.ai/integrations/opencode/census-population-estimates-collection)
- [Perplexity](https://spiral.ai/integrations/perplexity/census-population-estimates-collection)
- [Raycast](https://spiral.ai/integrations/raycast/census-population-estimates-collection)
- [VS Code](https://spiral.ai/integrations/vscode/census-population-estimates-collection)
- [Windsurf](https://spiral.ai/integrations/windsurf/census-population-estimates-collection)

## More Zapier guides

- [Census local population history](https://spiral.ai/integrations/zapier/census-local-population-history)
- [Census population publication status](https://spiral.ai/integrations/zapier/census-population-publication-status)
- [Census geography lookup](https://spiral.ai/integrations/zapier/census-geography-lookup)
- [Census poverty and income collection](https://spiral.ai/integrations/zapier/census-poverty-and-income-collection)
- [Census dataset search](https://spiral.ai/integrations/zapier/census-dataset-search)
- [Census poverty publication status](https://spiral.ai/integrations/zapier/census-poverty-publication-status)

## Questions about Census population estimates collection in Zapier

**Can Zapier use Census population estimates collection?**

Yes. Add Spiral to Zapier as an MCP server, and Zapier can find and run Census population estimates collection like any built-in tool.

**How much does Census population estimates collection 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 Census population estimates collection in Zapier?**

No. Spiral runs Census population estimates collection on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up Census population estimates collection 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 Census population estimates collection runs?**

Census population estimates collection runs in the background. Zapier starts the run, checks on it and gives you the json when it's ready.

**How small an area can Census statistics describe?**

Coverage depends on the program and table. ACS five-year Detailed Tables reach block groups, while Subject Tables and Data Profiles reach census tracts; the SAIPE state and county files describe those larger jurisdictions.

**How current are Census estimates?**

Population estimates and SAIPE estimates are produced annually. An ACS five-year estimate combines 60 months of collected data, so its ending year does not make it a snapshot of that year alone.

**Why can an older population estimate change?**

Each new population estimates vintage revises the series back to the most recent census. The newest vintage supersedes previously published estimates for those dates, so a growth calculation should use one vintage throughout.

**Are poverty estimates exact counts?**

SAIPE uses statistical models to estimate income and poverty. Each state and county estimate is published with a 90% confidence interval, which matters when comparing counties with similar results.

**Why might an ACS one-year table omit a small community?**

Standard ACS one-year estimates cover areas with at least 65,000 residents. ACS five-year estimates cover all areas and are the appropriate product to investigate for smaller communities.

