Create Google Docs Spreadsheet to help Analyze our Prices vs Competition

We have product feeds for our two websites that contains Manufacturer SKU/UPC, quantity in stock, price, sale price, etc. We want a Spreadsheet created in Google Docs that can import this info and then import our competitors' prices from a big price aggregation site, called SlickGuns.com. Along with this import, the database/spreadsheet should be updated automatically every few hours to have a psuedo-realtime pricing comparison. So, for example, if you visit this link: [login to view URL] You’ll see that there are a dozen or so dealers that have this product in stock, ranging from $614.11 to $696.77. The info we would want from this site would be: -Our ranking, out of Total In Stock (8/14, for example) -Lowest & Highest Prices We’d also probably need the ability to exclude “x” number of entries, some SKU numbers are used for both firearms and accessories, causing the pricing table listed for these search results to be wonky (see example here: [login to view URL] where the cheapest four listings aren’t actually for the firearm). Here’s an example of our own Product feed (links provided on request, if necessary): <product> <sku>27593</sku> <name> Mossberg.300 Win Mag Bolt Action Rifle- Walnut Stock, Fluted Barrel, and Scope Package Mossberg 27593 </name> <permalink> [login to view URL] </permalink> <price>469.00</price> <sale_price>429.00</sale_price> <image> [login to view URL] </image> <quantity>0</quantity> <attribute_firearm-type>Bolt-Action Rifle</attribute_firearm-type> </product> Important info needed from our XML would be SKU, Price, Sale Price (if any), and quantity. Obviously if the item is out of stock on our site, no price comparison is necessary. I think this is almost all possible using the ImportXML and ImportHTML functions in Google Spreadsheets, but if there’s an easier way to do it, I’m open to other suggestions!