SheetMagicSheetMagic

Free Google Search Results Scraper for Google Sheets

Type a search and we pull the Google results with ranking position, title, link and snippet. You see up to 5 results here; install SheetMagic free to get every result in Google Sheets.

Try

Results show here on the page, not in your inbox. Your email caps free runs per person. We send one email asking you to confirm it; nothing else comes unless you click it. Privacy policy

Free. Up to 5 results, in up to about a minute.

Your results

Run a search above. The rows land in this sheet.

RowPositionTitleURLDisplayed URLSnippetSnippet highlighted wordsSitelinks inlineRich snippetSourceDateQuery
1
2
3
4
5

Install SheetMagic to get every result in Google Sheets

The same scraper runs from a formula in your sheet and writes every row there. The free plan includes 100 one-time scraping credits.

Free Google search results scraper for Google Sheets, in short

To scrape Google search results into Google Sheets for free, install the SheetMagic add-on and type =GSEARCH("best crm for small business") in a cell. It writes the organic results, with position, title, URL and snippet, to a results tab in your sheet. The free plan includes 100 one-time scraping credits, and you can try a search on this page first.

11 columns for every result

Each result is one row, with these columns in this order. Fields the source does not show stay blank.

  1. Position
  2. Title
  3. URL
  4. Displayed URL
  5. Snippet
  6. Snippet highlighted words
  7. Sitelinks inline
  8. Rich snippet
  9. Source
  10. Date
  11. Query

From this page to your sheet

  1. 1. Try it on this page

    Type a search the way you would in Google, add your email and press run. You see up to 5 results in a table, with no install needed.

  2. 2. Install SheetMagic for free

    Add SheetMagic from the Google Workspace Marketplace and click Activate. No card and no separate account. The free plan includes 100 one-time scraping credits.

  3. 3. Get every result in Google Sheets

    Type =GSEARCH("plumber austin tx") in any cell, or put one search per row in column A and drag =GSEARCH(A2) down. The results land in their own tab, with a column showing which cell asked for each row.

Who uses it, and for what

SEO agencies checking rankings

You track a list of keywords for each client. Put one keyword per row, drag GSEARCH down and see which pages hold positions 1 to 10, with titles and snippets to compare against your client's page.

Content writers researching a topic

Before you write, pull the pages that rank for your target search and read their titles and snippets side by side, so you can see what Google already rewards and where your angle differs.

Local businesses watching competitors

Search your service and city from the right country and device, and see who shows up above you. Run it again next month and compare the two tabs.

The same thing, inside Google Sheets

GSEARCH takes a search, then optional country, language, Google site, device and page offset, in that order. It reads one page of Google results per search and writes them to a results tab. Point it at a cell, such as =GSEARCH(A2), and drag it down to run a whole column of keywords.

=GSEARCH("best crm for small business", "us", "en")
Type it in any cell once SheetMagic is installed.

Other ways to do it

Copy and paste by hand
Free, but you copy each title and link one at a time, and your own search history and location can change what you see.
IMPORTXML in Google Sheets
Free, but Google often blocks the requests Sheets makes, so IMPORTXML comes back empty or breaks without warning.
Google's official search API
Documented and supported, but you need a Google Cloud project, an API key and code to write the results into a sheet.
SheetMagic GSEARCH
A search in a formula, with results written straight into Google Sheets. Uses scraping credits, and returns one page of results per search.

Questions

Is this Google search results scraper free?
Yes. Running it on this page is free and shows up to 5 results. To get every result in Google Sheets, install SheetMagic for free. The free plan includes 100 one-time scraping credits, and larger runs use those credits.
What data do I get for each result?
For each organic result: ranking position, title, URL, the displayed URL, the snippet, the words Google highlighted in it, inline sitelinks, rich snippet details, the source name, the date when Google shows one, and the search that found it. Fields Google does not show stay blank.
How many results do I get per search?
This page shows up to 5. In Google Sheets, each search reads one page of Google, which holds about 10 organic results. To see positions 11 to 20, ask for page 2, or set the page offset in GSEARCH to 10.
Can I check rankings in a specific country or on mobile?
Yes. You can set the country and language to search from, the Google site, such as google.co.uk, and desktop or mobile. Rankings often differ between countries and devices, so match the setting to the audience you care about.
Can I scrape many keywords at once?
On this page you run one search at a time. In Google Sheets, put one keyword per row in a column and drag =GSEARCH(A2) down. Every search runs as its own request and the rows are collected into one results tab.
Is scraping Google search results allowed?
The scraper reads the same public results page anyone sees in a browser, with no login and no private data. Google's terms of service limit automated searching, and rules differ by country, so check what applies to how you use the data.
Why do you ask for my email?
We send your results there and use it to stop abuse, since each run reads live pages. You can unsubscribe from any message we send. The results on this page show up right away; you do not need to open the email to see them.
All free tools

Free plan

100scraping credits, one time

Run the full Google search results scraper in Google Sheets.

Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.

Google Search Results Scraper for Google Sheets | SheetMagic