[Integrations](https://spiral.ai/integrations) › [Zapier](https://spiral.ai/integrations/zapier) › [Data.gov.au table records](https://spiral.ai/integrations/zapier/data-gov-au-table-records)

# How to Use Data.gov.au table records in Zapier

Returns rows from a resource stored in Data.gov.au's DataStore. Use it to retrieve the relevant part of a table for analysis without downloading the entire source file.

|  |  |
| --- | --- |
| Model | Data.gov.au table records |
| 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 Data.gov.au table records in Zapier

- Every month, use Data.gov.au table records on a previously selected Australian regional population DataStore resource to retrieve Melbourne rows and report differences from the previous extract.
- Every Monday at 9am: use Data.gov.au table records to look this up and give me the result as a table.
- Pull the latest numbers from Data.gov.au table records and tell me what changed since last week.
- Check Data.gov.au table records and summarize what you find in three bullet points.
- Pull the newest data from Data.gov.au table records and give me the result as a table.

## How to set up Data.gov.au table records 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 Data.gov.au table records in a workflow step**: Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds Data.gov.au table records, 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 Data.gov.au table records**: 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": "data-gov-au/open-data/query_datastore",
    "input": {
      "resource_id": "<resource_id>"
    }
  }'
```

Then paste one of the prompts above: Zapier finds Data.gov.au table records on Spiral, shows the price and runs it.

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

## Data.gov.au table records tools and prices

- [data.gov.au open data catalogue · Query datastore](https://spiral.ai/tools/alexandria/data-gov-au/open-data/query_datastore) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| q |  | — | Full-text search across all columns (Postgres websearch syntax). |
| sort |  | — | Sort, e.g. `_id asc` or `"2011-12" desc`; comma-separate several. |
| limit | 1 to 1000 | 100 | Rows per page. |
| cursor |  | — | Row offset to resume from: the `next_cursor` of the previous page. Pattern: ^[0-9]{1,9}$. |
| fields |  | — | Field ids to return; default all. |
| filters |  | — | Equality filters keyed by field id; a value may be a scalar or an array of scalars (any of). Example {"Income year1": "Number of individuals2"}. |

## What can you do with Data.gov.au table records in Zapier?

Maintain a weekly digest of changes to Australian government data sources used in your research. A scheduled agent can compare publisher, dataset, resource, and available table results with earlier snapshots to identify changes worth reviewing.

### Build a regional evidence pack

Identify relevant government publishers, find datasets about Melbourne, inspect their resources, and extract available DataStore rows for a regional comparison. Keep each result tied to its source dataset.

### Prepare council asset data for a map

Find a council's catalog entry and published asset datasets, inspect the resources, and retrieve relevant rows where DataStore access is available. Use the resulting locations to prepare a map of public infrastructure.

### Compare published reporting years

Identify the publishing agency and locate a dataset with resources for multiple years. Inspect each resource and extract comparable DataStore rows where available before calculating changes.

### Audit an agency's published data

Resolve the agency's catalog name, inventory its datasets and resources, and sample accessible DataStore tables. Produce a report showing which sources support row analysis and which require separate file retrieval.

### Diagnose a missing data extract

Inspect a dataset and its selected resource to establish where the data lives. If the resource is stored in DataStore, query its rows; otherwise identify the linked file that needs separate retrieval.

## Overview

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

## Data.gov.au table records in other agents

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

## More Zapier guides

- [Data.gov.au resource details](https://spiral.ai/integrations/zapier/data-gov-au-resource-details)
- [EUR-Lex Official Journal publications](https://spiral.ai/integrations/zapier/eur-lex-official-journal-publications)
- [Data.gov.au publisher directory](https://spiral.ai/integrations/zapier/data-gov-au-publisher-directory)
- [EUR-Lex legal act details](https://spiral.ai/integrations/zapier/eur-lex-legal-act-details)
- [Data.gov.au dataset search](https://spiral.ai/integrations/zapier/data-gov-au-dataset-search)
- [EUR-Lex legal act full text](https://spiral.ai/integrations/zapier/eur-lex-legal-act-full-text)

## Questions about Data.gov.au table records in Zapier

**Can Zapier use Data.gov.au table records?**

Yes. Add Spiral to Zapier as an MCP server, and Zapier can find and run Data.gov.au table records like any built-in tool.

**How much does Data.gov.au table records 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 Data.gov.au table records in Zapier?**

No. Spiral runs Data.gov.au table records on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up Data.gov.au table records 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 Data.gov.au table records runs?**

Data.gov.au table records runs in the background. Zapier starts the run, checks on it and gives you the json when it's ready.

**Does Data.gov.au cover only federal government data?**

It includes data published by Australian federal, state, and local government agencies. A search can therefore surface national statistics alongside council datasets.

**How fresh and accurate is the data?**

Data.gov.au explicitly does not guarantee dataset quality or timeliness. Its catalog should not be treated as a promise that every published dataset reflects current conditions.

**Does a dataset search return the underlying table rows?**

Search results represent datasets. Row access requires a resource loaded into DataStore; a resource can instead point to a file hosted elsewhere.

**How much historical data can I retrieve?**

Historical coverage depends on the resources supplied for the dataset. CKAN supports separate resources for different years, so inspect those resources before planning a year-to-year comparison.

**What attribution does Data.gov.au request?**

Its requested attribution includes the publishing organization, jurisdiction, dataset title, date sourced, and dataset URL. Preserve those details when preparing a report or derived dataset.

