How to automatically generate an electronic certificate from answering google forms?

Steps on ow to automatically generate an electronic certificate from answering google forms.
1st step : create a folder in google drive
2nd step: create a template for your E-certificate
3rd step: Put a tagging on your E-certificate template.
4th step: Create a Google form
5th step: Generate google sheet from the google forms
6th step: Automate your E- certificate using autocrat

[@anthonyogosu2508]

Amazing and Acknowledged that Professional Skilled Taught.Cheerfully Congrats you.

[@MaamMica]

Thank you 😊

[@norhannmenor4722]

Life savior. as a non techy office worker. i find it hard to cope up with technology advancement. thank you very much.

[@MaamMica]

You're welcome 🤗

[@MaamMica]

Thank you for your appreciation ❤️

[@amalsahajan2576]

Nice presentation. Explained each and every details clearly.

[@MaamMica]

Thank you so much for your appreciation ❤️

[@usmi5130]

Thanks for making this video, I was worried the whole day about how it would happen but I didn't think it would happen so easily. Thank you 🌺

[@MaamMica]

I am grateful that my tutorial helped you 😊❤️

[@MaamMica]

Thank you for your appreciation ❤️

[@CibusMission]

It took me forever to find a good video on this! Thank you! This was clear, easy to follow and got it done on the first try! Thanks again! Just subbed!

[@MaamMica]

Thank you for your appreciation ❤️😊🙏

[@curiousmusic101]

The best among all!

[@MaamMica]

Thank you so much for your appreciation ❤️😊

[@sultanemirdiaz1016]

Thanks, Ma’am! You’re a blessing!

[@MaamMica]

Thank you so much for your appreciation ❤️

[@johnrayberso6201]

Thank you so much, nagawa ko na po, very detailed

[@MaamMica]

Thank you so much for your appreciation 😊❤️

[@PeterAndreiRUBIS]

Thank you so much, Ma'am Mica! This video really helped me for my school organization! God Bless!

[@MaamMica]

You're welcome

[@MaamMica]

Thank you for your appreciation ❤️🙏☺️

[@saaondoterkuma4802]

Thank you for the comprehensive tutorial, you have done a great job

[@MaamMica]

Thank you for your appreciation ❤️🙏😌

[@MaamMica]

Thank you for your appreciation ❤️😊

[@UniqueFXAcademy]

Very clear and concise
Thanks for the video

[@MaamMica]

Thank you for your appreciation ❤️☺️🙏

[@filmsoleil5262]

thank you so much! very informative and useful for our events

[@MaamMica]

Thank you for your appreciation

[@rnh13]

Awesome! Very clear instructions. Thank you❤

[@MaamMica]

You're welcome. Thank you for your appreciation ❤️

[@navaneethan8327]

Thanks for making this video....
It is very useful for me.👍👍

[@MaamMica]

Your welcome

[@jenneferhernandez7336]

It is easy to follow! New learning po ito!

[@MaamMica]

Thank you po for your appreciation ❤️🙏

[@pipiaa2010]

thank you!..the tutorial is very clear...good work!

[@MaamMica]

Thank you for your appreciation ❤️😌

[@daniellasabas8576]

THANK YOU SO MUCH MA'AM FOR SHARING YOUR KNOWLEDGE ABOUT THIS! GOD BLESS

[@MaamMica]

You're welcome ❤️

[@MaamMica]

Thank you for your appreciation ❤️😊 God bless 🙏

[@DRPHAUP]

Thank you for this!

[@MaamMica]

You're welcome 😊

[@anne2900]

Thank u a lot! God bless you

[@MaamMica]

You're welcome ❤️

[@MaamMica]

Thank you so much for your appreciation ❤️

[@khushaggarwal4219]

such a grt video. deserve more views
thanks for making such a wonderful content

[@MaamMica]

Thank you for your appreciation ❤️😊🙏

[@Kaydyach.bola.]

Nice explaination

[@MaamMica]

Thank you 😊

[@Anti-LGBTQ-Squad]

Thanks for your help it means a lot!!

[@MaamMica]

Thank you so much for your appreciation ❤️

[@user-tk9gp2bd7s]

Thanks for making this video. It is really a very big help on my part..

[@MaamMica]

Thank you so much for your appreciation ❤️☺️

[@afrunnishabathusha7133]

Super awesome vedio

[@MaamMica]

Thank you so much for your appreciation

[@mcarlaux]

this is so helpful!

[@MaamMica]

Thank you ❤️😊

[@benitaflorence]

Thanks so much
Very useful & clear instruction

[@MaamMica]

You're welcome ❤️

[@MaamMica]

Thank you for your appreciation

[@roweltangalin6792]

Thankyou Mam! 100% working

[@MaamMica]

You're welcome ☺️

[@educacionportable]

Thank you very much usefull content

[@MaamMica]

You're welcome 😊

[@sanchitgangwani4741]

Thanks a lot !!! God bless you

[@MaamMica]

Thank you for your appreciation ❤️😊

[@HuntaKiller91]

Thx to u i get to this for our Fun Run

[@MaamMica]

I'm glad that my video helped you 😊 God blessed on your program ❤️

[@JennScheffer]

excellent tutorial!

[@MaamMica]

Thank you 😊❤️

[@gennemerroma3870]

thank you for everything. God bless

[@MaamMica]

You're welcome ❤️

[@MaamMica]

Thank you for your appreciation ❤️😊

[@user-cl8ul3op3u]

please create a vedio for full tutorails for me from basic to advance with How to automatically generate an electronic certificate from answering google forms? and also add how can create the google forms for exam paper.

[@MichaelMickeyWilliamsJr]

Thank you so much!!!

[@MaamMica]

Thank you for your appreciation ☺️

[@emilygrau2960]

Is there a way to embed the certificate in the email body instead of it being an attachment that they have to click on to open?

[@YourSarnaFamily]

great info shared in simplified manner. Thanks ma'am

[@MaamMica]

Thank you 😊

[@diannecaroldelacruz]

VERY HELPFUL

[@MaamMica]

Thank you for your appreciation ❤️

[@user-sx3ti8sr2b]

thank you .. made it so easy

[@MaamMica]

Thank you for your appreciation

[@hiroyukinumaguchi1984]

Thank you!

[@MaamMica]

You're welcome! ❤️❤️❤️

[@albouaini]

Really great. Very grateful. 🙏

[@MaamMica]

You're welcome 😁

[@MaamMica]

Thank you for your appreciation ❤️

[@ashokaactivity316]

Thank You So Much Ma'am Mica, this is very useful video to me.

[@MaamMica]

You're welcome ❤️😊

[@kaye958]

Thanks. Very useful

[@MaamMica]

Thank you for your appreciation ❤️

[@verenafrancoriveros8310]

Thanks a lot, you are life saver! A little question: Do you know how to format de body of the mail, because I didn't see the options, maybe we have to enable somewhere?

[@MaamMica]

Thank you. You can have general content for the mail. You just have to input it on autocrat

[@sabashadabrais]

Thanks it's helpfull

[@MaamMica]

Thank you for your appreciation ❤️🙏

[@abhishekmane6560]

Thank you mam really good

[@MaamMica]

Thank you for your appreciation ❤️

[@monikakhona1407]

Can you suggest any G-suite extension for Warranty card Certificate for customer with the help of google form

[@littlegirl-d5910]

God bless

[@MaamMica]

Thank you 😊

[@mishravijayalaxmi7638]

Hey I created but the certificates are being sent on my ID and not on College ID. Please suggest what can be done?I have made Google form on College ID but the certificates are getting sent through my ID.

[@sarahmahmudi3409]

Tqsmmmmm . So helping me . Tqtqtqqqq

[@MaamMica]

Thank you so much for your appreciation ❤️

[@jennifermangali5077]

Thank you Mam Mica

[@MaamMica]

Welcome po mam ☺️

[@wynterseason4013]

Thank you so much.

[@MaamMica]

You're welcome 😁

[@MaamMica]

Thank you for your appreciation ❤️

[@user-td4eg2nk4z]

Thank you so much mam

[@MaamMica]

You're welcome 🤗

[@yassinemouniane]

Thank you very much ❤❤

[@MaamMica]

You're welcome ❤️

[@MaamMica]

Thank you for your appreciation ❤️🙏😊

[@yassinemouniane5954]

Thank you very much

[@MaamMica]

You're welcome 🤗

[@MaamMica]

Thank you for your appreciation ❤️

[@alphane2300]

Thank you for your sharing, I would like to ask, if I needed to include series number into the e-certificate, how can I make it? Thank you.

[@MaamMica]

There should be an option into your forms or Excel file

[@abdullahalmamun8264]

thanks you so much

[@MaamMica]

Thank you for your appreciation 🙏

[@iqbalq86]

thank you

[@MaamMica]

Thank you for your appreciation ❤️☺️

[@linusluki9498]

Great video indeed. Can one automatically add a completion date and a certificate number on the certificates? My course is hosted in Go High Level and I can set a workflow to update the google form or sheet.

[@MaamMica]

Yes.. as long as it is in the Google forms and sheets

[@dkysrinivas-ri4de]

Very good explanation
If it possible without Google forms,
Can we use Google sheet for generate certificates to email unlimited

[@MaamMica]

Yes it is possible. You can skip the google forms if you already have the details needed for the certificate such as the name of the participants

[@albertocriccamonelli5411]

sorry for my English but I use an automatic translator from Italian. Is it possible to make sure that by adding new lines to the sheet the merged letters are generated only for the new names?

[@MaamMica]

I think you don't need to create new line for new participants. Those who will answer the forms will receive the certificate

[@juanpaolocunanan3172]

Hi!! Thank you so much.. this guide save my ass.. thanks!!!

[@MaamMica]

You're welcome ☺️ thank you for your appreciation ❤️

[@leekuanyuinkpm-guru5600]

Thank you very much. Is there any limit? How many cert can we generate?

[@MaamMica]

500 per day po

[@divyapoojari6442]

Is there any alternative to autocrat ?

[@iamZia]

Thanks. May I Know what laptop do you use?

[@MaamMica]

With 8gb ram

[@iamZia]

@@MaamMica Could you please tell me the brand name and model of your laptop?

[@retama2122]

Hey that was awesome what about if I need to send me a copy of the file ? and at the same time send them to the users that provided the email?

[@MaamMica]

The file send to each email will also be saved to your google drive

[@retama2122]

Thank u

[@MaamMica]

You're welcome 🤗

[@bhanusree6339]

How can we use tags to customize file names

[@abideasis5978]

Hi i just want to ask if there's a maximum limit for responses and e-certs?

[@MaamMica]

For personal email its 100 email per day

[@MaamMica]

But if you have Educational email it is 1,500 per day

[@agabarichard7492]

Am unabale to see autoCrat on my Pc when i try to follow the order

[@RoniYuliyanto]

Bagaimana cara membuat penomoran pada sertifikatnya?

[@shriramakrishna3624]

Very nice and thanks for sharing. One doubt for how many people get mail merge.

[@MaamMica]

Thank you so much for your appreciation

[@MaamMica]

1,500 per day for educational email

[@shriramakrishna3624]

@@MaamMica Thank you so much

[@MaamMica]

You're welcome 🤗

[@createveacademy4717]

Great Tutorial! I have a little issue, the certificate when opened on the PC, it works good, but once it is opened on phone, background design is missing. do you have any solution to that please?

[@MaamMica]

Make sure that you follow the format in certificate

[@createveacademy4717]

I fixed it, and if anybody needs the solution:
Instead of importing the background design as a content on the slide, import it as a background for the slide, and it will work fine. Thanks!

[@MaamMica]

Thank you for sharing your ideas or solution 🙂 💡

[@kumudthaaapmuniandymoe9546]

hi....at no 3, map source data to templet I cant see the (standard ......full name target map to name .....). please assist

[@MaamMica]

Just type this 👉

[@skyleow1585]

Hi! Can I put a portrait certificate in google slide to generate the E-certificate?
Or how can I generate a portrait certificate?
Thank you

[@MaamMica]

Hello you can generate a portrait by customizing the size of google slide. You can rewatch the video, it's there

[@skyleow1585]

@@MaamMica
Thank you

[@shashikalamanushani3964]

Will this work for a google sheet that is already filled with data?

[@MaamMica]

As long as you can provide the correct emails of the recipient

[@user-pi9gk5tm2v]

HELLO PO! ANY TIPS HOW TO FIX THE MERGE SHEET IN AUTOCRAT?

[@ilakkiathandaithabany3081]

How to include the tagging is it by typing?? Bcz i typed it's still not generating

[@MaamMica]

Type first

[@MaamMica]

After type select it on the side. Follow all the step by step

[@user-cl8ul3op3u]

please provide certifcate origial file for edit for me for My instittue

[@storyofnightowls]

Is there way to run autocract automatically without clicking the run button everytime

[@MaamMica]

Yes you have that option just choose the proper triger. Watch the last part of the video 😊

[@kirahkishaatad4912]

hello, is there a limitation ?

[@MaamMica]

No limitations

[@rnh13]

Hello, the certificate is accidentally sent to the person who shouldn't receive it. Is there any way to prevent them to have an acces to file? Please help!!

[@MaamMica]

You can limit the respondents of your google forms. If you have a company email address you can limit it to its domain.

[@rnh13]

@MaamMica Unfortunately it already sent through email

[@sunilfrancisp2523]

how many days it will work / unlimited days

[@MaamMica]

You will receive an email it is not responding anymore. Based on my experience it will take months before i received an email. And you just need to activate it again

[@arthurm9529]

The email keeps showing "invalid email", how can I correct this?

[@MaamMica]

You can double check all the email you're using

[@SakthivelVK]

How to insert image in the template....

[@MaamMica]

Just click insert then image or photo

[@agume1025]

how to fix that email could not sent?

[@MaamMica]

Make sure that emails are active

[@zvlabbleen6332]

Hi 👋 panu mo mglagay ng tagging yung my text box? 🙏 yun ang di ko nasundan

[@MaamMica]

Just this 👉 >

[@kleir473]

Why mine has no autocrat

[@MaamMica]

You can download it ☺️

[@EEBMohdWasiuddin]

What if we want to take more than 1 response from Google form

[@MaamMica]

You will just need to change the option and require respondents to type the email of the recipient of certificate. 1 e-mail = 1 cert

[@EEBMohdWasiuddin]

@@MaamMica No Mam, I want to know that how to take more than 1 input from Google form to certificate, for example I want to take Age of candidate in certificate apart from name, how to do that?

[@MaamMica]

Yes you can do that just follow the same procedure like how you did on names

[@Catfolks]

aand how do you automate to send the generated certificate to whatsapp number?

[@MaamMica]

I will find out if there's way

[@rosavisantos0513]

Paano po kapag madaming text tagging sa form mam?

[@MaamMica]

Same process lang po 😊 dapat naka include din po sya Google form para ma include sya sa google sheets

[@kutulloletageng1069]

Is that extension paid or free?

[@MaamMica]

It's for free

[@kutulloletageng1069]

@@MaamMica Thank you very much!

[@MaamMica]

You're welcome ❤️😊

[@dollyjanefregon1033]

Hi mam paano po ung tagging nong

[@MaamMica]

Just follow po the instructions in the video

[@PRINCEJOEFELCABANASSANTOS]

Bakit naman po nagshort cut sa creating a form huhu

[@MaamMica]

Because this video is not about creating a form

[@jayabad6558]

mam pano po kaya mag add ng QR code

[@MaamMica]

QR code po sa certificate?

[@bahemisadan3684]

paano ginawa ang tagging? 3:15 yung

[@MaamMica]

Just follow the next step po

[@muhaiminshukri1516]

Thank you so much for the sharing, really help me a lot

[@MaamMica]

You're welcome 😊

[@sssssssullll]

it didnt send to the email

[@MaamMica]

Don't forget the last step

[@sssssssullll]

@@MaamMica thnkyou

[@MaamMica]

You're welcome 🤗

[@Aeri1485_EXO]

why is it not working on my account :c

[@ArchOmarFaruk]

It no longer works when I go offline.

[@MaamMica]

It will automatically send the certificate even if you are offline if choose to automatically RUN THE JOB. Just make sure you SET IT PROPERLY.