pygsheets 2.0.6. Updating multiple cells with a single request. Data in dictionary format "address: value"

update_values_batch_dict.py

def update_values_batch_dict(ws, data):
    keys = list(data.keys())
    values = [[[val]] for val in data.values()]
    return ws.update_values_batch(keys, values)


gc = pygsheets.authorize()
sh = gc.open_by_key('***')
ws = sh.worksheet_by_title('***')

cells = {
    'A1': '1',
    'A2': '2',
    'A3': '3',
    'B1': '11',
    'B2': '22',
    'B3': '33',
}

update_values_batch_dict(ws, cells)