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

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

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, with a Spiral API key |

## Prompts to try with Data.gov.au table records in n8n

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

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

```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: n8n finds Data.gov.au table records on Spiral, shows the price and runs it.

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

## 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 n8n?

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 n8n guides](https://spiral.ai/integrations/n8n)

## 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)
- [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)
- [Zapier](https://spiral.ai/integrations/zapier/data-gov-au-table-records)

## More n8n guides

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

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

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

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

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

You need no Alexandria account. n8n uses one Spiral API key for every tool, and Spiral runs Data.gov.au table records on its own Alexandria account.

**How long does it take to set up Data.gov.au table records in n8n?**

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

**Does n8n wait while Data.gov.au table records runs?**

Data.gov.au table records runs in the background. n8n 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.

