Tracking Keyword Positions

[ChapterEight]

Hello!

I've been working with the various Google Docs Spreadsheets out there taking advantage of web scraping using xml and the seomoz api.

I want to be able to track keyword rank by week, I've been playing around but can't seem to get it nailed on, I'm looking to put keyword in column 1, domain in col 2 and keyword rank on google uk in col 3.

Anybody done/seen anything like this in a G spreadsheet?

Cheers

Jamie