Skip to content
SheetMailMerge

Getting started

Overview

SheetMailMerge is a Google Sheets Add-on to enable you to do Mail Merge easily using Google Sheets and Gmail API.

screenshot

After you install our add-on, please refresh your document. To use this add-on, you need to buy lifetime license once for forever usage here: https://terrydjony.lemonsqueezy.com/buy/c5a72417-a981-4d61-9d24-c1238de86edc

Activate License

Please buy our lifetime license to use this add-on

How to Use

  1. Click Extensions > Mail Merge > Activate License alt text
  2. After license is activated,go to Click Extensions > Mail Merge > Open App
  3. Fill in the subject of the email. You can use variables by wrapping it in a double curly symbols.
    For example, you can use something like New Year Discount for {{name}}
  4. Fill in the email body. You can also use variables by wrapping it in a double curly symbols.
  5. If you use any variables, you need to click “Detect and Fill Variables” button to fill those variables.
  6. You need to specify the recipients of the email in a range of cells, such as “A2:A13”
  7. If you are using variables, you need to input the range of cells for each of the variables you used earlier, such as {{nams}} alt text
  8. Click “Send Emails” button to send email.. and then check your Gmail account. You’ve successfully send the emails! gmail

Limits

We’re using Gmail service in Apps Script for this functionality.

Refer to the documentation for the quota

This is the limit taken as of this writing (Jan 28, 2025): alt text alt text

Support

Feel free to contact at [email protected] for any questions, issues, or feature requests.