Skip to content
Advertisement

Tag: gspread

Gspread batch update traceback

I am having problems trying to prepopulate google sheets filter and then do a batch_update. I get correct execution, the table is imported, filters are created. When the batch update occurs, I get a traceback that I don’t understand. I thought that the traceback may have come from the way I coded the sheetId. If anyone has some wisdom on

Unable to insert 2d array within gspread

I’m trying to insert a 2D array in order to get two columns inserted into a sheet via gspread. I’m able to insert the individual lists fine, but inserting the array causes an error. Here’s my code. Here’s the value of rows [[[‘$81.57’], [‘$80.91’], [‘$91.63’], [‘$91.63’], [‘$455.20’], [‘$196.90’], [‘$282.60’], [‘$146.10’], [‘$97.22’], [‘$166.70’], [‘$287.30’], [‘$237.50’]], [‘781411’, ‘781415’, ‘781412’, ‘781416’, ‘701355’, ‘701330’,

Get combined/merged cells value

I’m coding a new python script that need to extract data from google sheets, but there are many cells which are merged/combined, and only the top-left cell from this merge has the value. It’s important to have that value on all the merged cells. How can I do that? Python 3.8.5 + gspread 3.6.0 Note: every comment “trying to get…”,

GSpread Column Sizing

I am trying to adjust the width of columns in a google sheet using GSpread, however I can’t find any documentation on the subject all across the web. I have tried the actual project documents itself, and stack overflow. I have looked through the documentation, and stack overflow, and nobody has asked a question like this before. No code to

Advertisement