How to select record using range of date from google sheets

Questions
1

I am trying to filter the records from google sheets.

  1. Condition I need to apply a date range on column named Date.

could not find any example how to pass the range in filter for get many rows.

  1. How to use multiple values for filter Ex. for column Name i want to filter for records with value [Name1, Name2]

  2. How to get the records for a given month.

I cannot pull the entire sheet and use filter as the sheet i very large ~ 5k records and is expected to grow

4

Hi @Manu_Pratap, welcome to the community :tada:

n8n’s Google Sheets node does not allow this kind of filtering I am afraid. So you would need to think about alternatives here I am afraid.

If your current n8n instance does not come with sufficient memory to process 5,000 records in a single execution you could consider switching to a more capable database supporting the kind of filtering you need. PostgreSQL would for example let you write filters checking if a field value is within a range or if a string value is part of an array you provide.

If switching away from Google Sheets is not an option in your case you could alternatively consider adding new columns with a formula performing the check you have in mind. Then return a single value depending on the outcome which can be used in the respective n8n node.

Consider for example a formula like =TEXT(A2,"MMMM"). This would allow you to easily fetch all records in n8n for September like so:

image
image615×360 28.2 KB

image
image1180×866 54.4 KB

This would also work for your array by using a formula like =IF(OR(B3="bar", B3="baz"), "Yes", "No"):

image
image711×362 32.5 KB

image
image1183×866 54.7 KB

Hope this helps :slight_smile:

5

Thanks @MutedJam
this approach of using formula works.