Hi everyone - I have a Airtable based that hosts events across states. And another base that hosts emails and location of users. I'm trying to create an automation that send emails weekly event reminders to users based on the event location that matches the users chosen locations
In the email list base - a user can input multiple location based on their preferences.
In the event based - events are listed based on state.
I think I should be doing the automation in the email list and link that to the event base. I hope to send a list or grid of event to X user name and email.
I was able to setup the first half of the automation using find records but not sure how I can automatically send the emails with limited manual work. could someone please help me out?
Happy to share my base to assist