How to trigger monthly reminders

[Michael_Townsen]

My goal is to send an email to every (50+) people every month that reminds them to submit timesheets.

I tried to set this up in Zapier, however Zapier will not run the same row twice… #fail.

So I set up an Integromat account, however Integromat requires a Last Modified Time as a trigger, so unless a row has a modification I have no way to trigger it for an email…

I’m kind of perplexed on how to do something very simple…

[ScottWorld]

There are several different ways to begin an Integromat scenario. You aren’t required to start with a “Watch Records” module. You can start with a “Search Records” module, a webhook module, or other ways as well.

So, in your case, I would start your scenario with a “search records” module, and then schedule the search to run once per month.

More details on Integromat’s Airtable integrations in the links below:

Integromat

Airtable App Help Docs | Integromat Help Center

Getting Started with Airtable The Airtable modules allow you to monitor records and submitted forms, or search, retrieve, create, update and delete r

Integromat

Airtable Integrations

Part spreadsheet, part database, and entirely flexible.

I also discussed this very topic in this week’s BuiltOnAir podcast:

[Justin_Barrett]

This could also be set up directly in Airtable. Create an automation that triggers once a month using the “At a scheduled time” trigger. Add a “Find records” action to search for records of email recipients (perhaps search for specifically-marked records if only certain people need to be reminded; otherwise find any record with an email address). In your choice of email action, design an email to send to those recipients (put their emails into the BCC field to keep the message header tidy).

[ScottWorld]

Justin’s idea is a great idea, too! And it keeps you fully within Airtable!

Note that Airtable’s automations will limit you to 100 unique email addresses per day.

[Michael_Townsen]

Good suggestion. However, I’m hitting the limit on both Airtable emails per day (100) as well as total automations (25)… so unfortunately I’m looking at Integromat here.