Skip to main content

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

Hey @Eric B ,

 

Unfortunately this is not possible on Zapier. We can lookup only for exact values with Google Spreadsheet action. 

Hi @Eric B 

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.

thank you for your answers

Terms & Conditions