Our customers' privacy is taken seriously. Data processed by the Mail Merge add-on is NOT stored or transmitted to anyone for analysis. It is not even analyzed by Quicklution - your data stays with Google. Hence, the information received from Google Application Programming Interfaces (API) will adhere to the Google API Services User Data Policy, including the Limited Use requirements.
To operate, the add-on requires the following permissions.
Manage drafts and send emails as you. One of the main features of the add-on is sending bulk emails through your Gmail account. Each email will be customized based on the data in your selected Google Sheet. The add-on requires this permission to be able to either send those emails or save them in your draft folder. The add-on does not have permission to view or delete any emails in your account.
Manage your basic mail settings. This permission is required to get a list of email accounts you have configured in Gmail under 'Send mail as' . This will allow the add-on to send emails from your preferred email account.
View and manage the files in your Google Drive. This permission is required to create a folder (for every merge) in your Google Drive root in order to save the merged letters/documents created, as described in point 5.
View and manage your spreadsheets in Google Drive. This permission is required to read data from spreadsheets in order to accomplish the customization required for each document/email generated in the merge process. Each row in a spreadsheet would result in a new email/document. The content of the email/document would be customized based on the data in the sheet.
View and manage your documents in Google Drive. This permission is required to be able to create Google Documents during the mail merge process. Users want to write a letter once and merge/replicate it hundreds of times with customized content.
View and manage your slides in Google Drive. This permission is required to be able to create Google Slides during the mail merge process. Used to generate multiple certificates (presentation files) based on the slide template created by the user.
View and manage your forms in Google Drive. This permission is required inorder to send an email notification upon a Google Form submit. The add-on will automatically change the form settings to collect the respondant's email address so that they can be notified.
View and manage data associated with the application. This permission is required to save data related to the add-on. For example, the add-on needs to save the last spreadsheet id used. This will allow the add-on to automatically link the spreadsheet to the document the next time the add-on is used.
Allow this application to run when you are not present. This permission is required to be able to send emails in the background even when your document is closed or your computer is shutdown. This feature is used to schedule emails to be sent in the future.