I'm importing data from a Google Sheets spreadsheet, but I need to filter some rows and not load all of them. Someone runs this library, and knows if there is an argument to filter rows.
I am doing it in the following way so far:
import gspread from oauth2client.service_account import ServiceAccountCredentials scope=['https://spreadsheets.google.com/feeds'] creds=ServiceAccountCredentials.from_json_keyfile_name('Python- cbe875b7fd9f.json', scope) client=gspread.authorize(creds) sheet=client.open('Prueba Python').sheet1 preventivos=sheet.get_all_records() print(preventivos)
This I do since there is a column that has several options for example "NOGO", "MOC" and "AHM" option. I want to import only those rows that have the "AHM" option. In this way the load will be faster because now it takes several seconds and there is a lot of data that I do not care to import.