gspread icon indicating copy to clipboard operation
gspread copied to clipboard

Access the Google Sheets API for unsupported functionality

Open brianjmurrell opened this issue 2 months ago • 3 comments

I tried to find out if this was possible in the documentation but didn't find anything so I guess this ticket could be either a documentation bug/shortcoming or if it's not actually possible, it could be a feature request, either for the ability to interact with the Sheets API from a gspread Client or even better, the ability to manipulate charts. Understanding that the former would be much simpler than the latter, so either is fine with me.

I want to do some Google Sheet manipulation that is not exposed by gspread. Specifically I want to update the Data Range of a chart.

Given that gspread does not have any support for charts, I presume I would need to use the Sheets API directly to do that.

So the question is [how] can I use the Sheets API directly with the Client object I have open with gspread assuming I knew the chart id already?

FWIW, I did try StackExchange for this question before opening this ticket but my question there was closed by a moderator, so it seems that Stack Exchange is not always a suitable to place to ask questions about gspread unfortunately.

brianjmurrell avatar Oct 19 '25 20:10 brianjmurrell

hi ! thanks for the issue :]

we've just put gspread into maintenance mode since we took it over and no longer have enough time to maintain it :]

https://github.com/burnash/gspread/issues/1570

if you dig around in the code, you might find a way of using the Client object as you want :]

alifeee avatar Oct 22 '25 08:10 alifeee

@brianjmurrell I do have a pull requests for charts #1575

darkfiberiru avatar Nov 25 '25 17:11 darkfiberiru

@darkfiberiru Oh awesome. I'm going to add your PR to my local build here and give it a go. Thanks!

brianjmurrell avatar Dec 03 '25 14:12 brianjmurrell