To help you get started right away, you can use this free Google Sheets template
Using the ImportFromWeb add-on and the function it adds to Google Sheets, you extract the Google related searches on a list of queries without any technical knowledge!
What you get?
With =IMPORTFROMGOOGLE(), you extract 8 Google Related Searches per query.
See all other Google Search data points
First of all, make sure you have installed the ImportFromWeb add-on from the Google Workspace Marketplace.
Then, just follow these easy steps:
Open a new Google Sheets and activate ImportFromWeb
To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.
Input your Google query
Add the search terms you want to use to your spreadsheet:
Write the =IMPORTFROMGOOGLE() function and extract related searches
To extract these data, you need to use the related_searches selector.
Just add this formula:
=IMPORTFROMGOOGLE(A1,"related_searches")
Within seconds, you’ll get the 8 related searches.
Modify the query
You can easily modify the query by changing the contents of the cell with the search terms. The function will automatically retrieve the related searches linked to your new query.
We’ve designed an easy-to-use template.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.
More Information
Frequently Asked Questions
How to extract Google autocomplete suggestions using IMPORTFROMGOOGLE?
IMPORTFROMGOOGLE can retrieve Google Search autocomplete suggestions for a keyword by utilizing a specific selector designed for this purpose. Simply use “suggestions” as the second parameter within the =IMPORTFROMGOOGLE() function:
=IMPORTFROMGOOGLE("your query", "suggestions")
For a ready-to-use Google Sheets template, visit our page: Google Suggest Scraper. It provides easy access to extract autocomplete suggestions efficiently.
How to extract Google People Also Ask questions using IMPORTFROMGOOGLE?
IMPORTFROMGOOGLE has a dedicated selector to retrieve Google People Also Ask questions related to a keyword. You can utilize this feature by using “people_also_ask_questions” as the second parameter within the IMPORTFROMGOOGLE function.
Here’s an example formula:
=IMPORTFROMGOOGLE("your query", "people_also_ask_questions")
You can also access our Google People Also Ask Question Scraper. This resource provides a ready-to-use Google Sheets template facilitating the extraction process.