Cuiar
Sign inDownload

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
Use in CuiarRun from your AI agent

What it does

The task

Open Google Search Console for site and read the Performance report for the last 7 days for these queries: queries. For each query, record the average position, the clicks, the impressions and the top page. Compare the values with the 7 days before and with the Google Sheet sheet url, and add this week's values in a new column. Send me each query that lost 3 or more positions or 20% of its clicks, with the page and a likely cause. Also list the new queries with more than 100 impressions.

  • It works in Google Search Console and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • As a routine it runs every Monday at 7:00 (cron 0 7 * * 1).

What you give it

BlankWhat to giveExample
siteThe property in Search Consoletidewell.app
queriesThe searches to track, or a sheet tab with themhabit tracker app, streak app, daily habit planner and 37 more
sheet urlThe sheet that keeps the historydocs.google.com/spreadsheets/d/1Sr4...

What you get back

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

Rankings for tidewell.app, 19 to 25 Oct against 12 to 18 Oct

Drops:

  • habit tracker app: position 6.2 to 9.8, clicks 412 to 241, page /habit-tracker. Likely cause: the page title changed on 21 Oct.
  • streak app: position 4.1 to 7.3, clicks 96 to 58, page /features/streaks

Gains:

  • daily habit planner: position 12.4 to 7.9, clicks 31 to 74

New queries with more than 100 impressions: habit tracker widget (180), habit tracker for students (140)

Sheet updated: 40 queries

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 3 blanks

    Type site, queries and sheet url. Tab moves to the next blank.

  3. 03

    Run it, then repeat it

    Run sends it once. To run it every Monday at 7:00, make a routine on cuiar.com/routines or with the CLI below.

As a routine, from the terminal

cuiar routines create "Track my Google rankings for key searches" --schedule "0 7 * * 1" --time-zone Europe/Berlin \
  "Open Google Search Console for tidewell.app and read the Performance report for the last 7 days for these queries: habit tracker app, streak app, daily habit planner and 37 more. For each query, record the average position, the clicks, the impressions and the top page. Compare the values with the 7 days before and with the Google Sheet docs.google.com/spreadsheets/d/1Sr4..., and add this week's values in a new column. Send me each query that lost 3 or more positions or 20% of its clicks, with the page and a likely cause. Also list the new queries with more than 100 impressions."

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 create_routine 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 create_routine to run my "Track my Google rankings for key searches" template with site = tidewell.app; queries = habit tracker app, streak app, daily habit planner and 37 more; sheet url = docs.google.com/spreadsheets/d/1Sr4....

Setup for other agents: AI agents.

The tool call

{
  "name": "create_routine",
  "arguments": {
    "name": "Track my Google rankings for key searches",
    "task": "Open Google Search Console for tidewell.app and read the Performance report for the last 7 days for these queries: habit tracker app, streak app, daily habit planner and 37 more. For each query, record the average position, the clicks, the impressions and the top page. Compare the values with the 7 days before and with the Google Sheet docs.google.com/spreadsheets/d/1Sr4..., and add this week's values in a new column. Send me each query that lost 3 or more positions or 20% of its clicks, with the page and a likely cause. Also list the new queries with more than 100 impressions.",
    "schedule": "0 7 * * 1",
    "time_zone": "Europe/Berlin"
  }
}

Related templates

All monitoring templates

  • 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

  • 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

  • Data

    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
    • Google Search Console
    • Google Sheets

  • Monitoring

    Track competitor prices in a sheet

    Each competitor's price and stock for your products, updated daily, with an alert on big moves.

    On a schedule: Every day at 6:00
    • Google Sheets
    • Any online store
    • Amazon

  • Monitoring

    Find new public tenders for my business

    New government tenders that match your services, with the value, the deadline and the documents.

    On a schedule: Every weekday at 7:00
    • Any government site
    • Google Sheets

  • Monitoring

    Find new grants my organization can apply for

    New grants that fit your mission and size, with the amount, the rules and the deadline.

    On a schedule: Every Monday at 9:00
    • Any government site
    • Any website
    • Google Sheets