Cuiar
Sign inDownload

Export all your Search Console data to a sheet

All queries and pages for a date range, past the 1,000-row export limit, combined in one sheet.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Open Google Search Console for site url and the date range date range. The export button gives at most 1,000 rows, so filter the Performance report by each month and each top country, and export each part. Combine the parts in a new Google Sheet with a Queries tab and a Pages tab, with these columns: Month, Country, Query or Page, Clicks, Impressions, CTR, Position. Remove the duplicate rows. Compare the total clicks in the sheet with the report total, and tell me the gap.

  • It works in Google Search Console and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
site urlYour website, as it is set up in Search Consolehttps://crumbandcrust.com
date rangeThe first and the last day2026-01-01 to 2026-09-30

What you get back

An example run with the example values above. Your run uses your own data.

Search Console export: crumbandcrust.com, 1 January to 30 September 2026

Parts exported: 63 (9 months, 6 top countries and all other countries)

Queries tab: 38,410 rows. Pages tab: 2,906 rows

Clicks in the sheet: 512,300. Report total: 538,900 (95%)

The gap is from anonymized queries, which Search Console does not show.

Duplicate rows removed: 112

Sheet: Search Console export 2026, 2 tabs

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 2 blanks

    Type site url and date range. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Open Google Search Console for https://crumbandcrust.com and the date range 2026-01-01 to 2026-09-30. The export button gives at most 1,000 rows, so filter the Performance report by each month and each top country, and export each part. Combine the parts in a new Google Sheet with a Queries tab and a Pages tab, with these columns: Month, Country, Query or Page, Clicks, Impressions, CTR, Position. Remove the duplicate rows. Compare the total clicks in the sheet with the report total, and tell me the gap."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Export all your Search Console data to a sheet" template with site url = https://crumbandcrust.com; date range = 2026-01-01 to 2026-09-30.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open Google Search Console for https://crumbandcrust.com and the date range 2026-01-01 to 2026-09-30. The export button gives at most 1,000 rows, so filter the Performance report by each month and each top country, and export each part. Combine the parts in a new Google Sheet with a Queries tab and a Pages tab, with these columns: Month, Country, Query or Page, Clicks, Impressions, CTR, Position. Remove the duplicate rows. Compare the total clicks in the sheet with the report total, and tell me the gap."
  }
}

Related templates

All data templates

  • Marketing

    Find keywords to target for a topic

    Keywords with intent, your current position and difficulty, grouped into topics, with 5 posts to write first.

    You start it: When you start it
    • Google Search Console
    • Google Trends
    • Google Sheets

  • Monitoring

    Track my Google rankings for key searches

    A weekly position report for your key searches from Search Console, with the drops and gains.

    On a schedule: Every Monday at 7:00
    • Google Search Console
    • Google Sheets

  • Monitoring

    Check that my key pages stay in Google's index

    A weekly check of your most important URLs, with an alert when one drops out of the index.

    On a schedule: Every Thursday at 8:00
    • Google Search Console
    • Google Sheets

  • Data

    Turn a list on a website into a sheet

    Each item from each page, one row for each, with no duplicates.

    You start it: When you start it
    • Any website
    • Google Sheets

  • Data

    List local businesses with their contacts

    Name, address, phone, website, rating and e-mail for each business.

    You start it: When you start it
    • Google Maps
    • Google Sheets

  • Data

    Export your order history

    For stores with no export: each order in a sheet, with totals for each year.

    You start it: When you start it
    • Any online store
    • Google Sheets