Is there a way to filter a subset of rows within a Google Sheets Reader? As an example, a google sheet may have 50K records, but I only want to read 1k with a particular attribute value.
Question
Google Sheets Filter
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2Would imagine you can create a view in google sheets and use that link in the reader. The other alternative is to read the full sheet and use a tester.
I'd lead toward the tester since you are dealing with a small record set that will be downloaded instantly. Keeps you from having extra sheets floating around to accidentally be used later.
Would imagine you can create a view in google sheets and use that link in the reader. The other alternative is to read the full sheet and use a tester.
I'd lead toward the tester since you are dealing with a small record set that will be downloaded instantly. Keeps you from having extra sheets floating around to accidentally be used later.
I guess eventually, the number of total records will grow.
I tried your idea of creating a filtered view. Unfortunately the Google Sheets Reader V4 doesn't seem to recognize the filter itself. Great idea though!
+2I guess eventually, the number of total records will grow.
I tried your idea of creating a filtered view. Unfortunately the Google Sheets Reader V4 doesn't seem to recognize the filter itself. Great idea though!
I had never tried it. Figured it would work. My only other thought is to run a process before the process to download a CSV file and have that as the input in the 2nd process. Pretty simple to chain a batch file for the 2 processes together. Or possibly a feature reader? I dunno.
Example csv output with query; on my google sheets I did a query for records containing "c" from column A.
Full example URL
Google sheet
https://docs.google.com/spreadsheets/d/1qPraJC7No8c5lgH1vFkC3rp0A6yG75pbAkTMYH7SdaI/
Function call
/gviz/
Set export type and sheet
tq?tqx=out:csv&sheet=Sheet1
Set query string
&tq=SELECT+*+where+A+contains+"c"