I have a spreadsheet with various financial information in Google Docs, and I'd like to make some kind of dashboard web page for myself to summarize things. Getting charts in is easy, however, putting in things like the totals of monthly outgoings.
I know I can save the spreadsheets to html, or embed the entire spreadsheet or select sections in an iframe, however I want to pull in a live data value from the spreadsheet and insert it somewhere using javascript, and maybe modify the value using some UI components for things like 'what ifs' or 'how long until'.
How would I do this?