3 days reminder emails to tenants

[Hammad99]

Hi guys, I need your help.The scenario I’m working on is to send reminder emails to tenants. 3 emails sent three days before the rental date. I had problems with the filter.

[Stoyan_Vatov]

Hey there,

could you please share screenshots of the setup you have so far and what you are struggling with?

[Hammad99]

Note: I don’t know what I did here. I was following some videos.

[Hammad99]

I am waiting for you, my friend😓

[Stoyan_Vatov]

Yeah that filter is never going to work. You are checking if a date is 3 days earlier than it self.

Maybe you are looking to check if today is 3 days before the End Date variable?

[Hammad99]

Yes exactly.
Then email two days before, email the day before and maybe email on the day of payment

[Stoyan_Vatov]

What is the type of the End Date variable? Is it a “date” already or is it “text”?

In the second case you will need to parseDate() first and then you can add -3 days to it, then you can use {{now}} to get today’s date to check against.

[Hammad99]

Yes it’s “date” in Airtable.
Please could you show me an example in make or at least guide me in detail.
I am supposed to deliver this project to a client as soon as possible.

[samliew]

Welcome to the Make community!

You can have a scenario watch new items and schedule a cron job callback using apps like 0CodeKit that allows you to schedule a “callback” to a URL defined in a “Custom Webhook” trigger in another scenario at the exact time you want

You don’t have to use a data store, this is just an example. You can use Google Sheets, Google Calendar, etc.

Alternatively, if you are already using Airtable, you can use an Airtable formula and built-in automation, briefly mentioned here.

Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

— @samliew

[Hammad99]

By the way, this is a picture of the Airtable that might explain it to you. I don’t know what CodeKit is. If possible, I want to complete the scenario as it is. If you can help me with this, that would be great.

[Adeniji_Philip]

A very easy solution for this is to use OpenAi to check the date to see if today’s date is 3 days minus the date from the airtable database and return true if it is and false if not. As long as you know how to give OpenAi a good prompt, you shouldn’t have any problems with that.

That’s not the only solution though, you can also use text parsing and advanced logic.

But the OpenAI option is generally faster.

[SierraV]

Hi @Hammad99 - would a filter like this work?

{{formatDate(addDays(now; 3); "YYYY-MM-DD")}}

How to set up the scenario

1. Schedule the scenario to run every day

2. Add a router with 3 Gmail modules (one for 3 days before, 2 days before, and 1 day before contract ends)
   

   

3. For the first email due to be sent 3 days before renewal, add filter:
   

   

4. For the second email route, change the 3 in addDays(now;3) to 2: {{formatDate(addDays(now; 2); "YYYY-MM-DD")}}

5. For the third email route, change it to 1: {{formatDate(addDays(now; 1); "YYYY-MM-DD")}}

How this will work:

1. Scenario runs once a day and pulls records from Airtable
2. For each record, check if “Contract End Date” is 3 days from now, or 2 days, or 1 day from now
3. If any route matches, send corresponding email
4. (If no routes match, do nothing)

---

I would also suggest (if you haven’t done so already) applying a filter on Airtable records you retrieve to only fetch the ones where e.g. {Status} = 'Unpaid' or whatever the equivalent is in your table.

This is what the filter might look like in your Airtable module:

–
Cheers,
Sierra

[Vanesa_Paredero_Espe]

Good morning,

To perform that operation, you don’t need Make. Airtable can automate it easily depending on your plan.

I already have it automated with Airtable.

Best regards.