Web Query - Submitting Data and Capturing Result

[Ben]

I have an Excel spreadsheet with a number of queries I want to submit to
Google in column A and I want to get the first result in column B.

I can work out how to get the result from the web page but how do I get the
spreadsheet to automatically submit each query to Google (A1, A2, ... An) and
refresh the data in column B?

[onb88]

I have the same question, 7 years later: has anyone found the answer yet? Thanks.