← Back to library
MarketingWorkflow

Collect top-ten search results into a sheet with an agent

Anna Postol of SE Ranking tested OpenAI's Operator on keyword research, competitor analysis, SERP collection and outreach. It reliably pulled top-ten results per query, including URLs, titles, descriptions and AI Overview notes, into a Google Sheet. Deeper analysis was slow, error-prone and needed constant intervention, and it struggled to reach sites like Reddit.

  • OutcomeGather URLs, titles and snippets for your target queries from Google and Bing into a spreadsheet without manual copying, while knowing the agent's SEO limits.
  • SetupMinutes
  • LevelStarter
  • CreditAnna Postol
View original
Works with
ChatGPT agent

Published Oct 23, 2026Updated Oct 23, 2026AI dry run on sample input: passed Oct 23, 2026Source verified Oct 23, 2026

When should you use it?

  • You need raw search results for a list of queries
  • Copying them by hand is tedious
  • You have a dedicated SEO tool for deeper metrics

Not for: Full SEO audits; Backlink or keyword volume data

What do you need, and what do you get?

You need

  • A list of queries
  • A shared spreadsheet
  • OpenAI's Operator or a similar browsing agent

You get

  • Top-ten results per query
  • Separate columns for each search engine
  • Notes on AI answers and featured snippets

How does it work, step by step?

  1. Prepare the sheetCreate a tab with columns for each engine and result fields.
  2. Give the queriesList the searches and your site's audience and goals.
  3. Ask for structureRequest URL, title and description for each of the top ten.
  4. Flag special resultsHave it note AI-generated answers or featured snippets.
  5. Use proper tools for depthTake the collected data into your SEO platform for metrics.

The prompt

Our own prompt, inspired by Anna Postol and written to work in ChatGPT agent. Values in lime are placeholders.

Prompt0 variables
For each query in [list], search Google and Bing from [location]. In the sheet [link], tab [name], fill one column per engine with the top 10 organic results: position, URL, title and description. Note any AI-generated answer or featured snippet in a separate column. If a page will not load, write that rather than skipping it.

Inspired by Anna Postol: We Put ChatGPT Operator to the SEO Test: Here's What We Found. The prompt above is written by playbooks.bot in our own words; nothing from the original is quoted.

What can go wrong?

  • Results vary by location and personalization; note where the agent searched from.
  • Complex tasks needed so much babysitting that the authors did not recommend them.

Our take

Anna Postol of SE Ranking ran a fair test of OpenAI's Operator and drew a clear line: retrieval yes, deep analysis no. Pulling top-ten results per query, with URLs, titles, descriptions and AI Overview notes, into a Google Sheet worked reliably; deeper keyword and competitor work was slow, error-prone and needed constant intervention, and sites like Reddit were hard to reach. That split is a good general rule for browser agents in marketing. Use a clean browser profile and a fixed location so results are comparable week to week. Spot-check a few rows against a manual search, since one wrong position can skew a competitor review. Flag special SERP features in their own columns rather than stuffing them into the description. For depth, switch to proper SEO tools once the sheet is filled. Respect robots and terms; do not hammer search pages on a tight loop. Store the query and date with every row so historical comparisons stay honest.

Where the time goes back: Manually copying result pages for many queries is slow; the agent fills the sheet while you do analysis.

FAQ

Is it worth it for SEO?
The authors say not yet for complex work, but it handles simple retrieval well.
What did it cost?
It needed the $200 monthly plan at the time.

Source and credit

Inspired by Anna Postol. We describe the idea in our own words, link to the original, and wrote the prompt ourselves; nothing is quoted.

Inspired by
We Put ChatGPT Operator to the SEO Test: Here's What We Found
Creator
Anna Postol
Published on
seranking.com
Original date
Mar 28, 2025
License
Not openly licensed (the poster keeps all rights), so we quote nothing and link to the original
Originally for
ChatGPT agent
AI dry run
Oct 23, 2026: passed. Dry-run tested by our AI test agent on sample input. PASS: Gates held on desk check; no live sends or purchases.
AI dry run on sample data; not run with live connected accounts. The playbooks.bot test agent filled the prompt with synthetic inputs, produced the output and checked it against the page's stated outputs and guardrails.
Verified
Oct 23, 2026: source link resolves to the original, the credited creator published it, our excerpt or prompt matches it, and the license allows our use.

Are you the creator? Claim or correct this page.

More in Marketing

All 97 Marketing playbooks →

Related playbooks

MarketingPrompt✓ AI dry run

Answer a journalist's request using only facts you can back

For each media request, find out quickly whether you are a fit, then get a short answer-first draft built only from experience and data you confirmed, with unsupported lines flagged and the deadline checked.

Credit: Kourosh Ghaffari (@BuildingWaves)

Minutes
MarketingPrompt✓ AI dry run

Build an X brand assistant and hook bank

Research how you sound on X, keep a living bank of hooks and stories, and get post drafts you approve and publish yourself.

Credit: Miles Deutscher (@milesdeutscher)

Under an hour
MarketingRoutine✓ AI dry run

Get a morning shortlist of posts worth a quote tweet

Each morning, receive up to five fresh posts from your niche that still have room for your view, each with its link, score, reason and one angle, while every word you post stays yours.

Credit: James Camp (@JamesonCamp)

Under an hour