Mergo is a mail merge add-on for Google Sheets and Gmail that:
Connects to your Gmail to retrieve your drafts, and lets you choose the draft you want to reuse as the email template
Reads your Google Sheets (email addresses, column headers, cell content)
Sends emails according to the spreadsheet data as a campaign.
Some additional features can:
Connect to your Google Drive in order to insert attachments to your emails
Retrieve contacts from your Google Contacts' list
Provide reports on your email campaigns (emails opened, clicked, responded, bounced, unsubscribed).
This add-on is tightly integrated to your Google account and the data stored in the said account. When installing the add-on from the Google Workspace Marketplace, you will be prompted to authorize different accesses to your Google account. Those authorizations will only be used to perform the service you are requesting from the add-on you have installed.
To remove the add-on access to your Google account, you must uninstall the add-on from the Google Workspace Marketplace (see “User Account Deletion”).
Add-ons are created and powered by Google Apps Script, on Google servers.
Information gathered by Mergo will never be sold or shared to external people. When we need to store data outside of your Google account, we use Firebase, a serverless database developed by Google, so your data never leaves Google servers. We only store in Firebase data which is absolutely needed to provide our users the service offered by this add-on. Most data collected by our add-ons are directly processed within Google Apps Script and are not saved in any database for later reuse.
User Account Deletion
By using Mergo, we only access data that is absolutely necessary for the add-on to run correctly. If you wish to stop using our service, simply follow the steps below to uninstall Mergo from your Google account:
Go to the Google Workspace Marketplace Manage apps page
Next to Mergo, click the menu icon
From the drop down menu, click Uninstall
Uninstalling Mergo will interrupt all the add-on's functionality and activities on your Google account.
However, there is no automatic deletion of your user data in our database (Firebase). To get your data deleted, please send your request to email@example.com and we will proceed to the deletion within 30 days.
Depending on its security impact, data is classified according to the five following categories:
Confidential data has the highest level of security. Only the user has access to it. All emails from your Gmail box and files from your Google Drive are strictly confidential and Mergo never has access to confidential data.
Sensitive data is needed for Mergo to perform the service you are requesting from the add-on, and is never shared out of this scope. All sensitive data such as your recipients' email addresses and your email content remain under your control, within your Google account, Google Sheets, Gmail, and Google Contacts.
Shareable data can be shared to specific people within the company. For example, the Mergo Support Team may ask users to share their Google Sheets for troubleshooting purposes. We will never keep a copy of your spreadsheet data and we strongly encourage you to remove us access to your files once your request has been addressed and resolved.
Public data can be shared as public records, like all the content published in this Mergo's website.
Private data belongs to individuals who are responsible for the maintenance and backup.
When you install Mergo on your Google account, you are asked to accept the following authorizations:
Why does Mergo need those access scopes?
To send emails on your behalf
To retrieve your Gmail draft as the email template you'll use to send your mail merge with Mergo
To check your inbox and update the tracking stats if recipients replied to your emails
To read your list of recipients
To provide a campaign tracking report
To convert Google Docs into Gmail drafts and reuse them as templates for your campaigns
To link selected Google Drive files to specific recipients and send personalized attachments
To import your contacts from Google Contacts
To get access to Firebase, a database service from Google
View your country, language, and timezone:
To send your scheduled mail merge at the right date and time according to your location
To give you the right "sent date" in the merge statuses of your spreadsheet
To display Mergo in your language
Third-party web content in prompts and sidebars:
To open Mergo as a sidebar in your Google applications
Data we store:
Your Google account, to identify you as a Mergo user
If the tracking feature is enabled:
Your email tracking data, i.e. the numbers of emails sent, opens, clicks, replies, bounces, so you can have access to your campaigns stats in Mergo
The email addresses of your recipients who unsubscribed from your email, so you can remove them from your future mailing lists
The ID of your Gmail draft, so Mergo can retrieve it and reuse it as a template
Your setup and options saved in the Mergo sidebar (Sender Name, recipient column etc.)
Data we do NOT store:
Your contacts from Google Contacts
Your Gmail draft's content, emails received, and any other email content: All your emails stay in your Gmail box and you are the only one having access to your mailbox. We only access your draft so you can send your mail merge with Mergo, and the emails you received to track responses on your spreadsheet. We don't store any of your emails content in an external database.
Your Google Sheets' data: We don't make any copies of your spreadsheet data or store information on your recipients (email addresses, names, phone numbers etc.) on any database. Your spreadsheet data stays in your Google Sheets that solely belongs to you.
We only retain collected information for as long as necessary to provide you with your requested service. What data we store, we’ll protect within commercially acceptable means to prevent loss and theft, as well as unauthorized access, disclosure, copying, use or modification.
If your business or legal entity needs to be explicitly notified in case of changes to the terms, you may send an email to firstname.lastname@example.org to be added to our notification list.
Last updated: October 26, 2021