Hi, I can make a research and may be create an example if nobody else did it for you. Just to be sure my work will be done for some prize not for "thanks" only. I have long experience with MS Excel, NPOI (php excel library), mysql, no with Google spreadsheet api. I hope google spreadsheet api looks similar to any ms excel like api... so if needed - please let me know about create the example.
I see 5 bids, probably somebody else already gave you a solution.
Thanks
Have a nice day