Web Scrape Google Organic Search Results with Google Sheets and SerpApi | Basic Usage
In this video, we'll show you how to scrape Google Organic results and website rank using the SerpApi Google Sheets add-on. No coding is required, just regular Google Sheets functions, and cell referencing.
Links:
Add-on: https://workspace.google.com/marketpl...
Google Search Results API: https://serpapi.com/organic-results
Playground: https://serpapi.com/playground
Dadroit JSON Viewer: https://dadroit.com/
Our social links:
Twitter: / serp_api
GitHub: https://github.com/serpapi/public-roa...
____
Chapters:
0:00 - Intro
0:05 - Installation
0:32 - Adding SerpApi key
0:40 - Filling data into cells
0:50 - What is a query
1:17 - Filling other data into cells
1:22 - SerpApi rank function to see website rank
1:29 - Results output
1:38 - Location data/SerpApi Locations API
1:57 - Same keyword/domain with different location ranking example
2:12 - SerpApi result function to scrape part of HTML
2:24 - Understanding which selector to call
2:37 - Extracting more than one result
2:50 - Adding other optional parameters
2:57 - Outro
#serpapi #googlesheets #webscraping