cell_list = []
headers = worksheet.row_values(1)
colToUpdate = headers.index('Weight')
cellLookup = worksheet.find('Leaf')
cellToUpdate = worksheet.cell(cellLookup.row, colToUpdate)
cellToUpdate.value = 77
cell_list.append(cellToUpdate)
cellLookup = worksheet.find('Pear')
cellToUpdate = worksheet.cell(cellLookup.row, colToUpdate)
cellToUpdate.value = 28
cell_list.append(cellToUpdate)
worksheet.update_cells(cell_list)
Python/gspread - how can I update multiple cells with DIFFERENT VALUES at once?