Skip to content

Tag: google-sheets-api

Authorisation Error 400: redirect_uri_mismatch – cannot generate needed token files for the ezsheets module

I need to use the ezsheets module which requires the use of both Google Drive and Google Spreadsheets APIs. I enabled them and have managed to gain the required credentials, which I passed in the python project folder. According to Google Spreadsheets documentation, the next step should be gaining the two req…

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…

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 …