Feeling Lucky?

Create Automatic Certificate with Autocrat Google Sheets

 Bismillah,

Assalamualaikum


Hello everyone, in this article I will share a tutorial on how to create an automatic certificate using Google Sheets with Autocrat Add Ons.


  1. First, prepare a certificate design that will be distributed to trainees.

    1. You can design a certificate using canva.com. There are several certificate designs that can be customized. 

Search for a certificate design on canva.com


  1. Choose the certificate design you want.

Select certificate design


  1. Remove certificate recipient

Delete certificate recipient name 


Delete certificate recipient name


  1. Customize the type of activity and the name of the committee.


Customize the activity type and committee name


  1. Download the certificate in .png or .jpg format.








Download certificate


  1. Second, place the certificate design that you have downloaded on Google Slides.

    1. Put the certificate design in Google Slides.


Insert a certificate design in Google Slides


  1. Set the slide size to match the certificate size. On the File menu > Page Setup.


Adjust the slide size to match the size of the certificate


  1. Enter the text “<<Name>>” in the certificate recipient's name area.



Entering name text in the name of the certificate recipient


  1. You can also enter the committee's signature in Google Slides, with Insert > Image


  1. Third, install Autocrat on Google Sheets Add Ons.

    1. Install Autocrat in Google Sheets via the Extensions menu > Add Ons > Get Add Ons.


Installing Autocrat in Google Sheets Add Ons


  1. Open Autocrat in Extensions > Autocrat > Open


Autocrat View


  1. If you get a notification “drive.google.com refuse to connect” it means you have 2 or more google accounts open. Please sign out of all accounts and log in to only one account that will be used.

  2. If you have successfully entered, please click New Job.

  3. Write Job Name, eg “Training Certificate”


Write Job Name


  1. Choose a certificate template, namely Google Slides which already contains a certificate template that you have designed. Then click Save.


Selecting certificate template 


  1. Write File Name and select Output as .pdf.


Write File Name and change output type to .pdf


  1. Select sheet to be used as data and select column as recipient name.


Selecting the sheet and column to be used as the certificate recipient's name.


  1. Select the folder where the certificate will be stored.


Select a folder


  1. Then press “Next”, “Next” until the option to share the document appears. In the email recipient, write the column heading of the email recipient, in this example it is written "<<Email>>". Then write the email title.


  1. If you want to use a trigger to run this program, then select "yes" for the "Run on form trigger" question.



  1. Then run the program, through the "Play" button



  1. . Autocrat program is running


  1. Link to the certificate storage location and email delivery status will appear.




This is the tutorial for creating automatic certificates using Autocrat and Google Sheets.

I hope this article can be useful, thank you


Wassalamualaikum

Comments

Post a Comment

Popular posts from this blog

Protect Range and Protect Sheet in Google Sheets

Image
  Bismillah, Assalamualaikum On this occasion I will discuss one of the features of Google Sheets, namely "Protect Range" and "Protect Sheet".  Co-editing with others is one of the advantages of using Google Sheets. But sometimes we want some cells to be locked so that they are only edited by the account that owns the file. For that, Google Sheets provides a feature called “Protect Range” and “Protect Sheet”. With this protection system, the file owner will no longer worry that key data or formulas that have been compiled can be tampered with by other users.  Protect Range The steps to "Protect Range" are as follows: Select cells you want to protect with blocking cells, either by left-clicking and holding the mouse or by selecting the end of the cell and then holding "Shift" on the keyboard and then directing the direction"up", "down", "left", and "right" on the keyboard until all the cells you want to prot...
Read more

Membagikan Google Sheets dengan Orang Lain untuk Penyuntingan / Edit Bersama

Image
Bismillah, Assalamualaikum Warohmatullohi Wabarokatuh  Salah satu manfaat dari Google Sheets adalah kemampuan untuk melakukan penyuntingan dokumen bersama orang lain.Untuk melakukan fungsi ini anda perlu membagikan tautan dokumen tersebut. Adapun caranya adalah sebagai berikut : Metode Pertama Cara yang digunakan pada metode pertama adalah dengan melakukan klik kanan dokumen Google Sheets yang ingin dibagikan.  Klik kanan dokumen yang ingin dibagikan. Klik kanan pada dokumen yang ingin dibagikan Kemudian memilih “Share” Selanjutnya akan muncul jendela baru dan menekan tulisan “Change to anyone with the link” yang berwarna biru di pojok kiri bawah, hingga muncul jendela baru lagi. Menekan tulisan “Change to anyone with the link” Jendela baru yang muncul setelah menekan tulisan “Change to anyone with the link” Merubah “Viewer” menjadi “Editor” yang berada di sisi kanan jendela Merubah “Viewer” menjadi “Editor”  Menekan tombol “Copy link” yang berwarna biru dan anda dapat me...
Read more