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

Mail merge with google docs