XML Google Product feed Magento

We need a connection from a XML Google Productfeed to our Magento shop. The feed is dynamic, so the connection needs to be dynamic also. Please refer to the attached XML feed to a 5 sample products from the feed. In total we have around 300 products in the feed. Also we would like to be able to make a selection from the complete productfeed, like filter for Apple products only. We need this to be done ASAP. So if you can start right away and finish today, that would be great. Also please note that we will grant you access to our store to check if the products where imported successfully and are actually working in the frontend. Most important fields to be imported are: - product title - product image - product description - product price - product availability - product MPN number - product id