Skip to main content

Email Automation for Specific Time

  • February 6, 2023
  • 4 replies
  • 170 views
L
Forum|alt.badge.img+1

Hi!

I have setup email automations through Airtable (trigger: when a record enters a view - action: to send email through gmail).

The issue is the email is being sent at midnight, which makes it evident that it is not a personal email from our team. How can I setup either the filter on the view, or the trigger/action so that all of our emails are sent at 8am PST? We have an enterprise account, so I feel like this has to be an easy solution, however everything I'm finding seems to incorporate like four additional columns and formulas, which seems really inefficient...

3 Attachments

4 replies

Ben_Young1
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • February 6, 2023

Hey @localemagazine! 

If you're not already doing it, I just wanted to quickly call out that you should also definitely reach out to Airtable through your dedicated enterprise support channels for quick help and support!

Now, regarding your use case, I would recommend that you pair a really clean formula field that reads a date/time value of when you'd like the email to fire off.
It would look something like this:

Here's what the formula looks like:

IF( AND( {Email Status}, {Date To Send} ), SWITCH( {Email Status}, "Ready To Send", IF( OR( {Date To Send} = SET_TIMEZONE(NOW(), "America/Los_Angeles"), {Date To Send} < SET_TIMEZONE(NOW(), "America/Los_Angeles") ), "⚙ Clear To Send", IF( {Date To Send} > SET_TIMEZONE(NOW(), "America/Los_Angeles"), "💬 Queued" ) ), "Not Ready", "🛠️ Not Ready", "Sent", "✔ Email Sent" ) )

Since you're working off of pacific time, you'll have an easier time.
You'd want to build your automation to fire off the email when a record meets the condition of the formula field returning a value of "💬 Queued", as shown in the screenshot. 

When the email is sent, you'd have your automation update the record's Email Status single-select field to reflect "Sent" which would then have the formula return "✔ Email Sent." 

The level of granular control that this gives you is both a pro and a con.
If you don't want your team to have to manage when the emails will be sent during the day, you can use something like this formula instead:

IF( AND( {Email Status}, {Date} ), SWITCH( {Email Status}, "Sent", "✔ Email Sent", "Not Ready", "❌ Not Ready", "Ready To Send", IF( DATEADD(SET_TIMEZONE({Date}, "America/Los_Angeles"), 14, "hours") > SET_TIMEZONE(NOW(), "America/Los_Angeles"), "💬 Queued To Send", IF( OR( DATEADD(SET_TIMEZONE({Date}, "America/Los_Angeles"), 14, "hours") = SET_TIMEZONE(NOW(), "America/Los_Angeles"), DATEADD(SET_TIMEZONE({Date}, "America/Los_Angeles"), 14, "hours") < SET_TIMEZONE(NOW(), "America/Los_Angeles") ), "⚙ Pending Send" ) ) ) )

This formula assumes a target email send time of 8:00 AM PT.

Again, you'd just have your automation fire off of the value returned from the formula field here and have the automation complete its actions by updating the email status field to "Sent."

There's tons of interesting and unique ways to approach the problem, really just depends on what your requirements are.

TheTimeSavingCo
bedjik
A
L
Forum|alt.badge.img+1
  • localemagazine
  • Author
  • Participating Frequently
  • February 6, 2023

Thank you Ben! I actually reached out to them last Thursday and Friday but still haven't heard back lol

I appreciate you sending all of this over and will take a look at how it works on our base!

K
Forum|alt.badge.img+2
  • kevinvaghasiya
  • New Participant
  • November 12, 2025

Airtable’s date triggers fire at system times. If you need exact scheduling (e.g., 9:00 AM local), connect your base to BaseMailer and schedule the send at a precise time. 

https://www.basemailer.app/

K
A
Forum|alt.badge.img+2
  • anthonyXRay
  • Participating Frequently
  • November 12, 2025

There are a few idea that I think could potentially work for this.  As I believe one was demonstrated above was creating new fields based on the “DATETIME_FORMAT()” function which would help determine when a record would enter the trigger view.  Another idea could be having the automation send the contents of the email to Zapier and then use a Delay step in Zapier to hold your email until the target time (8am PST).

Anthony at XRay
Terms & ConditionsAccessibility statement