AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Quick spreadsheet merge8/3/2023 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
Read More
Leave a Reply. |