google sheets + google meet + automatic generation of mural and adding to google meet or directly to mailer lite + automatic emailing in mailerlite

We are automating the sending of emails to our class participants. We want that when you add the @ addresses and date of the event in google sheet:

  • automatically generate a link to the mural to be added to the google meet event and/or directly to the message in mailerlite
    -automatically after creating an automatic link to the google meet event and mural the created links were added to the google sheet
  • after point two, so that automatically from the google sheet the entire list of participants with their @ was added to the automation created in mailerlite

How to connect this most efficiently? In what order? What to ask mural and mailerlite to get this connection set up correctly?

I will ask for hints.