Web Scraping Google Search Results With Google Sheets: No-Code Tutorial

By the end of this tutorial, you'll know how to scrape Google search results using Google Sheets. Specifically, you'll be scraping Google for SEO insights.

⏱️ Timestamps

Project Introduction - 00:00
Install The 'Import From Web' Add-On - 00:41
Format The Google Sheet - 01:42
Formatting Your Google Search Query - 02:27
Formula To Scrape Titles (SERP) - 03:38
Formula To Scrape Links (SERP) - 07:23
Formula To Scrape Descriptions (SERP) - 09:30
Thanks For Watching - 12:05

🧰 Resources

🤖 Screencasts

📝 Prompts

📚 Courses

🔗 Connect

[rubenvega]

So useful for SEO competitive analysis if you do not have budget to pay for a SEO tool. I use it to grab in a spreadsheet the articles written by competence to do then a further competitive keyword analysis. Thank you!

[daedalusjones]

You are an excellent instructor. Thank you!

[gianlucagalimberti]

Very good video tutorial! thank you Ravinder

[الحمد-شس]

Many Thanks man, This video helped me a lot.

[TECHNICALPOCKETofficial]

Streamly helpful video, to automate our daily task

[juliofebresSEO]

Is there a formula to scrape all the content inside of the webpage? By the way, excellent content.

[hamshank]

my div classes are completely different e.g. the titles are <span> not h3. What am i supposed to do?

[kiennguyenvan]

Thanks so much Ravinder. Very helpful tutorial. I have 3 questions: 1) can I put the results in columns instead of rows (I can see from your tutorial 10 rows for ten search results)? 2) instead of "buy bitcoin" can I refer the search to a particular cell? and 3) can generate google search from ONE particular website? Thanks in advance.

[RajNadar]

Ravinder, how do we scrape from the next page and so on w/o stopping at results from just the 1 page? also what are some of the applications of this capability?

[rizkihidayatcom]

How can I scrape the search results for the last 1 month?

[anthonycartategui]

How would you code to continue to scrape the urls on the next page?

[boblee]

Can you tell how to scrape only the number of "results" for each query so that I can have a column A with 100 KW and in column b I just want to populate the number of "results" for each query.. Also in this example since every query had 10 result, how I populate for multiple KWs at a time since every KW will be after 10 rows on column 1

[sherrybakshi]

I cannot search for div class='g' and probably that is why I am getting "all selectors return null" thru import web tool. pls help what am I doing wrong

[JoshuaWilson-xhpf]

Great content but needs to be updated. The step by step no longer applies here.

[chadg]

How would you do email and phone number if you used that in your search query?

[ishanharshvardhan]

hey bro amazing video....i had a question so is it possible to automate the entering query part...like what if I entered the thing that I want to search in a cell and then it could return me the first result from google search

[joshau]

Is there a way to scrap it with the search volume and keywords for each URL scrapped?

[Auto_Today]

Good content, but if you don't have enough proxy ip address for scraping, your ip would be blocked by google when you start to scrap lots of data in very short time.

[evenevening]

Ravinder,
thx for this tutorial:
clear & organized.

Q) wondering if:
more instructions on
" How to load in results from the following pages~ "

๑乛◡乛๑

[களவையும்கற்றுமற]

Informative video. Will it work with bulk scraping without getting banned?