Dear all, how do I configure Zapier to filter the rows (in a spreadsheet) that have a date column that refer to the current day? For example, if I want to send an automatic message to the person on their birthday or when an installment payment is due?
Question
How do I set up Zapier to filter Airtable spreadsheet rows based on today's date?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Please clarify which app you are using for the spreadsheet.
If using Airtable, then use the native Views and Automations.
+6- Zapier Staff
Hi
Welcome to the Community.
To filter spreadsheet rows by the current date using Zapier, set up a Zap triggered by new or updated rows. Use 'Formatter by Zapier' to reformat the date column to 'YYYY-MM-DD.' Then, add a 'Filter by Zapier' step to match the formatted date with Zapier's 'Today's Date' function in the same format. Finally, add an action to send an automatic message, such as an email or SMS, based on the filtered rows. Test the Zap to ensure it works correctly.
I hope this helps. If you have any other questions or need further clarification, feel free to ask.
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.