Explore how to code with Google Apps Script – Add menu item to UI tab and invoke a function that selects Google Sheet data and sends an email to the user from the selected cell data. Google Apps Script Complete Course New IDE 100+
Examples course example
https://www.udemy.com/course/course-apps-script/?referralCode=402FA7310931DB9AF4D5
Get the Source Code
https://github.com/lsvekis/Google-Apps-Script/blob/main/Sheet%20values%20Send%20Email%20via%20UI%20click