Here is a complete example of a shopping list created as a Google Docs spreadsheet, that pulls its prices dynamically from Amazon.de. This is a list for my forthcoming new computer, that I’ll be hopefully putting together in the next couple of months.
Here’s the link. You can make your own copies from File->Make a copy… And with your own copy, you can modify it to be your own perfect shopping list for whatever. And this way you can actually mix dynamic prices from different webshops. I’ve added example scripts for two stores, that I will actually be using to get many of the stuff cheaper than from Amazon.
It’s not easy or totally automatic to create and modify this kind of spreadsheet, but once you understand how it works (and that each store requires its own script), you’ll be able to make budgets that are dynamic. For me this was a must have, as I’ll be making my purchase from several different webstores, and needed to find a way to compare their prices on a daily basis. Atleast Amazon prices tend to change all the time, and the price that is updated dynamically is not actually the cheapest Amazon price. There might be cheaper Amazon offers in the small print, but I haven’t yet looked for a way to fetch those prices dynamically.
And yes. My Amazon.de links in the spreadsheet contain sneaky affiliate links, that might give me some money, but I doubt that will actually happen. Feel free to replace the links with any Amazon.de product page links.