AutoCrat Google Sheets

  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

UniSkills Smart Ideas series on YouTube is an attempt to bring some handy tips and solutions for Teachers. There are some simple tasks and there are tasks that look like devils because the time taken is terrible. However, Technology is very much there to assist all of us.

Here we share AutoCrat Add-on in Google Sheets. We can make and mail certificates/documents in bulk and these will be bulk e-mailed as customised documents to individuals. 

UniSkills Smart Ideas is here with the way we can use AutoCrat right there in the Google Form Spreadsheet and send Customised- individual Certificates along with Covering e-mails. Autocrat works with your Google Account and gets installed as an Add-on in the Google Sheets. Watch this video to learn the whole process.

It is not just the online workshop organisers and participants who need to have some help in making Certificates. They need to make these in bulk but might not be having a tool that does this magic.

Watch this Video to Learn this tool and technique:


G-Suite Marketplace, where AutoCrat is available for instal into our Google Sheets, says:

Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data.
Automate the creation and sharing of personalized documents with autoCrat.

Autocrat is a multi-purpose document merge tool that allows you to take data from a spreadsheet and merge it into a document via a template. Tell Autocrat which fields to merge via <<merge tags>> and then let Autocrat mass-generate personalized documents. Optionally send the documents as email attachments. Optionally tell Autocrat to run when new forms are submitted to created truly automated processes.

About the Author
Author: Parveen Sharma
'You Create Yourself' is the belief that drives the EklavyaParv Life Long Learning Mission. The trilogy of Enhance-Empower-Encourage motivates us and we share learning contents on Communication Skills, EdTech, Life Skills, Blended & Innovative Learning and Insights about Education. These resources are Open Educational Resources (OERs) under CC-BY-NC-SA licence. Parveen is an EdTech Evangelist and has been working in the field of Innovation-driven Education for more than a decade. He writes and delivers training on EduSoMedia, E-Learning, OERs, MOOCs, EdTech, ICT, Blended and Flipped Learning, Academic Intervention, Classroom Makeover, Employability Enhancement, EdTech and Teacher-Student Learning. EklavyaParv is the celebration of his belief in the Learning Spirit of Mankind!