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.
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.
Provider Website: https://serpapi.com/
Provider Enrichment Docs: https://serpapi.com/organic-results
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.
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.)
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.
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:
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.
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.
The ease of a spreadsheet with the power of a data warehouse.
