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.
Your results
Run a search above. The rows land in this sheet.
| Row | Position | Title | URL | Displayed URL | Snippet | Snippet highlighted words | Sitelinks inline | Rich snippet | Source | Date | Query |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||||
| 2 | |||||||||||
| 3 | |||||||||||
| 4 | |||||||||||
| 5 | |||||||||||
| 6 | |||||||||||
| 7 | |||||||||||
| 8 |
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.
- Position
- Title
- URL
- Displayed URL
- Snippet
- Snippet highlighted words
- Sitelinks inline
- Rich snippet
- Source
- Date
- Query
From this page to your sheet
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. 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. 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")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.
More free scrapers
All free tools- Free Google Maps scraperType a kind of business and a place, and we pull the matching Google Maps listings with phone, website, rating and address. You see up to 5 results here; install SheetMagic free to get every result in Google Sheets.
- Free website traffic checkerEnter a website and see its estimated monthly visits, global rank, engagement and where its traffic comes from. Install SheetMagic to get every result as rows in Google Sheets.
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.
