How to Generate Certificate automatically from google sheet for webinar/conference/seminar
HTML-код
- Опубликовано: 5 сен 2024
- * Sorry for poor quality video. I am uploading the same video in good quality. please watch this on following link: • How to send Certificat...
How to make google form : • How to create google f...
How to Send Certificate Via Google Form automatically: • How to Send Certificat...
Add Score of Quiz into Certificate generated by Google form:
• How to Add Score of Qu...
How is it possible that a person can give instructions so completely and clearly without any hesitation or breaks? This is amazing.
One of the most in-depth & complete video on this topic. I had seen many videos but you went extreme & have helped me a lot.
Lalchand Patle Sir its a very nice tutorial video , at a single instance I successfully created all the things. First time I like any video in you tube , subscribed it, and finally commented also . Great Sir !! Thanks Again.
Sir aap ke pair kaha hai aap ne mera kaam kitna aasan kr diya h ye pucho hi mat maine video like kiya h share kiya h aur subscribe bhi kiya h
Thanku so much
Thnk u sir Apke guidelines se maine bhi Sikh gayi 🙏
Thank u very much
This video is very deeply and ur explanation is very friendly
Dis z what everybody needs
Thanks
A Filipina here, commending your tutorial video! Thank you!!!
itna easy aur badiya video bahut mushkil se mila hai, thanks very much, but video quality is very poor.
but very helpful
I think that you are the best No 1 you tuber...
Your video is totally completed and very helpful.
love you...keep it up💟💟💟
Jazakullah...was very informative
Thank you brother by following you I have made bulk of certificate..
Nice information sir, but throgh the autocrt at a time not received more than 100 certificates to the participants
for that you have to get G-suit subscription.
Complete knowledge... thank you sir
Thank you very much sir for this spectacular session. You taught me everything in one single video which could have taking double the time If I has preferred any other video. Love from BILASPUR CHHATTISGARH INDIA ❤️🤗
Glad to here that.
powerful information
Very nice.👌
Explained in very easy way.
Best on the topic I have seen in last 3 days.
Very helpful...thanks
Can I add entries directly to the sheet instead of asking people to fill the form if i already have the data but just need the certificates?
Yes, you can do it.
First, thanks for the video....
Ek choti si chiz aur bata dijiye please...ki certificate me automatically photos add ho jaye, kya aisa tag k jariye kiya ja sakta hai ...🙏🏼
Yes we can. I will try to make video on it.
@@sikhnasikhana4903 thank you sir....🙂
Very Important tips for creating certificates. Thanks
Good one. Helped me in designing my certificates for College Webinar
It's a very nice information.
Very useful video sir Thanku
Thank you so much. It is very helpful.
Nice presentation.... I'm from Kerala, hav limited knowledge in Hindi , but could follow your work
Thank you very much. This video helped us alot to certify our webinar participants.
It's my request to you to make an another video on "How to resend the generated certificates after exceeding 100 certificate per day"
Because we had more 500 participants in our webinar but we are able to send 100 only. Remaining participants are waiting to receive their certificate.
So please help us.
Thank you
Thanks for your appreciation.
One solution for your problem is: You can make five separate sheets of 100 participants, and run autocrat on each sheet separately from five different Gmail accounts or you can send one sheet (100 certificates) per day by running autocrat on each sheet daily.
@@sikhnasikhana4903 thank you so much
One of the best video for certification creation. Thank you sir
Very much easy to understand... Thanks for your great video...🙏🙏🙏🙏🙏
detailed explanation in easy method thank u so much sir
Thank you so much sir very clear explanation
Patle Sir very good
Sir!thanku बहुत ही बढ़िया वीडियो है पर ये बतायें certificate पर sign कैसे copy करें?
Please watch this video, here I have explained it:
ruclips.net/video/6kQDjyM1YDA/видео.html
Clear presentation
nice very useful sir
Thank you so much for this information. very nice tutoring by you.
#TechExpertSatish
बहुत अच्छा लगा वीडियो देखके।
एक सवाल है?
क्या Certificate id को change किया जा सकता है ?
हमे certificate id (SMMC/SANS/WEB/S/001) ऐसे करके बनाना है।
यदि संभव है तो कृपया बताए।।
Once certificates have generated, we can not change it.
If you want to give certificate numbers then you can give it in spread sheet as you want.
@@sikhnasikhana4903 धन्यवाद महोदय
Very detailed and simple explanation....really helpful. Thank you.
सर्वोत्तम जानकारी।
Lots of thanks for providing this great idea. May God bless you!
It is really great Session and Video.
Thank you so much....this is a very informative video.
Brilliant brother, I m so grateful to you.thanks.
Mast sir
very informative and helpful video
Thqnk q sir it helps me to conduct a webinar and give them certificate
Very Nice, Thanks
Om Sai Ram
Autocrat Add-on me certify'em Add-on se jyada settings hain.
Aur kitne Add-ons hain?
Thanku so much this was really very useful and the explanation is detailed nd so good...
Thank you sir for a this special knowledge
This is really useful video ever.
THANKS A LOT.. THIS VIDEO IS VERY USEFUL
Sir
Is it there any tag available in autocrat
By which unique certificate number is also generated
Please help me
Yes, you can add a unique ID to each certificate by adding a column in sheet and mapping that tag with autocrat.
@@sikhnasikhana4903 is there any other way of doing it so
@@himanshudixit1507 Yes, You can get G-Suit subscription and can send 1500 certificates per day via email.
Really Very Good Video... Thank you so much
Very useful video
The video was very useful and working perfectly . But when i used trigger automatically, the automatic generation happened only for the first 140 certificates and the rest 350 certificates were merged and linked but never reached the recipient destination. Kindly share your view in this regards.
We're sorry to report that something went wrong when attempting to process your certification. The owner of your certification exam (mail I'd ) has also been notified of the issue. Please note the error
Sorry for the late reply. Have you resolved the problem? If not please check your autocrat setting, maybe something wrong in it.
Thank you very much. This video is very helpful 👍. Thank u thanks a lot sir.
thank you valueable and creative information ...
Good one.. Thanks
Excellent, Brilliant, Awesome
Reply to...... You skipped it...except this total video outstanding
Thanks and keep doing the great work like this !!!!
Excellent video on the topic
Great! Sir, you have done really a great job.
Good job
Thanks alot.
Explained without confusion
excellent presentation
Very useful video. Well explained.
Glad you liked it
Thank you so much sir, highly appreciated your work.
Thanks a lot
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.
there is a problem in generating a certificate at the same time if many people fill the form then it give the same certificate to everyone by the 1st person's name.
very helpfull.
Superb Explanation
Very informative...plz upload in hd video next tym. atleast
Have you set quality to 720?
Sorry for poor quality video. I am uploading same video in good quality. please watch this: ruclips.net/video/e7O9_3b-XaQ/видео.html
सर आप एक क्लियर वाला वीडियो कॉलिंग दीजिए क्योंकि यह वीडियो बहुत ही यूज़फुल है और मेरे लिए तो एक बहुत ही यूज फुल।
kindly change your video keyword so that we can find easily it is very helpful and informative thank you for sharing knowledge
Thank you sir. Please tell me which key word you have entered? That keyword I will use.
@@sikhnasikhana4903 how to restrict the users in e certificate . Onmore how to issue certificate to registered email id
@@bharaths1171 Thank you sir..
@@sikhnasikhana4903 sir how many certificate can be issue in a day by this method
@@bharaths1171 By this method we can generate any number of certificates., The limitation is of only sending the emails. You can send 100 certificates via mail per day.
After adding autocrat and selecting file from drive , it is saying that "The API developer key is invalid".. so what should i do now?!
Wonderful bro really it's useful
Excellent. Thank you very much.
Thanku so much dis is very helpful
Java / .net coding section b aise he easy language and practical k saath samjhe
hello Sir .....thank you so much. Is it possible to print two or three result of tests in one sheet.
You're life saviour 💯🔥🙏🏻
Thanks man! This video helped me a lot!
Glad to hear.
Wonderful Bro🎉 Thank you🙏🏻
excellent
Informative video, really helpful
What in case of previously filled forms? How we can automatically send them the certificates?
You can make these Aucrat settings in any google sheets. Either Previously filled or newly filled, it works.
Highly appreciated you
This is great. Is there a way to include some fields from another Excel file if it matches a certain input? Eg: I ask a Subject on the form and if the subject matches Math, then I would like to add Math's stuff from another Excel file. Basically, match a field and display data from another Excel file. Thank you
Yes, It is possible to merge the google sheets entries. then make settings of Autocrat in the modified sheet.
What to do if the certificates are going to the folder in drive and not t the e-mail address specified in the tag ??
You have not checked the share certificate to given email.
Very well explained sir.. I have one some query... How to design a certificate with institution logo and signature in this method only
docs.google.com/forms/d/1evK0c_lWuTWMrnPJ4nj18FgHU3Nil9JEiVFXZguM400/edit
You can copy the logo image from your system and paste it into the certificate. For more detail please watch the following video:
ruclips.net/video/8M9N3HD4Q0A/видео.html
Weldone sir , thanks for video
But sir certificate per automatically certificate number kaise aayga
Ek se jyada sign kaise layenge
Please reply sir by a video
Congratulations....Very useful and clear video. I think it’s the best. I have subscribed.
After sending 100 certificates, by mistake I stopped Autocrat. How to restart it for sending rest of the certificates?? Please help...!
No problem. You can run the autocrat every day. But please don't do this. because it will send again the first 100 certificates.
So you should copy the entries after 101 onward and paste it into another sheet and then make open autocrat, make similar settings and then run it. Remember per day only 100 certificates will be sent via your Gmail account.
Since Autocrat has no limit to generating the certificates, only the limitation of sending the mails.
Sikhna Sikhana So quick response... thank you very much . You are really a good person. You deserve best👍
@@sikhnasikhana4903 hello,
When I was sending the certificate, process stopped (after sending 70 certificate) due to network issue, when I am trying Run again then there is no responce. What should I do.....
nice info sir,how can it run automatic afer submitting G Form?.run command has been given time to time
This vedio is very helpful. Can you give idea about how to record zoom meeting through az screen recorder
yes very soon.
very nice
Too gud sir
Thank u
1) How to add certificate no. ?
For example:- BSG/OD/001
BSG/OD/002
BSG/OD/003
2) What if i have 5 days of this ?
To add certificate number in it, you should add one column in sheet and assign the numbers to each entry then go to google slide--> add the tag , make sure that the string is same as in the sheet. Then go to Autocrat setting and add the same Tag .
Finally, run the autocrat to generate the certificate.
If it doesn't work then let me know.
I WANT 8 SHEETS IN MY GOOGLE SHEET TO BE VALIDATED TOGETHER. ONLY THOSE WHO ATTEND ALL THE 8 TESTS SHOULD GET THE CERTIFICATE. WHAT TO DO?
I am receiving error message by autocrat after selecting certificate from drive though I have typed everything manually in the certificate. How to solve the problem sir?
You have copy and pasted one of the tags in the certificate. Please select a separate text box for every tag.