Send Personalized Emails Based on Google Sheet Data

Read the data from the Google Sheet at '[Google Sheet Link]', specifically from the sheet named '[Sheet Name]'. For each row, use the 'Email Address' column to send an email. Personalize the email subject with data from the '[Subject Column Name]' column and the email body using data from the '[Body Content Column Name]' column. The email should be sent from my Gmail account.

Apps used

GmailGoogle Sheets