I have a table which is presented as Python's list of lists and I'd like to write it down to some Google Spreadsheet using gspread
library. However, it seems that gspread
does not have such function out of the box. Of course I can use loop and update particular cells but it is very inefficient solution because it have to perform multiple requests (one request per cell). How to do it better?
This recent answer to a similar question seems much simpler:
my_list = [['a', 'b'], ['c', 'd'], ['e', 'f'], ['g', 'h']]
sh.values_update(
'Sheet1!A1',
params={'valueInputOption': 'RAW'},
body={'values': my_list}
)
BTW, the code was provided by @Burnash (gspread developer)