This task can be performed using Sendsheets
send personalized emails with google sheets
Best product for this task

Sendsheets
productivity
Hey @name! Sendsheets lets you send personalized emails using Gmail and Google Sheets. No more copy paste, or complex mail merge tools. Simply paste the sheets-link and write the email w custom variables. We built it because we wanted it ourselves.

What to expect from an ideal product
- Connect your Gmail and Google Sheets directly to send emails in bulk
- Type @variables in your email text to pull data from spreadsheet columns
- Simply paste your Google Sheet link and start sending personalized emails
- Write one email template and it automatically fills in details for each recipient
- Skip the learning curve of complicated mail merge software and send right from Gmail