Google Search plays a central role in our digital lives, providing a gateway to the vast information available on the internet. It serves as a powerful tool for research, entertainment, shopping, and more. Businesses rely on it to enhance their online presence, drive website traffic, and connect with their target audience through search engine optimization (SEO) strategies.
Our no-code scraping solution offers time savings, customization options, seamless integration with Google Sheets, and the ability to obtain real-time data updates. Maximize your research capabilities and gain valuable insights with this powerful scraping tool.
Using the ImportFromWeb add-on and the function it adds to Google Sheets, you can extract your Google Search Results in bulk without technical knowledge!
What you get?
With =IMPORTFROMGOOGLE(), you extract up to 300 organic Google results per query with the following data points:
Open a new Google Sheets and activate ImportFromWeb
To activate the add-on, go to Extensions > ImportFromWeb > Activate add-on.
Input your keywords and write the =IMPORTFROMGOOGLE() function
Let’s retrieve the organic results for “gym club Brooklyn”.
This is the formula we need: =IMPORTFROMGOOGLE("gym club brooklyn")
Within seconds, you’ll get the following data points for your results: title, description, and webpage’s URL. Google may also include the publication date and the rating for some pages. For a full list of available data selectors, check out our Google Search selectors glossary.
Extract Google results for multiple keywords
The =IMPORTFROMGOOGLE() function can retrieve results for up to 50 sets of keywords! To collect data for multiple keywords, write them separated by commas or select a range of cells containing them:
Empower the =IMPORTFROMGOOGLE() function to fine-tune the results
The function has additional features which allow you to collect data using different options. You can specify these criteria using the function’s third parameter: options.
Specify the number of results
By default, the function displays the first 10 Google results. However, you can specify the exact number of results you want to retrieve, whether it’s only the first or the first 300.
For example, if you only want to retrieve the first result, use the following formula:
=IMPORTFROMGOOGLE("gym club brooklyn","title,body,link","num_results:1")
Choose the Google domain and results language
Our ready-to-use template is set to search within google.com, but you can change this setting to any domain you want.
The following example retrieves results from google.fr:
=IMPORTFROMGOOGLE("gym club brooklyn","title,body,link","domain:.fr")
Likewise, you can restrict the results to websites in a specified language.
The following example retrieves results in English only:
=IMPORTFROMGOOGLE("gym club brooklyn","title,body,link","languages:en")
Use “period” to filter by publication date
The “period” option allows you to filter the websites collected by publication date. You can select results from the past hour, the past 24 hours, the past week, the past month, or the past year.
For example, use this formula to retrieve results published in the past year:
=IMPORTFROMGOOGLE("gym club brooklyn","title,body,link","period:year")
Combine options
You can combine several options within the same function, like in the example below:
=IMPORTFROMGOOGLE("gym club brooklyn","title,body,link","domain:.fr,numResults:50")
We’ve designed an easy-to-use template. Make sure you have installed and activated ImportFromWeb in your Google Sheets.
How do I extract only the first Google result using IMPORTFROMGOOGLE?
By default, the =IMPORTFROMGOOGLE() formula returns the first 10 organic results from Google Search on any query.
To retrieve only the first result, you can use the num_results option as a 3d parameter of your function. This option allows to specify the number of results to extract for each keyword.
And here’s the formula to retrieve the first Google Search result:
How can I extract more Google Search results than the first 10 results?
By default, the =IMPORTFROMGOOGLE() formula returns the first 10 organic results from Google Search on any query.
To extract more than the initial 10 results, you can use the num_results option within the IMPORTFROMGOOGLE formula. This option allows you to specify the number of results to be extracted for each keyword.
Here’s an example formula to retrieve the first 100 results:
Please note that the maximum value accepted is 300. And this 300 records cap is set by Google itself (by the way, when you search on Google, you get a maximum of 30 pages with up to 10 records per page).
Why are some results missing or why don’t I get 10 Google Search results as expected with IMPORTFROMGOOGLE?
It’s important to note that the number of results you receive through IMPORTFROMGOOGLE is determined by Google itself and can vary based on several factors. Sometimes, Google displays widgets or other elements alongside search results, affecting the count and presentation of organic results.
This variation can result in cases where the expected 10 results might not be returned or where some results appear to be missing.
If obtaining precisely the top 10 results is crucial, utilizing an ARRAY_CONSTRAIN formula can be an effective solution. This function allows users to limit the number of rows and columns in the returned array, ensuring precise control over the displayed results.
Can I scrape Google Ads or paid results using IMPORTFROMGOOGLE?
No, IMPORTFROMGOOGLE function specifically extracts organic search results and does not support scraping Google Ads or paid results. So it only retrieves information from the organic search listings on Google.
Is there a way to extract emails from websites?
Absolutely! With ImportFromWeb, you can extract emails from websites using our list of generic selectors, which includes emails.
Here’s the formula you have to write: =IMPORTFROMWEB("https://www.example.com", "emails")
Just bear in mind that while these selectors are designed to work with a wide range of websites, the success of email extraction may vary depending on whether the websites follow general guidelines for design and data presentation.
Another way of getting emails is to use the IMPORTFROMGOOGLE function to perform a boolean search and extract the emails: =IMPORTFROMGOOGLE("search_terms","emails")
Why is IMPORTFROMGOOGLE not returning the expected results?
The Google Search Results depend on multiple factors like user location, search history, and personalization settings. Because of this, it can happen that the results you see on the Google Search page differs from the results that you get with IMPORTFRFOMGOOGLE. The results won’t be completely different but you might notice some minor differences.
The best you can do to approximate the SERP you have is to use the full URL in the IMPORTFROMGOOGLE function.
For further clarity and to see the Google Search Results page as fetched by our scraper, you can refer to this article.
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.
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.
How to extract Google Related Searches using IMPORTFROMGOOGLE?
To retrieve Google Related Searches associated with a keyword, IMPORTFROMGOOGLE offers a specific selector that facilitates this extraction. You can use “related_searches” as the second parameter within the IMPORTFROMGOOGLE function.
By incorporating this function, you can effortlessly extract Related Searches directly into your Google Sheets. Please note that typically, the number of related searches displayed is limited to 8.
Google search results are considered publicly available data, so scraping them is allowed. However, there are some types of data you cannot scrape (i.e., personal information, copyrighted content) so it's best if you consult a legal professional beforehand.
Typically, Google SERP API can return up to 300 results per keyword. Note that to obtain more than the default 100 results, you should specify the necessary number using the depth parameter. Your account will be charged for every 100 results.
Google's terms and conditions clearly prohibit scraping their services, including search results. Violating these terms may lead to Google services blocking your IP address. However, Google does allow for some scraping, provided you do it in a way that respects its ToS, as well as the privacy and rights of others.
Scraping publicly available data is thus permitted by the law. Scraping is legal. The legality of web scraping is clear. On Google Maps as well as on any set of data publicly available online.
Google's rules prohibit automated scraping, but whether it's legal depends on your intent, location, and what you're scraping. It's vital to be cautious, follow website terms, and ask for permission when needed.
Google uses an advanced anti-bot mechanism to block the bots from scraping their websites. So, you have to use residential or mobile proxies to bypass blocking. Data Center Proxies get more easily blocked than residential. Thus you can't use them for the longer term.
Note: The JSON API will never return more than 100 results, even if more than 100 documents match the query, so setting the sum of start + num to a number greater than 100 will produce an error. Also note that the maximum value for num is 10.
The Internet is way too big and expanding too fast for you to download or 'scrape' the whole thing. You might get close with downloading it if you had a huge data-center with multiple connections to the Internet and possible that whole data-center was configured as a single cluster of computers.
We do not sell your personal information to anyone. When advertisers bid on keywords and other criteria, Google serves ads to users without disclosing who those users are.
Making too many requests to a website in a short amount of time can lead to a ban. Implement a delay between your requests to mimic human browsing behavior and reduce the chances of detection.
Using a SERP Scraping API is by far the easiest option to scrape google results. Since you're using an API, you can call it from all programming languages, Python, C#, Java, Go, JavaScript, etc.
Application Security Manager (ASM) can identify web scraping attacks on web sites that ASM protects by using information gathered about clients through fingerprinting or persistent identification. Fingerprinting is collecting browser attributes and saving the information in a special POST data parameter.
If the results you want to remove meet one of them, your best bet is Google's request removal form. It'll guide you through a series of questions, ultimately leading to you submitting it for review.
Scraping public data is considered legal since this information is already in the public domain. However, while the data might be public, the collection of data should comply with Google's terms of service.
Introduction: My name is Patricia Veum II, I am a vast, combative, smiling, famous, inexpensive, zealous, sparkling person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.
