Hello
it is possible to select in a google sheet rows whose current date is between a start date and an end date (the start and end date are included in the rows of the table)
thanks
Best answer
Select data where date include between start to end
- Beginner
Best answer by Troy Tessalone
Hi
There are advanced workarounds using filter/query formulas but there are limitations to be aware of, such as the number of rows that can be returned.
Perhaps consider using Airtable: https://zapier.com/apps/airtable/integrations
Airtable has an API that can be used: https://www.airtable.com/developers/scripting/api
Again, there are pagination limitations to be aware of such as 100 records per page.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+7- Zapier Solution Partner
Hey
Unfortunately this is not possible on Zapier. We can lookup only for exact values with Google Spreadsheet action.
+14- Zapier Orchestrator & Solution Partner
- Answer
Hi
There are advanced workarounds using filter/query formulas but there are limitations to be aware of, such as the number of rows that can be returned.
Perhaps consider using Airtable: https://zapier.com/apps/airtable/integrations
Airtable has an API that can be used: https://www.airtable.com/developers/scripting/api
Again, there are pagination limitations to be aware of such as 100 records per page.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.