Using Google Sheets to bulk collect the number of Google Search results for given keywords

Question

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.}

Answer 1

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

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

Answer 2

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+";))