Google SERP API & Google Sheets Integration [Tutorial]

How to get Google SERP data into Google Sheets

In this tutorial I’m going to show you how to import Google Search Results into Google Sheets using the SERPHouse API, which is a free Google Search API and Bing Search API in REST JSON format.

If you’re an SEO consultant you can use a Google Search API or Bing SERP API data to do SEO analysis or even build your own SEO tool.

There’s many SERP APIs available, and this example, we use the SERPhouse API which returns data on the top 100 search results for any keyword in Google or Bing.

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:

Install Apipheny
Sign up for SERPhouse and get your API key
Read the API documentation
Enter your API request in Apipheny
Run your API request

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. There is a 30 day free trial included.

1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: https://apipheny.io/install

2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.

In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.

Tip: you can open a new Google Sheet by entering this URL in your browser: sheet.new

Step 2.) Sign up for SERPhouse and get your API key

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.

Step 3.) Read the API documentation

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.

Step 4.) Enter your Google Search API request into Apipheny

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:

SERPhouse Google Search API entered in 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:

Google SERP data in Google Sheets via the SERPhouse API — Google SERP API data in Google Sheets via the SERPhouse API

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: