title: Python/gspread - how can I update multiple cells with DIFFERENT VALUES at once?
body: <p>To update a range of cells, you use the following command.</p>
  
  <pre><code>## Select a range
  cell_list = worksheet.range('A1:A7')
  
  for cell in cell_list:
      cell.value = 'O_o'
  
  ## Update in batch
  worksheet.update_cells(cell_list)
  </code></pre>
  
  <p>For my application, I would like it to update an entire range, but I am trying to set a different value for each individual cell. The problem with this example is that every cell ends up with the same value. Updating each cell individually is inefficient and takes way too long. How can I do this efficiently?</p>