I am looking for a way to issue SQL queries to a Google Sheet using Python.
I know that Google Sheets has a function called query that can be used to issue SQL queries from within the spreadsheet itself,
https://support.google.com/docs/answer/3093343?hl=en
Is there some way that I can call this function using Python? Maybe through the gspread module?
I expected there to be a way to call Google Sheets functions (like COUNT, SUM and others) using this package.
I am open to trying other methods as well. Basically, I want to query a Google Sheet like a database using Python.