I'm using a SpreadsheetsListFeed to read data from a Google Spreadsheet.
The sheet contains a table of customer data, including firstname, lastname, email, phone, etc. The column headers are in the top row of the sheet, and the data is in the subsequent rows. I figured a SpreadsheetsListFeed would be the best option since the data is in a tabular format.
However, now I need to use the python app to generate a customerid for each customer, and write it to the spreadsheet (only if it doesn't already exist in the sheet). I'm wondering if there is a way to do this through the SpreadsheetsListFeed or if I need to use a SpreadsheetCellsFeed and calculate the row/column values based on the existing SpreadsheetsListFeed.
The documentation for the python gdata library is a little sparse, so any help would be appreciated. Thanks!
UpdateRowit says:If you want to add additional information to a row, it is often easier to change the values in entry.custom, then use the Put method instead of UpdateRow. This UpdateRow method will replace the contents of the row with new_row_data - it will change all columns not just the columns specified in the new_row_data dict.- but I don't know whatPutmethod they mean. - Lexo