Mariana Abreu
Mariana Abreu

Reputation: 41

gspread: Retrieve Filtered Data from GoogleSheets

I have a google sheet with a filter/query that only shows the data that verifies the filter's conditions. To retrieve the data for python I use gspread, but hiddenrows are appearing too (as if there was no filter at all).

How can I differentiate the rows selected from the ones who weren't?

I don't understand if this can work without adding more functions to gspread, or if I need to create a new function. If so, what should the function be?

Upvotes: 1

Views: 708

Answers (1)

Mariana Abreu
Mariana Abreu

Reputation: 41

I found that function fetch_sheet_metadata() which is inside class spreadsheet of gspread gives out the filters and hiddenValues for each filter, which is enough to solve my problem.

Upvotes: 2

Related Questions