NOTE TO MERGO USERS: Our license for Mergo has been extended through June 2025.
Mergo allows you to create a personalized email template in Gmail and perform a Mail Merge from Google Sheets with Mergo to hundreds of recipients within minutes
Video Demo - https://lehighonline.hosted.panopto.com/Panopto/Pages/Viewer.aspx?id=acba0941-e018-4252-9b1a-af3a00bff41c
...
Now that you have your Email Draft, you can open Google Sheets , and you should now see the Mergo icon on the right sidebar
After selecting the Mergo icon. Select the Cateogy Category that says says Mergo - Merge for Gmail 
Once you choose Mail Merge for Gmail. you should see the four headers appear on your Google Sheet
Email Address - Place the Email Address of the recipients in this column
First Name - Place the recipient's first name in this column
Last Name - Place the recipient's last name in this column
Merge Status - Leave this blank
...