https://basescripts.com/google-apps-script-send-email-how-to-send-emails-from-sheet-data-with-google-apps-script