144972 Grab city names and lat/long

I need a script or program, in whatever language you want, that grabs the full list of city names of USA (single states), Canada, UK, Germany, France, Italy, Spain, Australia, from Wikipedia and gets their latitude/longitude from Google Maps. When ambiguities are found in Google Maps for a city name (try for example "Agrate, Italy") it must choose the first Google suggestion and log the original name + that of the choosed suggested one in a text file named "[login to view URL]".