Khan, inserting a record via the Records API is given in this example [1]: <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gs="http://schemas.google.com/spreadsheets/2006";> <title>Darcy</title> <gs:field name='Birthday'>2/10/1785</gs:field> <gs:field name='Age'>28</gs:field> <gs:field name='Name'>Darcy</gs:field> <gs:field name='CanVote'>No</gs:field> </entry>
"Bah!" you say, "you are using column names". Ah yes, but you can bind the names to column-letters at whim, using the Tables API [2]. You may even be able to use <gs:field index="">value</gs:field> ... but I will leave that exciting enquiry to you and the reference guide. Note that, just because the documentation says you should be able to do it, doesn't mean I'm necessarily claiming the Tables/Records API will actually work for you. But I'll be following your efforts with interest. Also, if your original code were to work at all, it'd stand the best chance if you used letters for column indexes instead of numbers. That's the clue I pick up from the Tables API's naming conventions anyhow. [1] http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingTableRecords [2] http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingTables
