Skip to main content

Monitor SEO and Keyword Rankings

By the end of this recipe, a weekly automation will check where you rank for every keyword you track, record how each one moved since last week, and post a movers-and-shakers report to your team — so your rankings watch themselves. Because your keyword list, your rank history, and your team channel all live in one workspace, the report and the running record stay in sync — no exporting a spreadsheet and pasting it somewhere before anyone reads it.

Readiness: Available now (built as an Automation). The version where a named SEO-analyst teammate runs the weekly check on its own schedule is rolling out in early access.

What it does​

SEO reporting usually means logging into a tool, exporting a spreadsheet, eyeballing what moved, and pasting the highlights into a channel — every single week. This recipe makes it automatic.

On the schedule you set, the automation:

  • Pulls the latest position for each keyword you track from your ranking data source.
  • Saves last week's number and writes this week's, so a Change column shows the movement at a glance — up, down, or flat.
  • Flags a sharp drop the moment it happens, pinging the owner instead of waiting for the weekly report.
  • Posts a plain-language report — biggest gains, biggest drops, and any keyword that broke into (or fell out of) page one — to your marketing channel.

The board is the running record; the report is the nudge. Together they turn "we should really keep an eye on our rankings" into something that just happens every Monday.

One honest thing up front: Copera doesn't crawl Google itself — it orchestrates. You feed it positions from a source you already have, and Copera does the tracking, the math across weeks, and the reporting. That's the credible way to do this, and it means the monitor works with whatever rank data you trust. The What it does list above is the outcome; the setup below is exactly how to wire it up.

Build it yourself​

One-time setup​

Create the SEO Tracker board

Make a board with a table for keywords. Add columns for Keyword (text), Target URL (a URL field), Priority (single-select: High, Medium, Low), Current rank (number), Previous rank (number), Change (a formula column, Previous rank - Current rank), Best rank (number, optional), Search volume (number, optional — a static reference figure), and Checked on (date). Add one row per keyword you track. This board is both your keyword list and your rank history. See Boards Overview if you're starting fresh.

The Change formula is what makes movement readable: because lower positions are better, subtracting this week's rank from last week's means a positive number is a climb (rank 8 to rank 3 shows +5) and a negative number is a slip.

Connect a ranking data source

Copera reads your positions from a source you connect once — pick whichever you already have:

  • A rank-tracking or SERP API — the most precise option, and it scales to hundreds of keywords. Store the API key in your workspace connections, then call it later with an HTTP request action (the "any external API" escape hatch). Search Console, your rank tracker, and most SEO platforms expose an API you can call this way.
  • A Google Sheet — if your SEO tool (or the Search Console add-on) exports positions to a spreadsheet, connect Google Sheets and read the latest numbers with its read action.

Both are real, supported feeds. See Connectors for how to add each one.

The weekly rank-tracker automation​

Trigger: Schedule

In Automations, start a flow with a Schedule trigger set to when you want the report — for example, every Monday at 7:00 AM, before the week's standup.

Action: Find the keywords

Add a Find rows action on the Keywords table to pull the set you want to check this run — for example, every row where Priority is High or Medium, or simply all active keywords.

Control flow: For each keyword

Add a For each loop over those rows so the next few steps run once per keyword.

Inside the loop — save last week's number

First, add a Copy field action that copies Current rank into Previous rank. Doing this before you fetch the new number is what preserves last week's position for the movement math.

Inside the loop — fetch this week's position

Add an HTTP request action that calls your rank API for this row's Keyword and Target URL, authenticated with the key you stored. Then add a JSON extract step to pull the numeric position out of the response (or an AI → Extract step if the payload is messy). Prefer the spreadsheet route? Swap the HTTP request for a Google Sheets → read step that looks up this keyword's latest row instead.

Inside the loop — update the row

Add an Update row action that writes the extracted number into Current rank, and a Set date to now action on Checked on. The Change formula column recalculates itself — no extra step needed.

Inside the loop — alert on a sharp drop (optional)

Add a Condition that compares this week's position to last week's — a Compare (or a Formula condition) that continues only when the keyword fell by 5 or more spots, or dropped out of the top 10. On the true path, add a Send notification or Send direct message action to ping the keyword's owner immediately, so a tank doesn't wait for the weekly report.

After the loop — write the report

After the loop finishes, add a Find rows action sorted by Change (biggest movers first), then an AI → Summarize (or AI → Generate) step prompted for the shape you want: "Write a short weekly SEO report with three sections — Biggest gains, Biggest drops, and New on page one — listing each keyword with its old and new position in plain language a marketer can skim."

Action: Post the report

Add a Post channel message action to your #seo or marketing channel with the report. Want a written archive too? Add a Create document action for a dated report doc, or a Send or draft email action to send it to stakeholders — as a draft first if you'd like to eyeball it before it goes out.

tip

Track the trend, not just this week. The single-row approach above always shows the latest movement. If you also want a chart-able history — "how has this keyword trended since we launched?" — keep a second Rank History table and, inside the loop, add a Create row action that logs one dated row per keyword per week (keyword, position, date). The tracker board stays clean; the history table becomes your time series.

Or just ask Copera AI​

You don't have to draw the graph by hand. Open Ask Copera AI and describe it:

"Create an SEO Tracker board with a Keywords table — keyword, target URL, priority, current rank, previous rank, and a change column that's previous minus current. Then build a weekly automation that reads each keyword's latest position from our rank-tracking API, saves last week's position first, updates the rows, and every Monday posts a summary of the biggest movers to the Marketing channel."

Ask Copera AI can create the board and its columns, then assemble the automation for you. With the default Ask before acting permission mode, it shows a review card for each change before anything is created — so you approve the board and the flow before they exist. See What Copera AI Can Do for its full capability list.

Want a look right now without building anything? Ask Copera AI to research your visibility on the spot:

"Search the web and tell me who's ranking on page one for 'project management software for agencies,' and whether we show up."

The assistant's web research is great for on-demand spot checks — who's ranking, which SERP features appear, whether you're visible — and for a deeper, cited dive you can ask it to run Deep Research. For precise, repeatable position numbers across many keywords, connect the API or Sheet feed above; web research reads the live web but isn't a numeric rank feed.

Make it a standing teammate​

Early access

Standing AI teammates are rolling out gradually. When one is available in your workspace, you can put a named teammate — an "SEO Analyst" — in charge of the rankings beat: it runs the weekly check on its own schedule, keeps the SEO Tracker board current, and posts the movement report to your channel under its own identity, with no automation to maintain. If you don't see teammates yet, they're on the way — and everything in this guide can be built today as an Automation.

Tips​

tip

Bring the numbers, let Copera do the tracking. The recipe is deliberately source-agnostic — an HTTP request to a rank API, a Google Sheets read, an inbound webhook from your SEO tool, or even a weekly ranking email you trigger on and run an AI → Extract step over. Whatever data you already trust, Copera turns it into a tracked, reported time series.

tip

Lead the report with the money keywords. Group keywords by Priority (or by the page they target) and prompt the summary step to call out movement on your high-priority terms first. A report that opens with the keywords tied to revenue gets read; a flat alphabetical dump gets skimmed and forgotten.

tip

Alert between reports, not just in them. Keep the in-loop drop condition even if it fires rarely — a priority keyword falling off page one is exactly the thing you want to hear about on a Tuesday, not next Monday. Route those alerts to the owner with a Send direct message, and keep the calm weekly digest for everything else.

tip

Set a spend cap on the run. Because it makes an API call and an AI summary on a recurring schedule (and more if you loop over many keywords), this automation draws automation and AI credits every week. Give it a per-automation spend cap so a big keyword set can never run past a budget you choose, and check the usage dashboard to see where credits go.

Frequently Asked Questions​

Can Copera track my keyword rankings automatically?​

Yes. On the schedule you choose, an automation pulls each keyword's latest position from your ranking data source, saves last week's number, writes this week's, and a Change formula column shows the movement. The same run posts a report of the biggest gains and drops to your team channel. Weekly is typical, but you can run it daily or monthly.

Where does the ranking data come from — does Copera need a separate SEO tool?​

Copera doesn't crawl search engines itself; it orchestrates. You feed positions from a source you already have — a rank-tracking or SERP API called with an HTTP request action, a Google Sheet your SEO tool exports to (read with the Google Sheets connector), an inbound webhook, or a weekly email it extracts the numbers from. Copera stores the data, does the math, and reports.

How does Copera calculate keyword movement week over week?​

Before writing the new position, the automation copies each keyword's current rank into a Previous rank field, then updates the current one. A Change formula column (previous rank minus current rank) shows the movement at a glance — a positive number means the keyword climbed. The first run just establishes a baseline.

Can I get alerted when a keyword drops?​

Yes. Add a condition inside the loop that fires when this week's position is several spots worse than last week's — or when a priority keyword falls out of the top 10 — and send an in-app notification or direct message to the owner right away, between the weekly reports.

How often does the SEO monitor run?​

On whatever schedule you set with the Schedule trigger. Weekly (say, Monday morning) suits most teams because search positions don't move minute to minute, but you can run it daily for a fast-moving launch or monthly for a stable site.

Do I need to write code?​

No. Build it on the visual Automations canvas by connecting blocks, or describe it in plain English to Ask Copera AI and let it assemble the flow and the board. You review everything before it runs.