Skip to main content

Question about automated email when a new record is created


Forum|alt.badge.img+2
  • New Participant
  • 2 replies

I'm totally new to Airtable automations, and these questions will probably show that.

I want to set up an automation where the trigger is "When a record is created" and the action is "Send an email." The To field will draw from a lookup field in the table that contains email addresses.

My first question is, if I create a record but don't enter an email address quite yet, will Airtable send an email when I go back and enter an email address later?

Also, if I set up this automation for a table that already contains records, will Airtable send emails for all existing records, or just ones I enter after turning the automation on?

4 replies

TheTimeSavingCo
Forum|alt.badge.img+28

re: My first question is, if I create a record but don't enter an email address quite yet, will Airtable send an email when I go back and enter an email address later?

Nope, it'll immediately attempt to send an email and will fail at that point.  You could get around this by setting up your automation to trigger when the lookup field that should have the email address isn't empty though?

---
re: Also, if I set up this automation for a table that already contains records, will Airtable send emails for all existing records, or just ones I enter after turning the automation on?

Just the ones you enter after turning the automation on!


Alexey_Gusev
Forum|alt.badge.img+23

Just want to add - if you want automation to run at the right moment, and also run it for several records already in the table, add checkbox field like 'Send mail' and trigger automation to it ("When record matches condition").
Note you can bulk-check field by pasting '1' or enabled checkbox cell


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 2 replies
  • August 17, 2023
TheTimeSavingCo wrote:

re: My first question is, if I create a record but don't enter an email address quite yet, will Airtable send an email when I go back and enter an email address later?

Nope, it'll immediately attempt to send an email and will fail at that point.  You could get around this by setting up your automation to trigger when the lookup field that should have the email address isn't empty though?

---
re: Also, if I set up this automation for a table that already contains records, will Airtable send emails for all existing records, or just ones I enter after turning the automation on?

Just the ones you enter after turning the automation on!


Great, thank you so much!


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 2 replies
  • August 17, 2023
Alexey_Gusev wrote:

Just want to add - if you want automation to run at the right moment, and also run it for several records already in the table, add checkbox field like 'Send mail' and trigger automation to it ("When record matches condition").
Note you can bulk-check field by pasting '1' or enabled checkbox cell


Thank you!


Reply