Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Feb 03, 2022 07:46 PM
I want to send an email every day at 12:00 p.m. to each record that matches a specific criteria.
Trigger: At a scheduled time
Actions 1: Find Records
Actions 2: Send Gmail
When I run the application with the above settings, the email addresses of the target users are included in the cc and the email is sent all at once.
How can I send each email individually?
Feb 03, 2022 08:56 PM
If you want a separate email for each record, you need to trigger each record individual.
One option is to change the trigger. Instead of using the At scheduled time trigger, use a When record meets conditions trigger. Use a formula field to approximate the time based on NOW()
, and whatever other conditions you have for your Find records action. Note that NOW()
is not exact, and can be off by as little as 5 minutes or as much as 2+ hours.
Another option is to take a two phased approach. The first automation has the trigger At scheduled time and it does a Find records action. Then, the automation links all of those records to a special “control” record. The Update record action can update a single control record, but it cannot directly update multiple records. Linking all of the records to a control record triggers the second automation. This second automation looks for the presence of that linked control record, and then sends the actual email, and unlinks the individual record.
Feb 04, 2022 03:50 AM
Alternatively, you may find it easier to do what I often do for my Airtable consulting clients:
Setup a free Integromat account for yourself, and send your individual emails from there.
Integromat automations will have at least 2 advantages for you:
Precise & advanced scheduling of your tasks, right down to the minute.
Emails are always sent individually. Emails are never sent in groups unless you specifically use the Array Aggregator to combine email addresses together into an array.
Your entire automation scenario would be as easy as 2 simple steps… check out the screenshot below:
p.s. This is pretty easy & straightforward to setup, but if you need to hire an expert Airtable consultant & Integromat Expert+ Partner to help you with any of this, please feel free to contact me through my website scottworld.com.
Feb 04, 2022 04:45 AM
Thank you for your help. That worked for me.