Help (FAQ)

6. ScriptError: Authorization is required to perform that action

posted 9 Jan 2018, 08:08 by Andrew Dimech   [ updated 30 Apr 2018, 09:42 ]

If you get this error try one of the following solutions:
  1. Clear your browser's cache & cookies. If your using chrome follow these steps:
    1. On your computer, open Chrome.
    2. At the top right, click More More.
    3. Click More tools and then Clear browsing data.
    4. At the top, choose a time range. To delete everything, select All time.
    5. Next to "Cookies and other site data" and "Cached images and files," check the boxes.
    6. Click Clear data.
  2. Re-install the add-on by:
    • Remove the addon from Google Docs -> Add-ons->Manage add-ons... -> Mail Merge  -> Manage-> Remove
    • Install addon from Google Docs-> Add-ons->Get add-lns-> Search 'Mail Merge'-> Click 'Free' icon-> Follow steps
  3. Make a copy of your document template and try again from that copy.
  4. Try Chrome in Incognito mode or a different browser (Ctrl+Shift+N)

Why did this happen and how can I prevent it from happening again?

This happens when you switch to different Google accounts on the same browser. For example you may switch from to

To avoid this create a Chrome Browser user/profile for every account. Check the link below for more information on how to do this:

How can I print multiple documents in one go?

posted 28 Sep 2017, 05:29 by Andrew Dimech   [ updated 28 Sep 2017, 05:32 ]

There is a free web app which can help you do this. Just follow these steps:

  1. Go to
  2. Click the blue button 'Select files from Google Drive'
  3. Select your merged documents from the merged folder
  4. Then click the blue 'Merge' button
  5. This will create a single PDF document which you can then print in one go!


How can I include an attachment when merging to emails?

posted 22 Jun 2016, 11:50 by Andrew Dimech   [ updated 25 Feb 2018, 09:08 by Andrew Dimech ]

You cannot attach files to your emails directly. However you can add a link to file in your Google Drive as follows;

1. Add your attachment/file to your Google Drive (if not already there).
2. Right click the file from Google Drive and click 'Get shareable link'.
3. Copy the link from the dialog and paste it in your document template

3. How can I manage users in a site license?

posted 16 Jan 2016, 02:51 by Andrew Dimech   [ updated 22 May 2018, 13:44 by Andrew Dimech ]

You don't necessarily have to! Once the maximum number of licensed users is reached, new users will automatically disable the oldest inactive account. This frees administrators from managing the Add-on users.

IMPORTANT NOTICE: If you want to re-activate disabled inactive accounts you need to pay $30 administration fee to reset your site license.

What if I want to restrict which users are allowed to install the Add-on? 
Yes you can. Ask your IT Administrator to login to the Google Administrator Console first. Then paste the link below for more instructions from Google as you can see from the screenshot:

If your administrator is not in a position to do this, do not buy a site license. Instead you have to buy individual licenses. Otherwise other users in your site/domain can take your license.

How can my users install the add-on?
They can either search for the 'Mail Merge' add-on from Google Docs Add-on->Get Add-ons... menu or you can simply give them this link to install it:

How can I put a Merge Field in the Email Subject?

posted 14 Jan 2016, 10:36 by Andrew Dimech   [ updated 9 Jan 2018, 08:09 by Andrew Dimech ]

Just type the merge field in the Email Subject. For example if you have a column called 'Fullname', you can type the following:

Att: *|Fullname|*

That's all! Your emails will have their subject personalized like "Att: Andrew Smith"

1. How can I merge specific rows?

posted 10 Jan 2016, 08:28 by Andrew Dimech

Create a column in your sheet and name it whatever you want. Say ‘Exclude Rows’. Then type 'yes' or whatever (as long as its not empty) in the rows you want to exclude from merging.

Then open the Options dialog and set the ‘Exclude Rows’ in the ‘Merge Specific Rows’ option. Click save to apply changes.

When you merge to emails or letters, rows with a value in 'Exclude Rows' will be excluded from merging.

Are Headers/Footers supported?

posted 1 Jan 2016, 10:32 by Andrew Dimech

They are somewhat supported. However they don't really make sense when merging. If you have issues with them it is best to move the content to the document's body.

How do I fix blank pages when I merge to letters?

posted 1 Jan 2016, 10:31 by Andrew Dimech

In your document template make sure you leave some room for the text in your page grow. If you have content down to your footer most likely you will get blank pages into your merged document. Its best if you leave a couple of lines blank (not even carriage returns).

Can you merge into letters using images from Google Drive?

posted 1 Jan 2016, 10:29 by Andrew Dimech   [ updated 17 Sep 2017, 04:53 by Andrew Dimech ]

Yes you can. Just follow these steps:

  • The column containing the image url should be tagged with the value <img> (for example "<img> Photo" as shown below).
    • This tag would indicate to the Add-on that it should download the image from the link and not simply copy the url when merging.
  • If your image is on a google drive do the following:
    • Locate the image in Google Drive.
    • Right click the image and click ‘Get shareable link’.
    • Copy the link and paste it in your Sheet as shown in the image below.

What about security? Is the data in my sheet or document compromised by the add-on?

posted 1 Jan 2016, 10:29 by Andrew Dimech   [ updated 4 Nov 2017, 08:53 by Andrew Dimech ]

Customer's security is taken very seriously. The data processed by the add-on is NOT stored or transmitted to anyone for analysis. Not even the add-on’s owner.

The add-on however requires the following permissions for it to operate:

  1. Send and manage your email. One of the main features of the add-on is to send bulk emails through your Gmail account. Each email will be customized based on 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 never deletes emails from your account.
  2. 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.
  3. Manage your contacts. This permission is required to read the user's contact so it can retrieve his/her full name. The full name is then used as the 'From Display Name' in the emails sent. The user can optionally change this default value.
  4. 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.
  5. 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 100s of times with customized content.
  6. View and manage data associated with the application. This permission is required to save data related to the add-on. For example it needs to save the last spreedsheet id used. This will allow to automatically link the spreedsheet to the document next time the add-on is used.
  7. 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 into the future.
  8. Send email as you. The emails sent described in the first point will be sent under your email account.
  9. Connect to an external service. This permission is required to be able to log errors users encounter. This will help us rectify any issues in the system. It will also log general app usage so we would be able to know which features are being used.

1-10 of 19