![]() Traditionally, mail merge is used to create multiple versions of a document and snail-mail them to someone. If you have ever worked in LibreOffice or Microsoft Excel you will probably be familiar with the mail merge. Hope you found this tutorial helpful.Google Apps Script: SpreasheetApp, DocumentApp, DriveApp Google Sheets, Google Docs In this tutorial you learned how to create personalized student certificates by mail merging data from Google Sheets into a Google Slides template. I've said it before on this blog but learning Apps Script can be very rewarding since you can immediately apply the concepts you learn to automate your tasks. A process that might have taken two hours can now be completed in just a few minutes! ![]() The best part is that the script takes less than a minute to run. That is, the data from the spreadsheet was correctly merged with the certificate template in Slides to produce personalized certificates per student. When you open these certificates, you'll notice that the variables in the template were correctly replaced with each student's name and grade.Īs you can see, each student's certificate contains their name and grade. You'll also see these certificates (which are basically Google Slides presentations) in your Drive. When your script finishes running, you'll see links to the generated certificates populated in the fourth column of the sheet. To run your script, select the Create Slides menu item from the Admin custom menu. The final step is to run your script so you can confirm that it works correctly. Step 4 - Run your mail merge script to confirm that it works correctly I created a simple template that has three variables: The first step is to create a Google Slides template for the certificate. Step 3 - Create an Apps Script to mail merge information from Google Sheets to Google Slides Step 2 - Create a Google Sheets spreadsheet containing the grades of students in your class Step 1 - Create a Google Slides presentation template Triggers in Google Sheets (especially the onOpen() simple trigger).Ĭreate a copy of a Google Slides presentation using Apps ScriptĤ steps to create a Mail Merge from Google Sheets to Google Slides You may also find the following tutorial helpful: Iterating through rows in a Google Sheet using Apps Script.Ĭreating custom menus in Google Sheets using Apps Script. Reading from and writing to a range in Google Sheets using Apps Script. How to create and run simple Apps Script scripts using the script editor in Google Sheets? This tutorial assumes that you're familiar with: Your browser does not support HTML5 video. Instead of spending two hours creating these certificates for a class, you can be done in two minutes! Here is a video that shows what we'll be building in this tutorial. Our goal is to create 6 grade certificates, one per student, using the power of Apps Script. ![]() ![]() Each row in the spreadsheet will usually correspond to a separate "merged" email or document.Ĭonsider the following spreadsheet that has a header row and 6 rows containing data about student grades. The data from each row in the spreadsheet will be filled into these placeholders to create personalized documents. ![]() Typically, a mail merge application will involve a template that contains placeholders for content to be filled in. A quick summary is that a mail merge involves taking data from a spreadsheet to create personalized emails or documents. I've described what a mail merge is in detail in the following tutorial: Mail Merge in Google Sheets. Then with a few lines of Apps Script code you can create certificates for your entire class in under two minutes!! What is a Mail Merge? All you have to do is spend a few minutes entering the grades of your students into a spreadsheet (actually you probably already have a spreadsheet with this information). In this tutorial, I will show you how you can automate the process of creating these certificates by "mail merging" data from a Google Sheets spreadsheet into Google Slides. Given how busy you've been, it is Saturday and these certificates need to be ready by Monday morning! You groan because you're really not looking forward to spending 2 hours creating certificates for your class of 30 students! It is boring and repetitive work but you want to ensure that your students get their certificates on time. You've decided to use Google Slides to create these certificates and you plan to use the same design that you used last year. Let us say you're a teacher and you want to create a personalized grade certificate for each of your students. Mail Merge from Google Sheets to Google Slides ![]()
0 Comments
Leave a Reply. |