How To Extract specific Google Results Into a Spreadsheet for data analyse.

Hej guys,

i have three rows in excel with three variables.

1. In the first I have a list of cities that I enter myself.



2. For the second row wich is about the number of the population in that city, I want to scrape that data from google search results. Google usually gives the result automatically, see below



3. and for the third and fourth row I want to scrape the search results from Google or a third party website. see below.


-------------------Scrape from google:

and


------------------------scrape from third party website

If I have to search all cities manually I will not be ready in a year !!! is there a code for this or a method or software for data analysis?


I really appreciate it if someone can help me with this....






--