Very straightforward using Integromat. Set it to monitor your promotions sheet for new rows added. When that triggers set it to read all rows in your users sheet, perform any filtering (e.g. only those who have subscribed etc) then email each one using their email field via SMTP (or a preferred bulk emailer). No need to change your sheet structure.