[Integrations](https://spiral.ai/integrations) › [Gemini](https://spiral.ai/integrations/gemini) › [Columbus contractor permit activity](https://spiral.ai/integrations/gemini/columbus-contractor-permit-activity)

# How to Use Columbus contractor permit activity in Gemini

Returns applicant businesses ranked by permit count, with total permit valuation for a date window. Use it to compare business activity across Columbus or within a ZIP code and work category.

|  |  |
| --- | --- |
| Model | Columbus contractor permit activity |
| Available through | Alexandria |
| Category | Listings |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with Columbus contractor permit activity in Gemini

- Use Columbus contractor permit activity to show the busiest plumbing applicants in Columbus during 2025, including permit counts and total permit valuations.
- Use Columbus contractor permit activity to compare roofing applicants in ZIP 43212 during 2025 by permit count and total permit valuation.
- Use Columbus contractor permit activity to look this up and give me the result as a table.
- Pull the latest numbers from Columbus contractor permit activity and tell me what changed since last week.
- Check Columbus contractor permit activity and summarize what you find in three bullet points.

## How to set up Columbus contractor permit activity in Gemini

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

### Use the Gemini connector

1. **Open Connected Apps**: On your computer, go to gemini.google.com. At the bottom, click Settings › Connected Apps. If you don't see Connected Apps, click Personal Intelligence first, then Connected Apps.

2. **Add Spiral as a custom app**: Under Custom apps, click Add a custom app and paste this MCP server URL:

```text
https://api.spiral.ai/mcp
```

3. **Sign in to Spiral and approve**: Follow the on-screen instructions. Spiral opens: sign in, pick the organization and click Authorize. No API key.

### Use the Spiral skill

1. **Send Gemini 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 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 Columbus contractor permit activity**: 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": "opendata-columbus-gov/building-permits/contractor_activity",
    "input": {
      "issued_since": "<issued_since>"
    }
  }'
```

Then paste one of the prompts above: Gemini finds Columbus contractor permit activity on Spiral, shows the price and runs it.

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

## Columbus contractor permit activity tools and prices

- [City of Columbus Building Permits (opendata.columbus.gov) · Contractor activity](https://spiral.ai/tools/alexandria/opendata-columbus-gov/building-permits/contractor_activity) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| zip |  | — | Five-digit site ZIP code, for example 43215. Pattern: ^[0-9]{5}$. |
| limit | 1 to 100 | 25 | Records per page. |
| cursor |  | — | The next_cursor of the previous page; repeat the same filters with it. Pattern: ^[0-9]{1,7}$. |
| permit_type |  | — | Case-insensitive substring over property class, permit kind, work category, general type and Census category: new structure, demolition, roof, plumbing, mechanical, fire protection, sign, commercial, multi family, single family houses detached, five or more family. |
| issued_until |  | — | Last issue date, inclusive (YYYY-MM-DD); open-ended when omitted. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |

## What can you do with Columbus contractor permit activity in Gemini?

Prepare a Columbus construction brief with public permit records and applicant-business comparisons. Ask for a ZIP code or trade, then inspect the published records behind the findings.

### Choose a supplier sales territory

Compare plumbing permit activity across Columbus ZIP codes, identify active applicant businesses, and inspect individual permits before preparing a business outreach list.

### Benchmark a contractor's recorded activity

Compare a public business's permit count and valuation with other applicants in the same work category. Review its matching permits and expand selected records to explain the comparison.

### Prepare a quarterly development brief

Summarize permits issued in ZIP 43215, compare applicant-business activity across quarters, and include full records for selected commercial permits.

### Research multifamily construction activity

Find multifamily permits, compare the applicant businesses associated with that category, and examine selected records for a housing development report.

## Overview

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

## Columbus contractor permit activity in other agents

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

## More Gemini guides

- [Columbus building permit search](https://spiral.ai/integrations/gemini/columbus-building-permit-search)
- [Connecticut solar and battery installations](https://spiral.ai/integrations/gemini/connecticut-solar-and-battery-installations)
- [Columbus building permit details](https://spiral.ai/integrations/gemini/columbus-building-permit-details)
- [Connecticut solar and battery installer activity](https://spiral.ai/integrations/gemini/connecticut-solar-and-battery-installer-activity)
- [Colorado DORA license types](https://spiral.ai/integrations/gemini/colorado-dora-license-types)
- [Craigslist housing posting details](https://spiral.ai/integrations/gemini/craigslist-housing-posting-details)

## Questions about Columbus contractor permit activity in Gemini

**Can Gemini use Columbus contractor permit activity?**

Yes. Add Spiral to Gemini as an MCP server, and Gemini can find and run Columbus contractor permit activity like any built-in tool.

**How much does Columbus contractor permit activity cost in Gemini?**

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

**Do I need an Alexandria account to use Columbus contractor permit activity in Gemini?**

No. Spiral runs Columbus contractor permit activity on its own Alexandria account. You sign in to Spiral once and never paste a key.

**How long does it take to set up Columbus contractor permit activity in Gemini?**

About two minutes: open Connected Apps, then add Spiral as a custom app, then sign in to Spiral and approve.

**Does Gemini wait while Columbus contractor permit activity runs?**

Columbus contractor permit activity runs in the background. Gemini starts the run, checks on it and gives you the json when it's ready.

**Does this cover all of Franklin County?**

The documented coverage is permits issued by Columbus Building and Zoning Services. A Franklin County location alone does not establish that its permits belong in this city-issued dataset.

**How far back do the records go?**

The city documents a period of record from 2010 to the present. Use 2010 as the documented starting point for historical comparisons.

**How fresh is the permit data?**

The city says the layer updates nightly as new permits are issued. Plan monitoring around that nightly schedule.

**Can I compare contractor activity by both volume and value?**

The provider ranks applicant businesses by permit count and permit value. Those measures describe activity recorded in Columbus permits.

**Can the permit data be reused in a commercial report?**

The provider identifies the dataset as CC0. CC0 permits copying, modification, distribution, and commercial reuse without asking permission.

