How to Mail Merge Letters in Google Docs

Personalise letters in less time with this super effective mail merge add-on for Google Workspace in Google Docs.

One super effective mail merge add-on for Google Workspace in Google Docs is autoCrat first covered in this earlier post: Top 7 Mail Merge Add-ons for Gmail & Google Drive.

This same technique can also be used to personalise any other type of document that is kept in Google Docs.

Step 1: Get your data & letter template ready

To perform a mail merge in Google Drive, you need to have the following:

1. A Google Sheet that contains the data you want to merge into the letter.

2. A letter template in Google Docs that has merge tags using a <> format. Put a merge tag wherever you want personalised information to go. Try and match these tags to the column headings in your spreadsheet to speed up autoCrat configuration. 

An example spreadsheet and document template are shown below.

Step 2: Install the autoCrat add-on

To install the autoCrat add-on:

3. Open the Google Sheet with your data.

4. Select the Add-ons menu > Get add-ons.

5. Search for ‘autoCrat’ using the search box in the top right corner.

Once you have located autoCrat, click the +Free button to install it.

7. Choose the Google account you want to use autoCrat with and allow it the permissions it needs to run.

Step 3: Configure autoCrat to create and email letters

These instructions will configure autoCrat to create a PDF letter from the merge data and email it to recipients.

1. In the Google Sheet, select the Add-ons menu > autoCrat > Launch or Open.

2. Click New job.

3. Give the job a name that reflects the letters you are creating. Click Next.

4. Click the From drive button. Search for the Google Docs letter template that has your merge tags. Click on it and then click Select. The name of the template will be displayed on the configuration screen. Click Next.

5. Change the Merge tab box to the name of the tab containing the data.

6. Using the drop-down boxes on the right of the configuration screen, match the merge tags to the column headings in your spreadsheet. An example is shown below.

7. When all the tags and columns are matched, click Next.

8. Enter the name you want to give to the PDF files that are generated. This can be a combination of regular text and column headings from your spreadsheet. An example is shown below.

Note: The column headings must be encased in tags << >> and be written exactly as they appear in the spreadsheet (not in the Google Doc).

9. Change the Type box to PDF. Choose if you want to put each letter in an individual document (multiple output mode) or together in a single document (single output mode). Click Next.

Note: In this scenario, the PDFs are going to be emailed to recipients. As such, individual documents are the most appropriate choice.

10. Click the +Choose folder button and search for the Google Drive folder you want to store the generated PDFs in. Click on it then click Select. Click Next.

11. Click Next to skip the dynamic folder reference screen.

Note: For future reference, this setting can be used to put merged documents in different folders, e.g. by location, department, course, person etc.

12. Click Next to skip the merge condition screen.

Note: For future reference, this setting can be used to perform a document merge only on specific rows in the spreadsheet, e.g. those after a certain date.

13. Change the ‘Share doc?’ setting to Yes.

14. Ensure the the ‘Share doc as’ setting is set to PDF.

Note: For future reference, you can also choose to output files as Google Docs. You can then share these via Google Drive.

15. Scroll down until you see the email template box. Use this box to compose the email you want to send to the recipients along with the PDF file.

In the To field, use the name of column heading in your spreadsheet that contains the respondent’s email address, encased in tags << >>.

  • Enter information in the CC, BCC or Reply to field, if required.
  • The subject and the body of the email can also contain column headings from your spreadsheet. Again, they must be encased in tags << >>. 

Note: Any column headings be written exactly as they appear in the spreadsheet (not in the Google Doc). An example is shown below.

16. When you have finished composing your email, click Next.

17. Leave the options on the Add/remove job triggers screen set to ‘No’ and click Next. 

Note: For future reference, you can use the form trigger to configure autoCrat to run every time someone submits a Google Form (e.g. to automatically send them a registration confirmation or similar). The time trigger can be used to force autoCrat to run at a regular time interval.

18. Click Save

The autoCrat configuration is now complete.

Step 4: Preview the merge

After you have saved the autoCrat configuration, you will be taken to the Existing jobs screen. From here, you can run, edit, preview and delete your merge job. It’s a good idea to preview your merge before running it. This gives you a chance to identify and correct any errors before the real merge takes place.

Click the Preview button to test your merge.

Note: This will not actually run the entire merge. It will show you a summary of what will be merged and let you preview the first merged letter and email.

Step 5: Run the merge

1. Click the Run button to start the merge.

2. The merge will begin and a progress screen will be displayed.

3. When the merge is complete, close the autoCrat window.

4. You will notice that autoCrat has added some additional columns to your spreadsheet to record the results of the merge.

The merge Doc URL contains the link to the PDF that was generated.
The Document Merge Status field will show the status of the merge for each row in the spreadsheet, including the status of the email sending.

You will also find all the sent emails in your Sent Mail label in Gmail and the PDF files in the Google Drive folder you specified in during configuration.

Note: If you want to re-use your spreadsheet for another merge, you must first delete the information that autoCrat puts in the extra columns.

Want to learn more about using autoCrat to perform merges?

Check out the autoCrat website and user guide.

Does your organisation need assistance with automating processes using Google Drive? 

Contact us to discuss our customised consultation and training services.

Related Post

The right ways to enable AI at work – Tips for IT Lead

In today’s fast-paced workplace, maximizing efficiency while minimizing time spent on repetitive tasks is crucial. However, many staff members may feel unsure about integrating AI effectively, leading to missed productivity opportunities. As the IT lead, you can guide your team in harnessing AI’s power to streamline operations and save time. By providing clear guidance and

VIEW POST

How well do you use the
Apple Apps Google Workspace Microsoft 365
tools in your workplace?

Find out if you’re working with the tools OR if you’ve got the
tools working for you.

What Industry Are You In?

Using Apple Apps, Google Workspace or Microsoft 365?

What Type of user are you?

🫣 Entry User | 🤹 Skilled User | 👑 Elite User

Take the quiz to find out. 

Privacy Policy

Using Technology Better Privacy Commitment

Introduction

We hold the privacy of your personal information in the highest regard.

Using Technology Better regards customer privacy as an important part of our relationship with our customers. The following privacy policy applies to all Using Technology Better users, and conforms to Internet privacy standards.

This policy will be continuously assessed against new technologies, business practices and our customers’ needs.

If you have questions or concerns regarding this statement, you should first contact the support team on our Contact Us Page.

Collection of Information

In order to use the Using Technology Better website, we may require information from you in order to provide the best service possible.

All correspondence may also be collected and stored, particularly in regard to sales, support and accounts, including Email.

Any information collected by Using Technology Better is collected via correspondence from you or your company. This may be via the telephone, Email, mail, fax or directly through our website.

Visitors and customers of japan.usingtechnologybetter.com will have their information shared back to DAIWABO INFORMATION SYSTEM CO., LTD. and DIS Service & Solution Co., Ltd.

Use of Collection Information

Any details collected from Using Technology Better customers is required in order to provide you with our

products and/or services, and a high level of customer service.

Correspondence is recorded in order to provide service references, and to assist in our staff development.

Web Site Use Information

Similar to other commercial Web sites, our Web sites utilize a standard technology called “cookies” (see explanation below, “What Are Cookies?”) and web server log files to collect information about how our Web site is used.

Information gathered through cookies and Web server logs may include the date and time of visits, the pages viewed, time spent at our Web site, and the Web sites visited just before and just after our Web site.

Storage of Collected Information

The security of your personal information is important to us. When you enter sensitive information (such as credit card numbers) on our website, we encrypt that information using secure socket layer technology (SSL).

When Credit Card details are collected, we simply pass them on in order to be processed as required. We never permanently store complete Credit Card details.

We follow generally accepted industry standards to protect the personal information submitted to us, both during transmission and once we receive it.

If you have any questions about security on our Website, you can email us at <ContactEmail>.

Access to Collected Information

If your personally identifiable information changes, or if you no longer desire our service, you may correct, update, delete or deactivate it by emailing us at <ContactEmail>.

Orders

If you purchase a product or service from us, we may request certain personally identifiable information from you.

You may be required to provide contact information such as:

Name

Email

Postal address

Your school or organisation

Financial information (such as credit card number, expiration date, name on card, card billing address).

We use this information for billing purposes and to fill your orders. If we have trouble processing an order, we will use this information to contact you.

Communications

Using Technology Better uses personally identifiable information for essential communications, such as

Emails

Accounts information

Critical service details.

We may also use this information for other purposes, including some promotional Emails.

If at any time a customer wishes not to receive such correspondence, they can request to be removed from any mailing lists by contacting support.

You will be notified when your personal information is collected by any third party that is not our agent/service provider, so you can make an informed choice as to whether or not to share your information with that party.

Third Parties

Using Technology Better may at its discretion use other third parties to provide essential services on our site or for our business processes.

We may share your details as necessary for the third party to provide that service.

These third parties are prohibited from using your personally identifiable information for any other purpose.

Using Technology Better does not share any information with third parties for any unknown or unrelated uses.

What Are Cookies?

A cookie is a very small text document, which often includes an anonymous unique identifier. When you visit a Web site, that site’s computer asks your computer for permission to store this file in a part of your hard drive specifically designated for cookies.

Each Web site can send its own cookie to your browser if your browser’s preferences allow it, but (to protect your privacy) your browser only permits a Web site to access the cookies it has already sent to you, not the cookies sent to you by other sites.

Browsers are usually set to accept cookies. However, if you would prefer not to receive cookies, you may alter the configuration of your browser to refuse cookies.

If you choose to have your browser refuse cookies, it is possible that some areas of our site will not function as effectively when viewed by the users.

A cookie cannot retrieve any other data from your hard drive or pass on computer viruses.

How Do We Use Information We Collect from Cookies?

As you visit and browse our Web site, the site uses cookies to differentiate you from other users. In some cases, we also use cookies to prevent you from having to log in more than is necessary for security.

Cookies, in conjunction with our Web server’s log files, allow us to calculate the aggregate number of people visiting our Web site and which parts of the site are most popular. This helps us gather feedback to constantly improve our Web site and better serve our clients.

Cookies do not allow us to gather any personal information about you and we do not intentionally store any personal information that your browser provided to us in your cookies.

Legal

We reserve the right to disclose your personally identifiable information as required by law and when we believe that disclosure is necessary to protect our rights and/or comply with a judicial proceeding, court order, or legal process served on our Website.

Links

Links on the Using Technology Better site to external entities are not covered within this policy. The terms and conditions set out in this privacy statement only cover the domain name of usingtechnologybetter.com

Changes to Privacy Policy

If we decide to change our privacy policy, we will post those changes to this privacy statement, and other places we deem appropriate so that you are aware of what information we collect, how we use it, and under what circumstances, if any, we disclose it.

We reserve the right to modify this privacy statement at any time, so please review it periodically. If we make material changes to this policy, we will not use the personal information you have submitted to us under this Privacy Policy in a manner that is materially inconsistent with this Privacy Policy, without your prior consent

Delivery Policy

Most goods are digitally delivered instantly via email.  Our services may be delivered either via an online medium or live in person.

For our online delivery see below.  For services delivered live onsite, please refer to our speaker agreement form which is emailed to you on confirmation of booking.

Refund Policy

We do not offer refunds or returns unless we cannot supply goods or services or the goods or services are not delivered as promised.

Australian law is the governing body for all work, goods and services supplied by Using Technology Better.

Marketing Release

Using Technology Better (UTB) may film, record, and photograph me (the results of which are the “Recordings”). UTB may also incorporate into any production(s) any separate content (e.g., quotes, testimonials, biographical information, profiles, photos, videos, sound recordings, artwork, etc.) I provide to UTB or approve in writing (“Materials”).

1.License

I grant to UTB an irrevocable, perpetual, worldwide, royalty-free license to, in its sole discretion, (i) edit, translate, and modify the Recordings and the Materials, (ii) attribute the Recordings and Materials to me by my name, age, and city and state of residence, (iii) incorporate the Recordings and the Materials into content to promote UTB, its programs, or products (“Content”), and (iv) publicly use, distribute, reproduce, create derivative works from, and perform/display the Content, and any excerpts thereof, in any language.

2. No Compensation.

I grant this permission without any financial or other obligation of any nature.

 

For any issues or concerns please contact us