Hi there, sounds good and as you say it can be done via Airtable.
As far as I know, Softr.io doesn’t have the capability to send emails, other than to users re: sign up/account password/magic link.
There is another recent thread re: bulk email sending and alternatives that is worth a read for some tips to help your use case.