Hi, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day. You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :) docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Thank you so much Sir for this informative sharing. It really helps me in producing e-cert. Paperless. Share with us on how to produce surat jemputan pula. =)
@@mohdikhsanmdraus How to Auto Generate surat jemputan/lantikan with different Name, Position and ID of Employee ua-cam.com/video/zP1ZtcJhVSA/v-deo.html. I hope it helps. :)
Hi, yes, it can just auto generate the certificate using the spreadsheet alone with the Google slide (certificate design). Just remember the header "map column" must be match. There also have alternative option to use Microsoft word and Excel only. Here is the link. ua-cam.com/video/Kgj2CUZpKFg/v-deo.html Hope it helps.
@@LYSStuff hey humble101, i have try that and it works, thankyou so much, i just want to ask is there a way to put another document in the email we send for the certificate? Please 🙏🙏 i really need your help right now
Hello! I found this video very helpful! However, I encountered an issue where I’m not receiving any emails to get the e-certificate. I also saw the message: "Rows that will be merged: No rows will be merged. None meet merge criteria." Could you help me resolve this?
@@LYSStuff I have double checked the tagging-- There is no extra spacing. And upon checking the docu merge status I have found this Failed to add (email) as viewer: API call to drive.permissions.insert failed with error: Invalid permission value; !!Error Sending Emails: Invalid email: (email); Manually run by (email); do you think that I made a mistake along the procedure?
Yes, it can send to any email address. No limit to specific email address. Just need to make sure the email address is correct and without extra spacing at first or end of the email address. Usually that's happen cause the error.
Hi, thanks for the explanation 1- How can I run the web link directly after the submit form button? 2- How can I show the sender's mail in the form field without typing it? 3- How do I get a student to check-in and check-out only twice a day ? Thank you ....
Hi, 1. Sorry, I not sure what do you mean "I run the Web link" 2. I have no idea for that. I think it must type something on it. 3. This autocraft is just to generate E-certificates. Do not have function for check in and check out . :)
Hi thanks a lot. Is is possible we can generate google form without the need to fill in names but to generate a certificate with names after completion of feedback?
Yes, you can. You also can direct use your spreadsheet that already have all others people detail. Just remember the Column header must define in AutoCraft App. Hope it helps.:)
Hi, if u mean normal spreadsheet, just use it as usual spreadsheet. Copy and paste the list of attendance or details u have for each column. But if you mean "simple spreadsheet" app, then I have no idea for that.
For this method only support gmail. Because is using google sheet and google slide. However, there is another way by using Microsoft word->Merge Mail-> email to user. Using Microsoft word able to use non-gmail email address. You may refer to this ua-cam.com/video/Kgj2CUZpKFg/v-deo.html Hope it helps. :)
Hello, thank you for the video. However, I've encountered an issue: despite following the instructions, all certificates were sent to just one participant instead of the 100 intended recipients. I've explored various options, but my email, shows they all went to one person. I urgently need your support to resolve this issue. Thank you!
@@MuzhdaaaaaaHi, please check on the email tagging at the ppt, email column in spreadsheet.. Maybe the naming is not match. Else maybe is other participant email with extra spacing at the end.
@ thanks, I figured it out by making different sheets and dividing 100 people into smaller groups 🙌🥳 thank you sooooooooo much for the video, I was so anxious about it now I am all free
Hi, this autocrat support both regular and G-suite account. Just for standard account, limit Email Sent 100/day and Document Creation 250 / day. You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :) docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Hye, thank you so much for the sharing. But i have a problem, when i try to select the template there only appear 'the API developer key is invalid'. Can you help me fix the error? Idk how to fix this.😢
@@do_not_reply4784 Hi, there have few solutions, you may refer to 1. help.extensis.com/hc/en-us/articles/360048034833-Google-Drive-error-or-connection-refusal-when-trying-to-run-or-install-the-Extensis-Font-add-on-drive-google-com-refused-to-connect- 2. ua-cam.com/video/a8MqJ8SeJgs/v-deo.html Hope it helps.:)
Hi Dang Red, yes, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day. You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :) docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Welcome Gian, I think what you means is something this "How to Auto Generate and Email Certificate to student, who passed the Quiz-[Google Form]" the link below ua-cam.com/video/fqh-GPIxg_U/v-deo.html. I hope it helps. :)
Hi Abscissa, yes, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day. You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :) docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
After we've reached the 100 limit email sent to all participants in google form, are we able to sent email to the rest participant in the same google form?
Yes, we able to sent email to the rest participant in the same Google spreadsheet next day, but require manually start at number 101 of participants or remove the previous 100 participant. Limitation of this is 100 limit Email per day. Hope it helps :)
Hello! Great tutorial, thank you! I have a question: I followed instructions, everything went OK, emails appear to have been created, they were deducted from my daily mail quota, but they never arrive!? Can you help me figure out what is not working? Thank you!
Hi, the daily mail quota is according to your type of Gmail account. You may refer to the information here "docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#heading=h.ceiugms5bek5" I hope it helps. :)
@@LYSStuff Thank you for the quick (and well documented) answer! I am well within the quota. My problem is that everything seems to beworkink, mails are even substracted from the quota, but they never arrive. It seems that they go out, but they don't come in...
@@zsigmondilka1594 I see, that's strange. Hmmm, maybe you could try just auto generate and email back to yourself. If works, then you may check the list of the emails in the spreadsheet. maybe some of the emails invalid because of extra spacing in the spreadsheet?
@@LYSStuff I have only emailed myself. Literally 78 times of trial and error. Made the form shorter. Questions shorter. Removed sections, all that. I am clueless... Every time the number of emails left drops...
Sir thank you so much... I was able to follow well your procedures, It automatically generated certificate to the participants.. But, the problem was... why is it that the certificate generated did not change with the name of participant..? Instead its the same . Thank you sir so much for your response.
Hi Rosette, i think maybe is the "maps to column" section did not match to the name of participant name, you can watch the video start at 3:11, the mapping to column is refer to which column from google sheet set to place into the in the certificate. I hope it helps. :)
@@maisarahhussin3309 Hi, for similar cases, This mean that in the certificate will get the name from the excel column "Full name (in Certificate)". If the name is not appear, then required to check the certificate template code > or the column name in googlesheet. Hope it helps. :)
Hi, I just checked. Still available to install Autocrat add on in google sheets. Step to install Autocrat add on Open Googlesheet > extensions > add on> search Autocrat > install. I tried for Google Chrome and FireFox. I hope it helps. :)
@@Aiman-w1f Hi, I'm not sure about that, maybe you can try using MS word. However, it also depend on your email account subscription. Example GMail, 2,000 messages per day. Refer to support.google.com/a/answer/166852?hl=en.
Hi, export or save your certificate to image from photos hop. Then set the image in ppt as background image or direct copy paste the image to ppt. Next, follow the step in the video.
Hi Jayakrishna, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day. You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :) docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Hi, yes, I checked. Autocraft still in the add on, maybe sometime need to refresh or re-open the google sheet. Else can install manual in this link for Autocrat: workspace.google.com/marketplace/app/autocrat/539341275670 I hope it helps. :)
This is for webinar registration before send certificate, just to make sure the participant joined the webinar only we send participant certificate. For direct send certificates automatically after the participants submit the form. You may refer to this method (ua-cam.com/video/fqh-GPIxg_U/v-deo.html), just remove the condition marks to pass only received certificate. Hope it helps. :)
Hi, the daily mail quota is according to your type of Gmail account. You may refer to the information here "docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#heading=h.ceiugms5bek5" I hope it helps. :)
My google slides doesnt appear when i need to choose template from my drive. it says only google docs and google sheets. How do i solve this? can you help me? :'))
Whenever I am trying to send certificate using Autocrat using Gsuite.. Emails are not going through.. Getting error message.. Email Blocked... Can anyone let me know the reason plz....
Hi, you may try troubleshoot using this method. You could try just auto generate and email back to yourself. If works, then you may check the list of the emails in the spreadsheet. maybe some of the emails invalid because of extra spacing in the spreadsheet?
@@LYSStuff tried.. It not working either.. When I am using Autocrat option from personal gmail id.. Certificates are going... However issue is with Gsuite... It is not going through.. Message are getting blocked.. Email address is also valid
@@RohitV2011 you may refer to these comment. Seem like G suit has issue with this Autocraft add on. groups.google.com/g/nv-autocrat-add-on/c/OK-TJXlWEzY "Others have reported that when they upgrade their Google accounts to a paid version of GSuite that they encounter this same issue. We were told that Google spam filters are blocking triggered emails ( such as ones from Autocrat) on new Gmail addresses. I recommend that you reach out to Google Support to raise the issue and see if they have any solutions. Autocrat is successfully sending out the email, the issue is that Google is blocking the email from being received."
Hi, there have few solution, you may refer to 1. help.extensis.com/hc/en-us/articles/360048034833-Google-Drive-error-or-connection-refusal-when-trying-to-run-or-install-the-Extensis-Font-add-on-drive-google-com-refused-to-connect- 2. ua-cam.com/video/a8MqJ8SeJgs/v-deo.html Hope it helps.:)
Hi Sherlynn, this the video how to create certificate using Microsoft word ua-cam.com/video/Kgj2CUZpKFg/v-deo.html, almost similar to Microsoft 365. For how to email each specific certificate to specific participant using Microsoft 365, I will show it my next video :)
Yup, there has a limit for autocrat generate certificate per day for free gmail account. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day. You may refer to the quota limit section in the link below for more detailed information. docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview# If for big event, it should be commercial, then it will no have that issue for google app for business. 1500 certificate per day. I hope it helps. :)
Hi, for invalid email error. You may refer to this link ua-cam.com/video/tMMf9sk9lRo/v-deo.html. How to check all the email in spreadsheet is valid or invalid. Since all the details are correct. Hope it helps. :)
@@prathameshwalse9972 Nope, can support more than 3 column. You may refer to this it-helpdesk.tetonscience.org/support/solutions/articles/5000722116-how-to-use-the-autocrat-extension-to-perform-mail-merges-with-google-sheets Hope it helps. :)
Thanks a lot✨, you made this look simpler and easier. The only part I struggled was I didn't know how to insert the template that I already made in Figma to the Autocrat. For that I used the following video. ua-cam.com/video/BkMRUL5SvmE/v-deo.html
Welcome, I see. For your case, the issue not Figma to Autocrat. You just need to copy and paste ur Figma template/slide to google slide. Then proceed the step follow the video. Everything will be fine. Hope it helps :)
@@LYSStuff Nah bro, that copy paste dont work btw those apps. Its fine, i went around and followed the instructions inorder to complete the work. Thank you!
Thank you so much! I know this was posted 4 years ago but it is very helpful to me right now.
Welcome and thanks for your support until now.. 🥂
Thank you so much it's the need of an hour 🤩🤩🤩🤩
My pleasure 😁
Such a HUGE SHARE, Thanks a lot from INDONESIA
My pleasure 🥂😀
Thank you so much for this. You save my life.
My pleasure 🥂
Thank you soo much for teaching me this stuff it going to save my time a lot.
My pleasure 🥂
This is extremely helpful, thank you
Welcome, thanks for your support.
this is amazing!!! thank you so much for the knowledge!
Welcome and thanks for your support
super help to save my time....tqvm
@@RAZALIBINMALIKPOLISAS welcome and thanks for your support
Thank you very much you saved my lots of manual work.
You are welcome 😄🥂
This was really helpful and I exactly needed this, Thank you man!
Welcome 🥂
i guess it is pretty randomly asking but does anyone know of a good site to stream newly released series online ?
@Brysen Shiloh i use flixzone. Just google for it :)
Very cool tutorial! How much participants this method can handle? We have around 3000 participants. Thanks for sharing
Hi, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day.
You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :)
docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
This is so so helpful to me! Thank you so much, Sir.
My pleasure 😄🥂
Super helpful. thank you so much.
Welcome and thanks for your support 🥂
Thank you so much Sir for this informative sharing. It really helps me in producing e-cert. Paperless. Share with us on how to produce surat jemputan pula. =)
You are welcome. Stay tune for how to Auto Generate surat jemputan/lantikan with different name. Haha.. 😁
@@LYSStuff Cant wait, Sir. =D
@@mohdikhsanmdraus How to Auto Generate surat jemputan/lantikan with different Name, Position and ID of Employee ua-cam.com/video/zP1ZtcJhVSA/v-deo.html. I hope it helps. :)
Very useful to me, thanks a lot bro
Welcome 🥂
Thank you for making this video. Really made my day
You are Welcome 🥂😄
Thank you for sharing!
Welcome and thanks for your support. 🥂
It's going to be really help, but is it possible if i just make the sheets, not from google form response?
Hi, yes, it can just auto generate the certificate using the spreadsheet alone with the Google slide (certificate design). Just remember the header "map column" must be match.
There also have alternative option to use Microsoft word and Excel only. Here is the link.
ua-cam.com/video/Kgj2CUZpKFg/v-deo.html
Hope it helps.
@@LYSStuff okaayy.... thank you very much sir
Welcome 🥂
@@LYSStuff hey humble101, i have try that and it works, thankyou so much, i just want to ask is there a way to put another document in the email we send for the certificate? Please 🙏🙏 i really need your help right now
Hi, I have no idea for that. I did not try it before. 😅
Thank you so much sir. Very useful.
My pleasure 😁
Thanks. It was helpful.
Welcome 🥂
Hello! I found this video very helpful! However, I encountered an issue where I’m not receiving any emails to get the e-certificate. I also saw the message: "Rows that will be merged: No rows will be merged. None meet merge criteria." Could you help me resolve this?
Hi, I think is your tagging is incorrect. The tagging symbol or your spreadsheet email got extra spacing?
@@LYSStuff I have double checked the tagging-- There is no extra spacing. And upon checking the docu merge status I have found this
Failed to add (email) as viewer: API call to drive.permissions.insert failed with error: Invalid permission value; !!Error Sending Emails: Invalid email: (email); Manually run by (email);
do you think that I made a mistake along the procedure?
Oh, also, can it be sent to a non-Gmail account, like for example, an organization’s Microsoft account? Super thanks for your assistance btw!
Yes, it can send to any email address. No limit to specific email address. Just need to make sure the email address is correct and without extra spacing at first or end of the email address. Usually that's happen cause the error.
Thank you for sharing. It means a lot 😁
My pleasure 🥂
Hi, thanks for the explanation
1- How can I run the web link directly after the submit form button?
2- How can I show the sender's mail in the form field without typing it?
3- How do I get a student to check-in and check-out only twice a day ?
Thank you ....
Hi,
1. Sorry, I not sure what do you mean "I run the Web link"
2. I have no idea for that. I think it must type something on it.
3. This autocraft is just to generate E-certificates. Do not have function for check in and check out .
:)
Hi thanks a lot. Is is possible we can generate google form without the need to fill in names but to generate a certificate with names after completion of feedback?
Yea, in Google form. Select "required" for the name.
Thanks! This helps a lot. 🥰
My pleasure 🥂😊
Can we use portrait of the certificate design?
Yes, we can. Just set the Google slide to portrait.
Can we do like entering one person's details in form and then copying pasting others' directly on spreadsheet produced from that single response?
Yes, you can. You also can direct use your spreadsheet that already have all others people detail. Just remember the Column header must define in AutoCraft App.
Hope it helps.:)
@@LYSStuff how to use simple spreadsheet for that?
Hi, if u mean normal spreadsheet, just use it as usual spreadsheet. Copy and paste the list of attendance or details u have for each column.
But if you mean "simple spreadsheet" app, then I have no idea for that.
@@LYSStuff ok. Thanks. You really deserve appreciation 🥺🥺
@@khizarabbas2127 Thanks for your support ✌️
Thanks a lot for this video!!! Extremely useful! I have one question only: can you do it using non-gmail email address?
For this method only support gmail. Because is using google sheet and google slide. However, there is another way by using Microsoft word->Merge Mail-> email to user. Using Microsoft word able to use non-gmail email address.
You may refer to this ua-cam.com/video/Kgj2CUZpKFg/v-deo.html
Hope it helps. :)
@@LYSStuff thank you so much for a very quick and detailed reply! Much appreciated!
Most welcome 🥂
Hello, thank you for the video. However, I've encountered an issue: despite following the instructions, all certificates were sent to just one participant instead of the 100 intended recipients. I've explored various options, but my email, shows they all went to one person. I urgently need your support to resolve this issue. Thank you!
@@MuzhdaaaaaaHi, please check on the email tagging at the ppt, email column in spreadsheet.. Maybe the naming is not match. Else maybe is other participant email with extra spacing at the end.
@ thanks, I figured it out by making different sheets and dividing 100 people into smaller groups 🙌🥳 thank you sooooooooo much for the video, I was so anxious about it now I am all free
@Muzhdaaaaaa nice, glad u solved it👍👍
Thank you!!!!
@@xaveart2260 welcome and thanks for your support
For this, Do we need to have G-suite account or the regular one ?
Hi, this autocrat support both regular and G-suite account.
Just for standard account, limit Email Sent 100/day and Document Creation 250 / day.
You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :)
docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Hye, thank you so much for the sharing. But i have a problem, when i try to select the template there only appear 'the API developer key is invalid'. Can you help me fix the error? Idk how to fix this.😢
Hi, I think this is the browser setting or google drive. You may refer to this "kb.blackbaud.com/knowledgebase/Article/105272"
Hope it helps. :)
same , i heard they have not renewed there google api subscription
@@do_not_reply4784 Hi, there have few solutions, you may refer to
1. help.extensis.com/hc/en-us/articles/360048034833-Google-Drive-error-or-connection-refusal-when-trying-to-run-or-install-the-Extensis-Font-add-on-drive-google-com-refused-to-connect-
2. ua-cam.com/video/a8MqJ8SeJgs/v-deo.html
Hope it helps.:)
Thanks a lot, really simple and easy to understood :D
My pleasure 🥂
Is there a daily limit for sending the certificates?
Hi Dang Red, yes, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day.
You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :)
docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Muchos gracias for this, sir. Do you know how it can automatically send the certificates right after they finish answering the form?
Welcome Gian, I think what you means is something this "How to Auto Generate and Email Certificate to student, who passed the Quiz-[Google Form]" the link below
ua-cam.com/video/fqh-GPIxg_U/v-deo.html.
I hope it helps. :)
Thank you so much!
My pleasure 🥂
What is t format for the e cert ? Is it adobe illustrator or microsoft word?
Hi, the format is PDF documents.
thank you
@@F_i_s_h_l_o_v_e_r Welcome, hope it helps. :)
Thank you so much
Welcome and thanks for your support😃
thanks a lot to youuuu ❤️❤️❤️
Most welcome🥂
thanks a lot.
Welcome and thanks for your support too. 😃
Hi, everything works fine except the name on the certificate didnt change at all. How to fix this?
Hi, no worry. Just check on the symbol of and the .
Other is the check on the "output as Multiple output mode (Classic mode) 04:32"
Hi. Where should I re-check if I want to correct the pdf file name? I could not trace where it went wrong.
Hi, you may refer to the video starting at 3:40. "(Autocraft) 4. Filename setting".
Hope it helps.:)
@@LYSStuff Thanks!
@@zafirahizham1093 welcome :)
Tysm for you help
My pleasure 😄
sorry Sir, how much the maximum certificate can be made using autocrat? is there any limit autocrat generate certificate?
Hi Abscissa, yes, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day.
You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :)
docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
After we've reached the 100 limit email sent to all participants in google form, are we able to sent email to the rest participant in the same google form?
Yes, we able to sent email to the rest participant in the same Google spreadsheet next day, but require manually start at number 101 of participants or remove the previous 100 participant. Limitation of this is 100 limit Email per day. Hope it helps :)
Hello! Great tutorial, thank you! I have a question: I followed instructions, everything went OK, emails appear to have been created, they were deducted from my daily mail quota, but they never arrive!? Can you help me figure out what is not working? Thank you!
Hi, the daily mail quota is according to your type of Gmail account. You may refer to the information here
"docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#heading=h.ceiugms5bek5"
I hope it helps. :)
@@LYSStuff Thank you for the quick (and well documented) answer! I am well within the quota. My problem is that everything seems to beworkink, mails are even substracted from the quota, but they never arrive. It seems that they go out, but they don't come in...
@@zsigmondilka1594 I see, that's strange. Hmmm, maybe you could try just auto generate and email back to yourself. If works, then you may check the list of the emails in the spreadsheet. maybe some of the emails invalid because of extra spacing in the spreadsheet?
@@LYSStuff I have only emailed myself. Literally 78 times of trial and error. Made the form shorter. Questions shorter. Removed sections, all that. I am clueless... Every time the number of emails left drops...
@@zsigmondilka1594 maybe can check on email tag name ? ">" might the cause.
else also have no clue for your case 😅
Sir thank you so much... I was able to follow well your procedures, It automatically generated certificate to the participants.. But, the problem was... why is it that the certificate generated did not change with the name of participant..? Instead its the same . Thank you sir so much for your response.
Hi Rosette, i think maybe is the "maps to column" section did not match to the name of participant name, you can watch the video start at 3:11, the mapping to column is refer to which column from google sheet set to place into the in the certificate. I hope it helps. :)
@@LYSStuff hi, i still dont get it.
@@maisarahhussin3309 Hi, for similar cases, This mean that in the certificate will get the name from the excel column "Full name (in Certificate)". If the name is not appear, then required to check the certificate template code > or the column name in googlesheet.
Hope it helps. :)
why at My source data to template does not appear "standard" and "maps to column"
Maybe Miss out to include this symbol " >"?
I don't have an add on option in my google sheets how can I make it available?
Hi, I just checked. Still available to install Autocrat add on in google sheets.
Step to install Autocrat add on
Open Googlesheet > extensions > add on> search Autocrat > install.
I tried for Google Chrome and FireFox.
I hope it helps. :)
@@LYSStuff thanks
Welcome and thanks for your support. :)
How to double check if it is already sent to people's email? Just based on our sent box?
Hi, perharp yes, only based on our sent box.
@@LYSStuff Owh noted that. Btw, is there any platform to do things like this but without limit of sending per day?
@@Aiman-w1f Hi, I'm not sure about that, maybe you can try using MS word. However, it also depend on your email account subscription. Example GMail, 2,000 messages per day.
Refer to support.google.com/a/answer/166852?hl=en.
How to use my own certificate that i designed on photoshop please?
Hi, export or save your certificate to image from photos hop. Then set the image in ppt as background image or direct copy paste the image to ppt.
Next, follow the step in the video.
@@LYSStuff thank you very much
My pleasure :)
Thank you
Welcome and thanks for your support. :)
I was not able to send more than 100 what to do can I give permissions to google suit mail now after creating In normal mail
Hi Jayakrishna, there has a limit for autocrat generate certificate per day. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day.
You may refer to the quota limit section in the link below for more detailed information. I hope it helps. :)
docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
Hello , I cant find AutoCrat when I search for AddOn inside google sheet . I only find it while searching in google
Hi, yes, I checked. Autocraft still in the add on, maybe sometime need to refresh or re-open the google sheet. Else can install manual in this link for Autocrat:
workspace.google.com/marketplace/app/autocrat/539341275670
I hope it helps. :)
Won't it send the certificates automatically after the participants submit the form ?
This is for webinar registration before send certificate, just to make sure the participant joined the webinar only we send participant certificate.
For direct send certificates automatically after the participants submit the form.
You may refer to this method (ua-cam.com/video/fqh-GPIxg_U/v-deo.html), just remove the condition marks to pass only received certificate.
Hope it helps. :)
i am able to send only 50
is there anyway to increase the cap ?
Hi, the daily mail quota is according to your type of Gmail account. You may refer to the information here
"docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#heading=h.ceiugms5bek5"
I hope it helps. :)
My google slides doesnt appear when i need to choose template from my drive. it says only google docs and google sheets. How do i solve this? can you help me? :'))
Hi, this is strange. Maybe you could try to put your Google slide template at My drive. Not in any folder. It will shown as 02:42.
Hope it helps :)
im sorry sir, mine cannot detect pdf file (cert) from google drive, can you give me the solution?
Hi, to detect your template from Google drive. The template must be ".ppt"file , not ".Pdf".
Hope it helps. :)
Hi, my Autocrat is always at generating new jobs every times I open, May I ask why?
Hi, if not mistaken, Autocraft no have function to save previous record. It's always start new job.
Hope it helps. :)
@@LYSStuff Autocrat in my sheet keep loading at the same page for more than 10minutes 😅
You mean did not move to other step after you click next? Maybe need to update browser or restart the browser.
why does mine does not send to the email but it auto generates the name?
@@PAUSSO-w7c email tag incorrect? Or email column "naming tag" not match with the setting in autocraft.
@@PAUSSO-w7c else your email maybe have extra "space bar "
Whenever I am trying to send certificate using Autocrat using Gsuite.. Emails are not going through.. Getting error message.. Email Blocked... Can anyone let me know the reason plz....
Hi, you may try troubleshoot using this method. You could try just auto generate and email back to yourself. If works, then you may check the list of the emails in the spreadsheet. maybe some of the emails invalid because of extra spacing in the spreadsheet?
@@LYSStuff tried.. It not working either.. When I am using Autocrat option from personal gmail id.. Certificates are going... However issue is with Gsuite... It is not going through.. Message are getting blocked.. Email address is also valid
@@RohitV2011 you may refer to these comment. Seem like G suit has issue with this Autocraft add on.
groups.google.com/g/nv-autocrat-add-on/c/OK-TJXlWEzY
"Others have reported that when they upgrade their Google accounts to a paid version of GSuite that they encounter this same issue.
We were told that Google spam filters are blocking triggered emails ( such as ones from Autocrat) on new Gmail addresses.
I recommend that you reach out to Google Support to raise the issue and see if they have any solutions.
Autocrat is successfully sending out the email, the issue is that Google is blocking the email from being received."
Can you ask participants to sign back automated
Hi, Yes can. Refer to 05:15 "Share Document & send email", you may write down the email request participants to sign back.
Hope it helps. :)
why does it didn’t attach the e certi with the email? it only send the respond??? pls helpp 😢😢😢
@@minatos7364 check the certificate , and the spreadsheet email list, make sure so not have extra spacing
for me it says , drive refused to connect. what to do?
Hi, there have few solution, you may refer to
1. help.extensis.com/hc/en-us/articles/360048034833-Google-Drive-error-or-connection-refusal-when-trying-to-run-or-install-the-Extensis-Font-add-on-drive-google-com-refused-to-connect-
2. ua-cam.com/video/a8MqJ8SeJgs/v-deo.html
Hope it helps.:)
Hi Sir.. how to generate e-cert and email to all participants by using microsoft 365?
Hi Sherlynn, this the video how to create certificate using Microsoft word ua-cam.com/video/Kgj2CUZpKFg/v-deo.html, almost similar to Microsoft 365. For how to email each specific certificate to specific participant using Microsoft 365, I will show it my next video :)
@@LYSStuff link for office 365
quite fast and vague.... you could maybe try explaining crucial stuff like the add on autocrat first
this is only applicable in less 100 certificate its not for big events
Yup, there has a limit for autocrat generate certificate per day for free gmail account. However, it will again refresh the quota the next day. For standard account, limit Email Sent 100/day and Document Creation 250 / day.
You may refer to the quota limit section in the link below for more detailed information.
docs.google.com/document/d/1gGSonT0zm2TZlE_P32NJSQByvHraLbN6KM44WyTXwdI/preview#
If for big event, it should be commercial, then it will no have that issue for google app for business. 1500 certificate per day.
I hope it helps. :)
All the big programs secretary is here for a reason I guess 😂
Yea, finally can automatic 😂. Another way is using Microsoft Office, may refer to this video ua-cam.com/video/Kgj2CUZpKFg/v-deo.html
Hello sir.
When i tried to connect the template from drive, it mentions “Error: The API developer key is invalid.”
How do i solve this problem?
Hi, I this is the browser setting or google drive. You may refer to this "kb.blackbaud.com/knowledgebase/Article/105272"
Hope it helps. :)
brother, how to get an unlimited monthly email quota in PerformFlow.....?
Hi, the link below shows information how to subscribe unlimited monthly email quota in PerformFlow. I hope it helps. :)
performflow.com/pricing/
Invalid email error
Please help all the details are correct
Hi, for invalid email error. You may refer to this link ua-cam.com/video/tMMf9sk9lRo/v-deo.html. How to check all the email in spreadsheet is valid or invalid. Since all the details are correct.
Hope it helps. :)
@@LYSStuff does autocrate only allow 3 column merge?
@@prathameshwalse9972 Nope, can support more than 3 column. You may refer to this it-helpdesk.tetonscience.org/support/solutions/articles/5000722116-how-to-use-the-autocrat-extension-to-perform-mail-merges-with-google-sheets
Hope it helps. :)
I love you
It's not working now.
Maybe try again later. I have tried again, it's still able to function as usual. :)
Thanks a lot✨, you made this look simpler and easier. The only part I struggled was I didn't know how to insert the template that I already made in Figma to the Autocrat. For that I used the following video.
ua-cam.com/video/BkMRUL5SvmE/v-deo.html
Welcome, I see. For your case, the issue not Figma to Autocrat. You just need to copy and paste ur Figma template/slide to google slide. Then proceed the step follow the video. Everything will be fine.
Hope it helps :)
@@LYSStuff Nah bro, that copy paste dont work btw those apps. Its fine, i went around and followed the instructions inorder to complete the work. Thank you!
Your transition is so fast cant even understand what you are sayiny
Sorry man, might be my English problem. No transition.