Retrieve data from Google Sheets, send email via Gmail, and log in another Google Sheets

Retrieve data from Google Sheets when a new entry is added, send personalized email notifications via Gmail with tracking information, and log successful notifications in another spreadsheet for clearer reporting.