How to create web page using google spreadsheet json?

[asfa.webmaster]

we have a google spreadsheet with manager and team details. I got to the point how to extract/filter a single line formatted as json (as shown below). What I would like to create is a page similar this one (only the address portion) http://www.aucklandfootball.org.nz/index.php?id=62

I have no idea how the coding needs to look like making use of a raw data formated as json.

Not sure if you hate me for it - but I am using expression web to create our site. I am not a programmer - however can understand code once I see it.

Using this query....
http://spreadsheets.google.com/tq?ke...pporters%27%29

...I get below json. How from here to a proper page?


google.visualization.Query.setResponse({version:'0.6',status:'ok',sig:'1763367110',table:{cols:[{id:'A',label:'Timestamp',type:'datetime',pattern:'dd/MM/yyyy HH:mm:ss'},{id:'B',label:'TeamID',type:'number',pattern:'#0.###############'},{id:'C',label:'Divisio n',type:'string',pattern:''},{id:'D',label:'Team Name',type:'string',pattern:''},{id:'E',label:'Ground Name',type:'string',pattern:''},{id:'F',label:'Manager (Full Name)',type:'string',pattern:''},{id:'G',label:'Manager email',type:'string',pattern:''},{id:'H',label:'Manager Home phone',type:'string',pattern:''},{id:'I',label:'Manager Mobile phone',type:'number',pattern:'#0.###############'},{id:'J',label:'Assistant Manger (Full Name)',type:'string',pattern:''},{id:'K',label:'Assistant email',type:'string',pattern:''},{id:'L',label:'Assitant Home phone',type:'string',pattern:''},{id:'M',label:'Assistant Mobile phone',type:'number',pattern:'#0.###############'},{id:'N',label:'Colour: Home Shirt',type:'string',pattern:''},{id:'O',label:'Colour: Home Shorts',type:'string',pattern:''},{id:'P',label:'Colour: Home Socks',type:'string',pattern:''},{id:'Q',label:'Colour: Away Shirt',type:'string',pattern:''},{id:'R',label:'Colour: Away Shorts',type:'string',pattern:''},{id:'S',label:'Colour: Away Socks',type:'string',pattern:''},{id:'T',label:'Colour: Away Socks',type:'string',pattern:''}],rows:[]}});

Thanks for some ideas, help or even lines of code.

Cheers