I would like to create a Google Sheets that will allow me to paste in a list of 25 or so keywords in column A and would then return the number of search results for each of those terms in column B.

Is that something that is possible?

Any suggestions?

I haven't been able to find much online.

  • 1
    You probably can't do that with just Google Sheets. The solutions I've seen for getting that number involve either using the Google Search AJAX API or doing screen scraping, neither of which are practical to implement in Sheets. – ale Dec 26 '17 at 20:46

Borrowing a formula that's been tried before, I was able to see results but it doesn't work consistently.

enter image description here

The first few times, the formula threw the error: Could not fetch URL: http://www.google.com/search?q=al jaffee

Going by the experience of others who have reported this issue on various forums, it works once in a while when the sheet is closed & re-opened


here it is - https://docs.google.com/spreadsheets/d/

cell B1: =VALUE(REGEXREPLACE(MID(INDEX(IMPORTHTML("https://www.google.com/search? q="&A1&"";"table";1);4;2);6;23);"\D+";))


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy