Generate Certificate and send as pdf automatically using AutoCrat Add-on

In this video, we will demonstrate how to generate certificates automatically using AutoCrat Add-on for Google Sheets. We will discuss how to attach an Autocrat add-on for a Google form or for an existing Spreadsheet(excel).
0:00 Introduction
0:50 Create a sample Google Form
2:34 Install AutoCrat addon
3:34 Launch AutoCrat
4:53 Create template from Google Slides
9:35 Mapping source data to template
12:38 Share docs and send mails
13:53 Run triggers
14:27 Activate Autocrat
15:18 Generate sample certificate

Suggested Pen Tablets:
1. WACOM One by CTL-672/K0-CX Medium 8.5-inch x 5.3-inch Graphic Tablet
Price varies between Rs.6800-8000
Trusted brand but little costly.
2. XP-Pen Star G960 Graphic Tablet (8.35X5.33 inch) for ~Rs. 4000-45000
Budget price with good reviews
3. Huion Inspiroy H640P (6.3 x 3.9 inch)
Smaller size with price range: Rs 4300 to 4500

Other Useful links:
Professor Luc Boisvert's cursor highlighter tool:
AutoHotKey: Free, open source scripting tool needed for mouse pointer halo:
Our Videos:

Presentation links:

FAQs
12. Google Classroom

[ilinez]

Sir you are a genius!! I searched high and low using Microsoft word and pdf to make this automation happen, but the correct answer is in your video. Thank you so much for your tutorial, really appreciate your work!!

[madhuriwalvekar]

Very nicely explained sir. I did it simultaneously with your lecture. M so glad that I could generate a certificate myself. Thank you.

[vijispathshala]

Class on this topic is exactly what i wanted to know.
Thank u so much Sir

[jatinderkaur]

I am surely going to enjoy using LibreOffice and AutoCrat in future. Thank you very much Sir.

[BibethSharma]

I am a university professor myself and I must say that this video has made my day. I looked for many videos, but this was the most comprehensive one. Thank you sir for your kindness.

[paulsolomon]

Best demonstration for Autocrat on internet. thank you very much sir

[ubadtmar]

Thank you very much it has been very helpful. Your explanation is very clear and easy to understand.

[judieregina]

Perfectly explained...👍👍
Those trying to make it on mobile
can carry out things through Google Chrome(desktop site setting)

[honeykalyani]

Thank you for slow and clear explanation sir. It was very useful. I could easily generate certificate .

[pvrameshbabu]

Thank you. It is good video, explains all the features. I was able to make use of this video to generate certificates and share the same by email.

[sozurb]

Thank you for this tutorial!! It's very useful :D

[sulochanaravisankar]

Thank You sir for your Clear Explanation.

[harvyshah]

Thank you so much sir!! You saved my time & each step you taught very briefly 🙌🙌

[keentolearn]

Thank you sir for the informative session

[lakshmimohan]

Very nice explanation, it is very use ful, thank you sir

[jatinderkaur]

Thank you, SIr, it seems more convenient to use AutoCrat than Certify them.

[munirajappann]

Informative session and very interesting tool thank u sir

[leelahawle]

Very nicely conducted session by you sir

[deptofenglishshivajiuniver]

thank you, for this tutorial it's very useful

[kshamasagarsahu]

Nice session sir.. Very much informative