send email automatically after formula has generated email address

Hello dear community,

I hope you are doing well.

I am currently facing a challenge with one of my boards, which is the following:

I have a board with a files column, some other columns and a formula column which concatenates the items’ names with the domain @a1studio.com, so that, for instance, if a new item is added with the name “DS1107”, the formula column will generate a value DS1107@a1studio.com

I want the monday platform to send an email to each email generated by the formula column with the files uploaded in the files column attached.

I do not know if there’s an automation capable of doing this. I tried Zapier integration, but it has a 14-day only Trial Period, and it is complex to set the proper configurations.

Could you please advise what would be the best course of action?

Thanks in advance

Best,
Bruno