serpapi-mcp

A wrapper skill that calls SerpAPI’s MCP server (Model Context Protocol) via the mcporter CLI.

What this skill provides

• - Runs SerpAPI searches from OpenClaw via MCP (HTTP).
• Returns the full SerpAPI JSON to stdout (the primary contract).
• Optionally persists each query + response into Airtable:

- raw JSON (full SerpAPI payload) - a structured “summary” (Top 10 organics, PAA/Related questions, videos, images, counts, flags)

/serp usage

Treat this skill as providing the /serp command.

Syntax:

• - INLINECODE2
• INLINECODE3

Defaults:

• - INLINECODE4
• INLINECODE5
• INLINECODE6

Notes:

• - If you want SERP features such as People also ask (PAA), video packs, knowledge graph, etc., prefer:

- engine=google
- INLINECODE8

Examples:

• - INLINECODE9
• INLINECODE10
• INLINECODE11

How it works

Main script (prints JSON to stdout):

• - INLINECODE12

It calls this MCP tool endpoint:

• - INLINECODE13

Optional Airtable logger:

• - INLINECODE14

Requirements

1) MCP client (mcporter)

This skill requires mcporter installed on the host.

Install:

• - INLINECODE17

Verify:

• - INLINECODE18

2) SerpAPI key(s) + failover

You can configure either a single key or a failover pool:

• - Single key:

- SERPAPI_API_KEY

• - Failover pool (comma-separated, tried in order):

- INLINECODE20

Recommended placement (any of these is supported):

• - Skill-scoped:

- skills.entries.serpapi-mcp.env.SERPAPI_API_KEY
- skills.entries.serpapi-mcp.env.SERPAPI_API_KEYS

• - Global:

- env.vars.SERPAPI_API_KEY
- INLINECODE24

Failover behavior:

• - The script retries with the next key on common quota / auth / rate-limit errors (e.g. 429/401/403, “quota exceeded”, “rate limit”).
• For other errors (e.g. malformed request), it stops early and returns the error.

Optional: store searches/results in Airtable

Enable / disable

Enable logging:

• - SERP_LOG_AIRTABLE=1 (or true)

You can set this globally in the Gateway env (always on) or per-run when executing the script.

Airtable configuration (Gateway env)

Set these environment variables (do not store secrets in the repo/workspace):

• - AIRTABLE_TOKEN (Airtable Personal Access Token)
• INLINECODE28
• INLINECODE29 (table name or table id)

Write behavior & compatibility

• - Airtable does not auto-create fields.
• The logger is schema-aware:

- It reads the table schema via Airtable Metadata API. - It only writes fields that already exist in your table (by name). - It coerces values to the Airtable field type when possible (checkbox/number/text/select/date).

Airtable table schema (recommended)

Field names must match exactly.

Core:

• - Query → Single line text
• INLINECODE31 → Single line text
• INLINECODE32 → Number (integer)
• INLINECODE33 → Single line text
• INLINECODE34 → Date/Time

Provenance:

• - SerpApiSearchId → Single line text
• INLINECODE36 → URL
• INLINECODE37 → URL

Raw payload:

• - ResultJson → Long text
• INLINECODE39 → Checkbox

- (Back-compat: the logger also supports ResultJsonTruncated if you prefer that name.)

Structured summary:

• - SummaryJson → Long text
• INLINECODE42 → Checkbox
• INLINECODE43 → Long text
• INLINECODE44 → Long text
• INLINECODE45 → Long text
• INLINECODE46 → Long text
• INLINECODE47 → Long text

Flags + counts:

• - HasAiOverview → Checkbox
• INLINECODE49 → Checkbox
• INLINECODE50 → Checkbox
• INLINECODE51 → Number (integer)
• INLINECODE52 → Number (integer)
• INLINECODE53 → Number (integer)
• INLINECODE54 → Number (integer)
• INLINECODE55 → Number (integer)

Airtable size limits

Airtable has per-cell size limits. The logger truncates JSON strings if needed:

• - AIRTABLE_MAX_JSON_CHARS (default: 90000)
• INLINECODE57 (default: 90000)

Output

Returns SerpAPI JSON. Depending on engine and what Google shows, the payload may include keys like:

• - INLINECODE58
• INLINECODE59 / INLINECODE60
• INLINECODE61
• INLINECODE62
• INLINECODE63
• INLINECODE64 / INLINECODE65
• ads blocks (top_ads, bottom_ads, etc.)