In this tutorial I’m going to show you how to import Google Search Results into Google Sheets using a third-party Google Search API.
The Google Search API was deprecated a few years ago, which is why we have to use a third-party service.
In this tutorial, I’ll show you how to use the SERPHouse API, which is a free Google Search API and Bing Search API in REST JSON format.
You can use Google Search API and Bing SERP API data to do SEO analysis or even build your own SEO tool. The SERPhouse API returns data on the top 100 search results for any keyword in Google or Bing.
Some of the other features of the SERPhouse Google Search API includes:
And you can get data on not just organic results, but also:
The SERPhouse Google SERP API is free to use but there are also paid plans available if you want more features.
In this tutorial I’ll show you how to connect the Google Search API and Bing Search API SERP data in Google Sheets in 4 Steps:
Apipheny is an API integrator for Google Sheets. You can use Apipheny to connect to unlimited API data sources, make unlimited API requests to any endpoint, and more. Click here to learn more about Apipheny.
1.) Install Apipheny by opening the following link on desktop and then clicking the Install button on the page: https://gsuite.google.com/marketplace/app/apipheny/966163326746
2.) After you’ve installed Apipheny, open a Google Sheet and then click on Add-Ons in the menu at the top.
When the menu opens, you should see Apipheny.
Click Apipheny > Import API to open the Apipheny sidebar in your Google Sheet.
To pull data from the Google Search API to Google Sheets easily and without writing any code, first install and open the Apipheny Google Sheets add-on.
Apipheny is a no-code API integrator for Google Sheets that you can use to make unlimited API requests, connect to unlimited APIs (including the Google Search API), save API requests, schedule API requests, and more. Click here if you want to learn more about Apipheny.
1. Install Apipheny by clicking the Install button on this page.
Click here to sign up for SERPhouse.
After you’ve signed up, you’ll need to confirm your email address by clicking the link in the email that was sent to you.
After you verify your account, you’ll see your API key on your account dashboard, like this:
Just copy and paste your API key somewhere safe because you’ll need it in the following steps.
Click here to go to the SERPhouse documentation.
The documentation shows you how to structure your API URL, and gives you additional information on the parameters you can use.
Here is an example Google Search API request:
https://api.serphouse.com/serp/live?q=Trump&domain=google.com&lang=en&device=desktop&serp_type=web&loc=Alba%2CTexas%2CUnited+States&loc_id=2565&verbatim=0&page=1&api_token=YOUR_API_TOKEN_HERE
As we can see in this example URL, we are requesting data on “Trump” search results from the first page of Google, in English, on Desktop, with search results local to Alba, Texas.
All we need to do is replace “YOUR_API_TOKEN_HERE” with the API key found in our dashboard.
Here’s another, more simple, example URL:
https://api.serphouse.com/serp/live?q=how+to+make+money+online&api_token=YOUR_API_KEY
This URL requests data on the search results for “how to make money online” and does not include the additional parameters like device, language, or location.
Once you have the API URL that will return the information you need, all you need to do is plug it into Apipheny.
Here’s what our API request looks like when it’s entered into Apipheny:
Then, once you have your SERPhouse API URL entered into Apipheny, just click the “Run” button at the bottom of the add-on and the Google Search API data will automatically import into your Google Sheet, like this:
And there you have it, that’s how you can connect the SERPhouse API to Google Sheets so you can import Google Search and Bing Search data directly into your Google Sheets.
Once you’ve successfully made a request to the SERPhouse Gooogle SERP API, try querying the API using different parameters, or try using another SEO API and combine it with the SERPhouse data to create custom blends of data and reports.
Here’s some more example Google SERP APIs you can try:
Related articles:
Meelad Mashaw