title: How to use appendCells to append a list of columns in Google Sheets API
body: <p>I'm using python 2.7 but my understanding is this syntax works with any language.</p>
  
  <p>I'd like to append data to the bottom of my Google Sheets.  The function below works, but I'd like to know if there is a better way to:</p>
  
  <ol>
  <li>specify <code>userEnteredValue</code> on the column level instead of cell level</li>
  <li>not have to repeat the values list for each column.</li>
  </ol>
  
  <p>An example with my current method:</p>
  
  <pre><code>def insertOneRecord(sheetId, value):
      data = {
       "requests": [
         {
           "appendCells": {
             "sheetId": sheetId,
             "rows": [  {"values": [
                 {"userEnteredValue": {"stringValue": value[0]}},
                 {"userEnteredValue": {"stringValue": value[1]}}
                ]}],
             "fields" : "userEnteredValue"
           }
         }
       ]
     }
     res = SHEETS.spreadsheets().batchUpdate(spreadsheetId = SPREADSHEET_ID,body = data).execute()
  
  values = ['O','P']
  insertOneRecord(sheetId, values)
  </code></pre>