In this video, we will demonstrate how to generate certificates automatically using AutoCrat Addon for Google Sheets. We will discuss how to attach an Autocrat addon 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 CTL672/K0CX Medium 8.5inch x 5.3inch Graphic Tablet
Price varies between Rs.68008000
Link to buy from Amazon: https://amzn.to/33ueeBL
Trusted brand but little costly.
2. XPPen Star G960 Graphic Tablet (8.35X5.33 inch) for ~Rs. 400045000
Budget price with good reviews
Link to buy from Amazon: https://amzn.to/31tQHhB
3. Huion Inspiroy H640P (6.3 x 3.9 inch)
Smaller size with price range: Rs 4300 to 4500
Link to buy from Amazon: https://amzn.to/2XELNgD

Other Useful links:
Xournal++ link: https://github.com/xournalpp/xournalp...
Xournal ( 32bit) : https://sourceforge.net/projects/xour...
Professor Luc Boisvert's cursor highlighter tool:
https://sites.google.com/site/boisver...
AutoHotKey: Free, open source scripting tool needed for mouse pointer halo:
http://www.autohotkey.com
Flashback Express Free version: https://drive.google.com/file/d/1kCWj...
Epic Pen: https://epicpen.com/
My YouTube Channel:    / bsurendranathreddysrtmun  
Our Videos:

1. Google forms :   • Creating a google form and sharing  
2. Google form quiz:   • Creating online exam using Google forms  
3. Microsoft Forms:    • Microsoft forms for survey and online...  
4. Google Forms Vs Microsoft Forms:    • Microsoft Forms Vs Google Forms: My p...  
5. Testmoz:   • Online exam through Testmoz  
6. Google classroom:   • Creating Google Classroom  
7. Edmodo :   • Edmodo learning Management System  
8. OBS for online lecture and live streaming:    • Record online lecture, powerpoint pre...  
9. Zoom and Google Meet:    • How to use Zoom and Google Meet for o...  
10. AutoCrat for Certificate generation:    • Generate Certificate and send as pdf ...  
11. Libreoffice Mail Merge for Certificates:    • Libreoffice Mail Merge to send bulk ...  
12. Certifyem for Certification generation:    • Certifyem to generate certificate for...  
13. Design and send your own certificate using Certify’em:    • How to generate customised certificat...  
14. Question and Answers on Google, Microsoft Forms, Testmoz:    • Question and Answer session on Google...  
15. Question and Answers on Google Classroom and Edmodo:    • Question and Answer session on Google...  
16. Question and Answers on OBS, Zoom, Google Meet:    • Question and Answer session on OBS St...  
17. Question and Answers on Autocrat and Mail Merge:    • Question and Answer session on Libreo...  
18. Valedictory program:    • Valedictory Program Teachers Trainin...  
19. Inaugural Program:    • Inaugural session Pedagogical Trainin...  
20. OBS in Hindi :    • Free Software for Online Lecture Pres...  
21. Google Forms for Administration :   • Google Forms for Administration (Engl...  
22. Google forms for Administration in Marathi:    • Google Forms for Administration (Mara...  
23. Google forms and Classroom:    • Google forms and Classroom  
Presentation links:
1. Microsoft forms: https://drive.google.com/file/d/1rVqz...

2. Google forms: https://drive.google.com/file/d/11iGq...
3. Google forms Quiz https://drive.google.com/file/d/1xdrB...
4. Testmoz : https://drive.google.com/file/d/1rhyp...
5. Google Classroom: https://drive.google.com/file/d/1hv70...
6. Edmodo LMS: https://drive.google.com/file/d/1zyWe...
7. OBS Studio: https://drive.google.com/file/d/1aWff...
8. Certify’em: https://drive.google.com/file/d/1JTZG...
9. AutoCrat: https://drive.google.com/file/d/1TfQ1...
10. Mail Merge: https://drive.google.com/file/d/1KmXN...
FAQs
11. Google forms FAQ: https://drive.google.com/file/d/1vFfz...
12. Google Classroom
https://drive.google.com/file/d/1nerS...
13. Edmodo: https://drive.google.com/file/d/1S5mP...
14. Testmoz: https://drive.google.com/file/d/1T8pd...
15. Certifyem : https://drive.google.com/file/d/1jQwy...