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 Google Sheet with contacts and custom fields directly to Gmail
- Write one email template and use @variables to personalize each message
- Send hundreds of unique emails without leaving your Gmail interface
- Skip the hassle of complicated mail merge tools or spreadsheet plugins
- Track all sent emails and responses from your Gmail sent folder naturally