CODEWITHSUNDEEP
pythongoogle-sheets-api
sganabis
sganabis

Reputation: 195

Get filtered data from Google Sheets API with python?

didn't found an answer. Is it possible to use Python Google sheets API e.g. service.spreadsheets().get() to get data from spreadsheet only matching some criteria. For example from this spreadsheet

I want to get names with timestamp older than 5/3/2020 12:00:00. Is it possible to get, or I need to retrieve all data and filter with script?

Thanks, and sorry for screenshot outside of topic.

Upvotes: 0

Views: 1599

Answers (1)

Alessandro
Alessandro

Reputation: 2998

Unfortunately it's not possible to retrieve a filtered range using the Sheets API in python.

Either you apply a filter to the entire range directly in your code or you can use Google Visualization API. Here you can find a guide on how to use the Google Visualization API with the Spreadsheet. Note that you will have to make your google sheet public in this case.

Reference

Google visualization API

Upvotes: 1

Related Questions