How To
Aug 18, 2023

How to use SerpApi to Optimize Your Website for Search Engines

Executing an SEO campaign is more than just figuring out keywords and seasoning your blogs with some backlinks.

Truth be told, it involves bonafide detective work.

You need to solve the mystery of what your target audiences are searching for and what else might interest them. Fortunately, Google’s “People Also Ask” section has several clues to offer in the form of questions related to your target keywords.

Here’s the easiest way to identify questions and optimize your blog subheads and FAQs. Let us integrate SerpApi with Gigasheet's no-code data enrichment API feature to reveal untapped SEO secrets.  

About Gigasheet's No-code Data Enrichment APIs

If you find an API and get access to its API key, you can run it with Gigasheet.

Anyone can use Gigasheet to execute enrichment APIs. All you need to do is upload your data, copy and paste the API request from the API provider, customize the request, and run the data enrichment. It's that easy. You can learn more about this feature here, or keep reading to know how we used it with SerpApi.

About SerpApi

SerpApi lets you scrape and extract results from Google and other search engines with a fast and easy API integration feature.

The header image displayed on SerpApi's homepage

Here, we are using the Google Organic Results API. For each organic result on the Google SERP, SerpApi can scrape and extract the related questions that come under the ‘People Also Ask’ snippet.

how to use serpapi with Gigasheet

Provider Website: https://serpapi.com/

Provider Enrichment Docs: https://serpapi.com/organic-results

‍Endpoint:https://serpapi.com/search.json?q=[SEARCH_QUERY]&api_key=[API_KEY]&hl=en&gl=us&google_domain=google.com

Registration Required: Yes

How to Use SerpApi Without Code

Step 1: Make a CSV File With a List of Your Keywords

For this example, we’ve generated a list of keywords related to Gigasheet using Google Keyword Planner. If you’re running an SEO campaign, use the list of keywords you’re targeting.

(Pro SEO tip: If you want to do this experiment with a competitor’s website, you can use Google Keyword Planner to get a list of their keywords. Select ‘Start with a website’ and you’re done!)

When you have the data ready, upload it to everyone’s favorite online CSV viewer, Gigasheet. You can create your free account here.  

How the list of keywords looks like when uploaded to Gigasheet

Step 2: Adding The cURL

Click on Functions and go to Enrichments. Select Custom Enrichment (cURL)

Time to unleash Gigasheet’s no-code API integration powers. Paste the cURL in the text box and click ‘Next.’

You’ll see the ‘Add Sheet Values’ dialog box. Now, you need to modify this base URL as follows:

https://serpapi.com/search.json?q=[SEARCH_QUERY]&api_key=[YOUR_API_KEY]&hl=en&gl=us&google_domain=google.com  
  • In place of YOUR_API_KEY, paste the SerpApi API key you generated.
  • In place of SEARCH_QUERY, we will add the reference for the column that contains the list of keywords. In this example, the column name is ‘A,’ so we’ve selected A from the dropdown on the right. (Notice that you don’t have to take care of the syntax, Gigasheet does that for you.)
Adding the Custom Enrichment (cURL)

Click on ‘Test’.

Now, you can add sheet values, i.e., all the information you need from your GET query in one neat spreadsheet. You can just hit ‘Select All’ because you can always delete/hide unwanted columns later.

Select response fields friom the SerpApi data enrichment API

Since we want to focus only on the questions under the 'People Also Ask' section, we are selecting the columns containing /question.

When your custom enrichment is complete, you will see this message:

Success message

Step 3: And You’re Done!

Here are the results. Now you have a set of relevant questions you can use to write your website’s FAQ section or include in your blogs’ subheads.

The resulting dataset after the API enrichment

SerpApi lists down the most relevant questions related to each column entry. For example, for the keyword ‘convert Excel to Google sheet,’ you have the following FAQ ideas:

  • How do I open an XLSX File in Google Sheets?
  • How do I share an Excel spreadsheet in Google Sheets?
  • Do Excel formulas work in Google Sheets?
  • How do I copy an Excel table into Google Docs?

Congratulations! You’ve Cracked The Case

Now, you can:

  • Come up with blog ideas faster
  • Better satisfy the user’s intent, improve your rankings, and boost your CTR.  
  • Grab a spot in the coveted featured snippets space by using questions as your blog's subheads.
  • With relevant information added in a structured FAQ section, you also woo Google and make it go, "Wow, this website knows its stuff!" (Or as SEOs say, satisfy E-E-A-T guidelines.)

But, Wait- There is More!

Now you have a unique weapon in your SEO arsenal - a large CSV file complete with keywords and questions. View it anytime, share it with your team, and make the most of this data with Gigasheet.

Gigasheet is a 100% no-code business data analytics workbench. Without writing a single line of code, you can work with large datasets, merge CSV files, filter and group rows, and clean and enrich your data.  

Sign up for your FREE account today!

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Training
No Installation
Sign Up, Free

Similar posts

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.