Tracking recurring monthly subscriptions

[Jesse_L]

Hey all! I’m a bit stuck here and hope that somebody might have an idea to share.

Context:

I have a table that lists a bunch of SaaS products that I use (such as Airtable!). Many of them have monthly recurring costs on the same date each month.

What I’m ultimately trying to do is create an automation that reminds me the day before each subscription is renewed every month, but for the life of me can’t quite work it out.

I think I need a date/time column that indicates the day of the month that each subscription gets renewed, and then I guess a formula that will trigger the automation 1 day prior to the renewal?

Hopefully that makes sense… thanks in advance for anybody that can assist! :pray:

[michedavis18]

I too am looking for some help with this as well. I am setting up a calendar for reminders in Automation but not sure how to get it to send me reminders 1 week or even 1 month prior to renewal so we can determine if we need to make any changes. Any and all help is appreciated.