Hi

I'm trying to work out a way to continually pull data from Google's Admob into Excel. So far i've worked out that you need an API key to select the data you want to pull but I've got no idea how to get it working.

Does anyone have any experience of this sort of thing?

The data is in a javascript table not an HTML one so I cant do a standard web query. In admob I can click export to XML file which is working fine but I want to have the data being pulled automatically so we don't have to do this on a daily basis. Is this possible? If so how?

Many thanks