API Integration Tutorials

Google Search API to Google Sheets: Google SERP API Tutorial

  1. By Meelad Mashaw

How to get Google Search API data into Google Sheets using a third-party Google SERP API

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:

  • Get data on tablet, desktop, or mobile search results
  • Choose the language and location you want to target

And you can get data on not just organic results, but also:

  • Ads
  • Knowledge Graph
  • People also ask
  • Local map pack
  • People also search for
  • Related searches
  • Carousel

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:

  1. Install Apipheny
  2. Sign up for SERPhouse and get your API key
  3. Read the API documentation
  4. Enter your API request in Apipheny
  5. Run your API request

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

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.

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

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.

Install Apipheny
Install Apipheny

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:

SERPhouse API key
SERPhouse API key

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:

https://www.youtube.com/watch?v=KE71XJP6o2E

Related articles:

TAGS :
Meelad Mashaw

Meelad Mashaw

Meelad is a data analyst living in the San Francisco Bay Area and Co-founder of the Apipheny API integrator for Google Sheets.

Related Posts

14 May

Discord API to Google Sheets: How To Import Discor

18 Jun

Twitter API to Google Sheets: Import Twitter Data

01 May

OpenWeather API to Google Sheets: Import Weather D

Leave a Comment

API Basics