SEO analysts
Weekly SERP checks
Favorable to scraping
Track how the first five organic listings shift for priority keywords, then join the CSV with rank trackers, crawl data, or internal content inventories.
Search Engine$50Free
Google SERP Scraper for Top 5 Results
This Google SERP scraper turns a list of Google search URLs into a structured CSV of the top 5 organic results for each keyword. It captures the keyword, a best-effort phone match, rank positions 1-5, result titles, URLs, and snippets so SEO teams can compare what Google shows without writing code or using a cloud SERP API.
Output
CSV
Result slots
Top 5
Input mode
URL list
Runtime
Local
Template
Free
At a glance
Export Google results without rebuilding spreadsheets
This template is for narrow, repeatable SERP capture: one row per keyword URL, five ranked result groups per row. It is useful when you need a quick market snapshot, a brand-monitoring evidence file, or a clean set of organic result URLs to enrich later.
Keyword-level SERP snapshots
Each input URL keeps its query attached to the export, so analysts can group rows by keyword instead of reverse-engineering screenshots later.
Five ranked result groups
The CSV keeps rank, title, URL, and meta description together for result 1 through result 5, making comparison tables easy.
Local custody
The workflow runs in the UScraper desktop app and writes to your configured folder. Your keyword list and export do not have to pass through a hosted scraper dashboard.
Built-in normalization
A JavaScript step cleans redirect URLs, recovers the original keyword from blocked redirects when possible, and pads empty result slots so the CSV shape stays stable.
Who this is for
Practical use cases for a Google search extractor
Agencies
Client reporting
Favorable to scraping
Export Google results before and after campaign work so clients can review visible titles, URLs, and snippets without relying on manual screenshots.
Market researchers
Category scans
Favorable to scraping
Collect top-ranking competitor pages across many search terms, then pass the URLs into sibling enrichment templates for contacts, page metadata, or review research.
How to use
From keyword URLs to CSV in five steps
1
Download and import
Use the template download link, import the JSON into UScraper, and keep a copy of the original workflow before making changes.
2
Add Google search URLs
Replace the sample URLs with your approved searches. The bundled pattern uses num=5, language and country parameters, and a clean search-result view.
3
Confirm the save folder
Set the Structured Export location and file name if you want a different path than google-search-results-scraper.csv.
4
Run a small batch
The workflow sets the window size, navigates, waits for load, handles a common consent button, and waits for the page body before extraction.
5
Open the export
The JavaScript normalization step prepares window.USCRAPER_SERP_DATA, Structured Export appends the row, and Loop Continue advances to the next keyword URL.
Output preview
What the Google SERP CSV includes
The export is intentionally wide: each keyword row contains the first five result slots. Empty slots stay blank, which keeps downstream formulas stable when Google shows fewer usable organic results or a consent page blocks extraction.
| keyword | phone_number | result_1_rank | result_1_title | result_1_url | result_1_meta_desc | result_2_rank |
|---|---|---|---|---|---|---|
| crawler | 1 | Web crawler - Wikipedia | https://en.wikipedia.org/wiki/Web_crawler | A Web crawler, sometimes called a spider or spiderbot... | 2 | |
| data collection | 1 | What Is Data Collection? - Simplilearn | https://www.simplilearn.com/what-is-data-collection-article | Data collection is the process of gathering, measuring, and analyzing accurate data. | 2 | |
| data analysis | 1 | What is Data Analysis? - Coursera | https://www.coursera.org/articles/what-is-data-analysis-with-examples | Data analysis is the practice of working with data to glean useful information. | 2 |
Field reference
| Field group | Columns |
|---|---|
| Query context | keyword, phone_number |
| Result 1 | result_1_rank, result_1_title, result_1_url, result_1_meta_desc |
| Results 2-5 | The same rank, title, URL, and meta description pattern for positions 2, 3, 4, and 5 |
Frequently asked questions
Automating Google Search may conflict with Google terms, robots guidance, snippet copyright, privacy rules, or local law even when results are public. Use low volume, do not bypass verification challenges, avoid reselling verbatim SERP copies, and get legal review before commercial reuse.
Before you run
Limits, maintenance, and responsible use
Keep pauses human, avoid parallel runs, and schedule batches conservatively. Local execution does not prevent Google from throttling repeated searches from the same network.
For adjacent workflows, try the Google SERP Scraper for a simpler one-page export, the Bing Search Results Scraper for cross-engine checks, and the DuckDuckGo Search Results Scraper for another search dataset. Browse the full library at uscraper.io/templates or install the app from uscraper.io/download.
Get Started
Download and use this template instantly
$50Free
What's Included
- Template JSON file ready to import
- Pre-configured scraping nodes
- Works with UScraper desktop app
Open-source templates
UScraper templates are open source. Improve this workflow or contribute a new one to help the community grow.
Contribute on GitHubBrowse more templates in the library
All Templates