![]() 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. |