Collate Tag Certificate Gratis

hi I'm Richard Bern in this video I'm going to show you how you can use Google slides and Google sheets to create a certificate and then customize it for a list of students all at once let's go ahead and get started here in Google slides will use the certificate template and I'll just customize it quickly I'm going to call this one our certificate for perfect attendance so let's call it perfect attendance and now I'll change it I'll say that this certifies you achieved perfect attendance now I want to change this part that says student name I'm going to use some conditional tags I'm going to say first name and why I use those tags and just first name will be shown in the next part of this video I can change out the rest of this and say keep up the great work and I'll put in my school name and I'll change out this part and we'll put it in for so my certificates all set up I have my my certificate as I like it I named it the exact same name that I would want to use if I was going to give it out the kids I was going to email the kids it's the perfect attendance certificate so now I can close that out now going into a spreadsheet that I've called the same thing perfect attendance certificate and I have a list of student first names who have achieved perfect attendance now we're going to use an add-on for a Google sheets called autocrat let's go ahead and we're going to open that we're going to run it and make sure my account is approved or connected I should say go find it allowed to run and now we're going to set up the process so that we have certificates available with the students names on them so we're going to create a new job we'll call it perfect attendance now let's pick a template and we're gonna pick it from Google Drive thanks going to be my perfect attendance certificate which is right there and you'll see it said they're fetching tags from template those tags are the things we put in between the things that are listed as first name between those brackets so now let's go ahead and click Next and we're going to use sheet 1 which matches up to this and we're going to have first name that map's to first name there's header Row 1 first data is in Row 2 ok so it's all matched up just click Next ok and just gonna say completed perfect attendance as the file name let me Google slides and we're gonna have multiple output let's click Next I want to put it in my drive so I'm gonna have it go into my drive within a folder in my drive otherwise it will just fill up as a random things in there and so I'll put it into one of my many many folders that I have in here let's just put it into my test folder many test folders let's go in here and put it into my test folder and click Next I'm not going to share it and send emails because I don't have any emails listed in my spreadsheet and I don't want to share the template with students I want to be able to have copies that I can print out and so we've now saved our perfect attendance job and in the next...