How to Mail Merge in Gmail & Google Sheets (for free)

In this step-by-step tutorial, learn how to Mail Merge using Gmail together with Google Sheets. This solution to mail merge is free.

• Additional resources:
  • Get Mail Merge spreadsheet: https://developers.google.com/gsuite/…
  • Gmail Daily Recipient Limits: https://developers.google.com/apps-sc…
• Timestamps
  • 0:00 Introduction
  • 1:06 Get Mail Merge spreadsheet
  • 1:54 Choose location for spreadsheet
  • 2:19 Prepare spreadsheet for Mail Merge
  • 4:50 Prepare draft email for Mail Merge
  • 7:13 Authorize script
  • 8:18 Run Mail Merge
  • 8:50 Review Mail Merge
  • 9:59 Advanced capabilities, like cc and bcc
  • 11:37 Email send limits
  • 12:15 Wrap up