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
- Import your contacts and data straight from Google Sheets by pasting the spreadsheet link
- Write your email template once and add custom variables like @name or @company
- Preview how your emails will look for each recipient before sending
- Send personalized emails directly through Gmail without switching between apps
- Use spreadsheet columns as variables to customize any part of your email content