Welcome to the Airtable community!
What automation action are you using to send the emails? If you use Airtable’s send email action, you are stuck with the email coming from Airtable. If you use the Google or Outlook send email actions, you can pick the account used to send the email when you configure the email.
If you want different automated emails to come from different users (versus a Singer’sStudio user), how will you determine which email address to use, since automated emails are not associated with a specific user?