How do I do a mail merge with Gmail?
Here's an excellent video tutorial on using gmail, google sheets and the free Yet Another Mail Merge add-in to do a mail merge:
You write a draft email in gmail, use this format to refer to column names in your google sheet when writing the email:
$%contact email address% where 'contact email address' is the column name, then click the 'mail merge' button, choose the gmail draft you want to send, test it on yourself if you wish, then send it to everyone in your spreadsheet. Very straightforward.
I found EmailBee provides an easy way of doing mail merges using your Gmail account:
Click "Sign in with Google" and go through the account creation process (basically a couple of clicks)
Once you are in, click "mailbox" on the left hand menu and then the "add mail" icon on the top right of the screen and away you go
NOTE: If you want to send to your Gmail contacts you need to import them:
Click contacts on left hand side menu and then add contact on top right
Select the "import" tab, click "google", click next and then click "start import"
If you use Google Chrome they also have a Chrome Extension which runs inside your Gmail client on Chrome.