Google Sheets Add-on — Aspose Mail Merge
Free Mail Merge by Aspose is a Google Sheets add-on designed to generate and send emails with customized content and attachments to a group of customers from the list.
Our Mail Merge add-on helps you integrate Google Sheets and Gmail services, which are part of Google Workspace, to carry out powerful email campaigns, increasing sales and achieving competitive advantages on the market.
Scope of Application
In the recent past the Mail Merge feature, originally incorporated in Microsoft Office products, was quite popular to generate and send individualized mass mail. With free Mail Merge add-on by Aspose this technology can be elevated to a higher level and applied to a vast range of newer tasks in almost all spheres of society.
Most importantly, Mail Merge provides a unique cost-effective opportunity to boost marketing strategies through sharing the latest company’s news and keeping continuous contact with the target audience. Mail Merge technology provides many attractive possibilities for delivering recent information to consumers easily with just a few mouse clicks. You can effectively use Mail Merge to meet the following challenges:
- Generate new leads
- Send periodic newsletters on your latest products or services
- Create event invitations and notifications for meetups and webinars
- Send PR campaigns to bloggers and journalists
- Distribute personalized invites to Zoom, Google Meet
- and much more…
Core Features and Capabilities
Our Mail Merge add-on provides a rich set of features and capabilities:
- Create email templates with a built-in editor or copy them from your email drafts
- Merge data from Google Sheets with your letter templates
- Mail Merge with attachments — transform document templates and data into customizable attachments
- Convert merged attachments to various formats
- Automatically import email addresses from Google Contacts
- Track the status of each email (sent/opened)
- Pre-send testing of your email campaign before sending real letters to customers
Mail Merge with Attachments
Free Mail Merge by Aspose allows not only to generate common emails with personalized content but also can be applied to generate customized attachments in DOCX, PDF, RTF and other formats (see the full list of supported file formats) and send them together with emails. Currently, you can process the very first document in your attachments by selecting the “Process the first attachment” option in the dialog box.
Privacy Policy and Terms of Service
Please read both Privacy Policy and Terms of Service agreements carefully before using our add-on. Among other information, these documents describe in detail how the add-on accesses, uses and stores user data.
By using the add-on, you acknowledge that you have read, understand and agree to be bound by the terms of the “Privacy Policy” and “Terms of Service” documents.
Installation
To install the add-on, please do the following steps:
- Sign in to your Google Account
- Navigate to Google Sheets online application
- Create a new spreadsheet
- Click “Add-ons”, then click “Get add-ons”
- Type “Aspose Mail Merge” in the search bar, click on the found item
- Click “Install”, then click “Continue”
- After the installation, click “Done”.
Usage
-
After having installed our add-on the first thing you have to do is fill your spreadsheet with data. This spreadsheet acts as a simple database and contains information to feed dynamically into emails and attachments. Each row in the spreadsheet represents data on a single customer except for the first row which contains the names of the fields. Add field names that you require in the first row, then fill in the
'A'column with a list of your customers. To accelerate the process, you can simply import contacts from Google Contacts by clicking the “Import Contacts” menu item. -
Prepare an email template with a built-in editor. It can be accessed under the “Add-ons/Aspose Mail Merge/Email Templates” menu option in Google Sheets. The letter template usually contains blocks of static content mixed with special Merge Fields. Merge fields are defined with curly brackets and act as placeholders for dynamic data substitution. Merge Fields are case-sensitive and should be carefully matched with the corresponding column names in the spreadsheet. For your convenience, we support two types of Merge Field template syntax:
-
The first one is based on the use of double curly brackets (‘mustache’ syntax), i.e.
{{First_Name}},{{Company}},{{Address}}. You can use the syntax of this type in the letter text, attachments, and even in the ‘Subject’ line of the email. -
The second option is to use the original Merge Field syntax proposed by Microsoft. Please note that you can use it in email attachments only. This syntax is more generic but requires a bit more effort to create. For details refer to the article by Microsoft.
-
Once you’ve got the basics of your email template created, you can run Mail Merge as a separate program. It can be accessed under the “Add-ons/Aspose Mail Merge/Mail Merge” menu option in Google Sheets. For testing purposes, you can send yourself a test email with all Merge Fields set to column names.
-
Our add-on interacts with Aspose.Words Web Services to process Mail Merge templates and track the status of each email. In the process of execution, Gmail and Google Sheets services will communicate and exchange data with one another producing a sequence of automatically sent emails.
Contacts
If you have any suggestions or questions, please contact us at mailto.