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
Link to buy from Amazon: amzn.to/33ueeBL
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
Link to buy from Amazon: 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: amzn.to/2XELNgD
Other Useful links:
Xournal++ link: github.com/xournalpp/xournalp...
Xournal ( 32bit) : sourceforge.net/projects/xour...
Professor Luc Boisvert's cursor highlighter tool:
sites.google.com/site/boisver...
AutoHotKey: Free, open source scripting tool needed for mouse pointer halo:
www.autohotkey.com
Flashback Express Free version: drive.google.com/file/d/1kCWj...
Epic Pen: epic-pen.com/
My TH-cam Channel: / bsurendranathreddysrtmun
Our Videos:
1. Google forms : • Creating a google form...
2. Google form quiz: • Creating online exam u...
3. Microsoft Forms: • Microsoft forms for su...
4. Google Forms Vs Microsoft Forms: • Microsoft Forms Vs Goo...
5. Testmoz: • Online exam through Te...
6. Google classroom: • Creating Google Classroom
7. Edmodo : • Edmodo learning Manage...
8. OBS for online lecture and live streaming: • Record online lecture,...
9. Zoom and Google Meet: • How to use Zoom and Go...
10. AutoCrat for Certificate generation: • Generate Certificate a...
11. Libreoffice Mail Merge for Certificates: • Libreoffice -Mail Merg...
12. Certifyem for Certification generation: • Certifyem to generate ...
13. Design and send your own certificate using Certify’em: • How to generate custom...
14. Question and Answers on Google, Microsoft Forms, Testmoz: • Question and Answer se...
15. Question and Answers on Google Classroom and Edmodo: • Question and Answer se...
16. Question and Answers on OBS, Zoom, Google Meet: • Question and Answer se...
17. Question and Answers on Autocrat and Mail Merge: • Question and Answer se...
18. Valedictory program: • Valedictory Program- T...
19. Inaugural Program: • Inaugural session Peda...
20. OBS in Hindi : • Free Software for Onli...
21. Google Forms for Administration : • Google Forms for Admin...
22. Google forms for Administration in Marathi: • Google Forms for Admin...
23. Google forms and Classroom: • Google forms and Class...
Presentation links:
1. Microsoft forms: drive.google.com/file/d/1rVqz...
2. Google forms: drive.google.com/file/d/11iGq...
3. Google forms Quiz drive.google.com/file/d/1xdrB...
4. Testmoz : drive.google.com/file/d/1rhyp...
5. Google Classroom: drive.google.com/file/d/1hv70...
6. Edmodo LMS: drive.google.com/file/d/1zyWe...
7. OBS Studio: drive.google.com/file/d/1aWff...
8. Certify’em: drive.google.com/file/d/1JTZG...
9. AutoCrat: drive.google.com/file/d/1TfQ1...
10. Mail Merge: drive.google.com/file/d/1KmXN...
FAQs
11. Google forms FAQ: drive.google.com/file/d/1vFfz...
12. Google Classroom
drive.google.com/file/d/1nerS...
13. Edmodo: drive.google.com/file/d/1S5mP...
14. Testmoz: drive.google.com/file/d/1T8pd...
15. Certifyem : drive.google.com/file/d/1jQwy...

[@ilinez23]

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!!

[@madhuriwalvekar6584]

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

[@vijispathshala6595]

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

[@paulsolomon215]

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

[@jatinderkaur9148]

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.

[@BSReddy.Tech4Trends]

Happy to receive such comments. Where are you from professor?

[@BibethSharma]

@@BSReddy.Tech4Trends Sikkim Manipal Institute of Technology, Sikkim

[@namanjoshi8476]

​@@BibethSharmaSir, is Manipal University good for MBA.
Please suggest.

[@judieregina9808]

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

[@ubadtmar7835]

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

[@honeykalyani]

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

[@BSReddy.Tech4Trends]

Thank you, please share with your contacts.

[@sulochanaravisankar1353]

Thank You sir for your Clear Explanation.

[@sachinburde9705]

This session is very informative

[@enlightenment7308]

nice lecture
now it is very convenient for me thanks sir
Dr.Anita

[@harvyshah1430]

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

[@jeminajudiya256]

Thank you sir

[@sozurb]

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

[@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.

[@ashvinisrecipe8865]

This is most useful video. Teach in very simple method. Thank you.

[@ashvinisrecipe8865]

Sir I have a problem. One Certificate comes in many times. What is the problem.

[@mrs.bhavanakasarpatole4959]

Truly appreciate it!

[@rajeevbr7860]

Wonderfull explanation Thank you sir

[@lakshmimohan9966]

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

[@BaljinderSingh-ou8ei]

Very Informative and useful session

[@keentolearn2564]

Thank you sir for the informative session

[@leelahawle4890]

Very nicely conducted session by you sir

[@kirandiwate4432]

Very valuable, Thank you sir.

[@munirajappann7799]

Informative session and very interesting tool thank u sir

[@govindkumar-qq5tn]

Excellent session thanks

[@evesgalaxy6867]

Good morning Everyone..Very informative session
Reddy
Sir
..I am Ashima Varghese Asst.Prof

[@jatinderkaur9148]

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

[@AshishKumar-qe4hq]

th-cam.com/video/KGOPMzERvTk/w-d-xo.html

[@kshamasagarsahu3472]

Nice session sir.. Very much informative

[@jeevanteachingasst.profess1351]

Thank you Sir. Nice explanation

[@deptofenglishshivajiuniver2920]

thank you, for this tutorial it's very useful

[@nafeesasubramaniyan5550]

Thankyou for your informative session sir

[@yamalgupta3949]

Thanks so much ...really very helpful videos....

[@saradaw6180]

very informative and useful session

[@dr.jatindersingh6761]

Informative presentation Sir

[@a84403]

Well explained sir, Thank you,,

[@foodsafesafefood4802]

Thanks brother highly useful🏋‍♂

[@rajkumarkhilare6651]

Thank you for nice presentation

[@divakarchinnaswamy4292]

very clearly explained sir

[@sreerajbhasuran2036]

Very useful
Thank you sir

[@noopursrivastava4047]

thank u very much for nicely explained

[@santhoshk2226]

Thanks for the video sir. Helped me a lot!

[@BSReddy.Tech4Trends]

You are welcome

[@madegowdamkallimeledoddi5335]

Very interesting and useful information

[@aparnachaturvedi4581]

Very nicely explained

[@ranisdharan9930]

very good explanations

[@vijaya244]

thank you for the tutorial. it help me lot

[@ekanathkhandukore6209]

Appreciable session

[@rahultivarekar6768]

very useful video. Thank you.

[@sharvarisawant]

Thanku so much for this video 🙏🏻

[@deepaoommen4864]

Thank you sir... it was very helpful

[@ayishanecholi1353]

Thank you so much sir. It was of great help🌠

[@parimalabasappa3726]

Excellent sir it is very useful application

[@pragatitathe1067]

thank you sir really nice video

[@ABDULSATTAR-db8rl]

Informative session sir

[@ahmadthaifurkhaizul6139]

thanks sir. you help me alot.

[@vhapniphysics]

Thank you

[@alangbarswargiary1922]

Yes sir, it is helpful for us.

[@manojbabar1453]

Thank you so much Sir..

[@dr.mubeennazeersgoodluckac80]

Informative session

[@esotericarchitecture7788]

This is wonderful.

[@rukmini3769]

Every second of vedio is help full me how to create certificate ,sir will you please share vedio how to design custom certificate tq

[@prashantkamble5460]

Very useful video

[@dr.i.m.shaikh7181]

Very nice and interesting

[@vinoom8930]

Very useful sir

[@princesebastian9508]

informative ...good one

[@zachariah76]

Your description about generating E-Certificate was clear, could you explain how to edit the generated certificate and send back

[@AshishKumar-qe4hq]

th-cam.com/video/KGOPMzERvTk/w-d-xo.html

[@vikramarne]

Yes, Sir Autocrat seems more friendly than certify'm.

[@artcreation5722]

Very simple language explain , useful video
Sir plz Make detail Video Certificate ID add ??

[@omjoshi111]

Thanku so much Sir.....

[@vilassonawane7627]

Nice presentation

[@DrMohanMuthal]

THANK YOU SIR JI

[@piaralal2397]

Excellent sir

[@ranjittaku6605]

Very interesting sir

[@amitamishra8888]

Good information

[@shivaclasses1683]

Thank u sir

[@drpiyaliarora6300]

Can we preview the certificate prior to sending them through email.

[@arunagopinath7617]

Thank you sir

[@BSReddy.Tech4Trends]

Please share my channel with your contacts.

[@dr.sanjaysangale9135]

thanking You

[@hanumantjagatap3851]

Really great

[@suryakantborul6431]

thanks sir

[@madhurimpatil]

Madhuri Patil from MIT ,Aurangabad autocrat not launching but open option is observed.

[@chansokmeng2965]

Thank you for sharing this sir. I was wondering, is it possible to do this using Microsoft Form?

[@GhulamNabiDar]

beautiful sit

[@enusambyal4965]

Thank you so much sir for such an informative video
I have one query that how we can add a digital signature (Signature of Organiser and Principal )on e-certificate

[@BSReddy.Tech4Trends]

We can insert signature as an image on the certificate design or open certificate design in paint and sign using pen tool.

[@sourabhmuktibodh6201]

Nice Sir

[@Alisha-gp9qk]

Sr is session me aap kis trha se crtfct bannaya jaata hao wo sikha rahe ho kya autocrate k zrye se??

[@harispidecreation]

Sir first certificate forgot to add in spread sheet now participants are answered & entered what to do sir?

[@pradeepparichha8111]

Good evening sir 🙏
Thanks for the video. Please add a video how to make the name of the particular respondent appear automatically in confirmation message that we receive after submitting the Google forms.
Thanks.
Pradeep Parichha

[@pradeepthorat1911]

Sir if I want to change collected data location... what should I do??

[@sanjaypatil5703]

Good morning sir

[@maskfittesting930]

Hi, thank you so much for the tutorial. I have followed the instructions -but participants are not getting emails. I am missing a step but i just cant figure out where?

[@BSReddy.Tech4Trends]

Please go though the video once again, still if you are not getting proper, then You send me screenshot of each step to my WhatsApp number 9096077789.

[@uniformedtrave9109]

Nice

[@jeevanteachingasst.profess1351]

What about signing of certificate issuing authorities?

[@rachelevangelista4720]

Is there a way to format the date from 8/21/2021 to August 21, 2021. I used the date picker and upon submitting the form, what was recorded is in this format 8/21/2021. How can I set or format the date?

[@hanumantjagatap3851]

Whether it is posiable to add addon on mobile

[@soniyausgaonkar7636]

nice

[@facultyofmanagement8960]

Sir I reached the limit for sending certificate via Autocrat how can i resend rest all generated certificate

[@sohupk]

Whenever I want to use Autocrat addon in google sheets, I want to see my official business email sent to client but each time I am seeing my gmail email sent. How can I change it to my official email. I want to send emails to clients from my official email and not from gmail. Please advise.

[@pradiptekade1447]

Dr Pradip V Tekade, Associate Professor, Department of chemistry, Bajaj College of Science, Wardha (Maharashtra)

[@bhargavidevarakonda4209]

Sir, Did you teach a functional analysis course? I like your complex analysis course.

[@BSReddy.Tech4Trends]

I taught functional analysis, but doesn't have video lectures. I have my lecture notes, if you want i can share.

[@ybccpaiic9520]

nice video with good explanation. sir i have one query if i m conducting a webinar after 3 days then can i set time to send certificates after my webinar?
is there any option in autocrat?

[@BSReddy.Tech4Trends]

Yes, you can run time trigger on instead of form trigger.