Skip to content
Home Pricing Docs Sign In

Google Search

WebToSheets turns a Google results page into rows of titles and links, which is helpful for SERP tracking and research.

lightbulb
There is no need to write this by hand. Open the sidebar's Formula Builder, pick Google Search, and type your query.
Pick Google Search, type a query, and each result becomes a title and link row.

Supported URLs

  • Page type: a search results page. The path must be exactly /search with a q query.
  • Domains: all Google domains, including google.com, google.co.uk, google.de, and so on.

For example, here is a Google Search URL you may scrape:

https://www.google.com/search?q=best+espresso+machine

Picking what to extract

By default, the result_title and result_link selectors each return a column of results, namely the first page of organic results (usually around 10 rows). If you only need one row, you may append /N to a selector. Here are the selectors you may use on a Google Search page:

Field Selector Example value
Result title Search result titles result_title + /N The 5 Best Espresso Machines
Result URL Search result URLs result_link + /N https://www.example.com/reviews
Total results Total results reported by Google total_results 1420000000

Examples

To capture the first page of results as title and link rows, you may pass the result_title and result_link selectors together:

=SCRAPE("https://www.google.com/search?q=best+espresso+machine", "result_title,result_link")
serp-tracking — Google Sheets
A
B
1
| The 14 Best Espresso Machines of 2026, Tested
seriouseats.com/best-espresso-machines-5185482
2
Best Coffee Machine: Espresso, Bean-to-cup, Filter and Pod
coffeeblog.co.uk/best-coffee-machine
3
Espresso lovers, whats the best espresso coffee maker?
reddit.com/r/JamesHoffmann/comments/1r042x5
4
What Is the Best Espresso Machine for Your Home?
downtown-mag.com/en/best-espresso-machine-for-home
5
The Best Home Espresso Machine
nytimes.com/wirecutter/reviews/best-espresso-machine
6
The Best Espresso Machine
coffeegeek.com/opinions/state-of-coffee/the-best-espresso-machine
7
Best Espresso Machine: the Final, Definitive Answer
wholelattelove.com/blogs/reviews/the-best-espresso-machine
8
Professional Espresso Machines
chriscoffee.com/collections/espresso-machines
fx

Alternatively, you may add /1 to keep only the top result:

=SCRAPE("https://www.google.com/search?q=best+espresso+machine", "result_title/1,result_link/1")
serp-tracking — Google Sheets
A
B
1
| The 14 Best Espresso Machines of 2026, Tested
seriouseats.com/best-espresso-machines-5185482
fx

Still stuck?

We usually reply within 24 hours on business days.

Contact support arrow_forward