Autocrat add-on
After seeing what offerings were available in our online Term 3 Toolkits - I decided I'd use some of this lockdown learning time to upgrade my skills with sheets. The first toolkit Dave offered was Autocrat to Automate. Autocrat is an add-on for google sheets. It's a mail merge tool that takes raw data from sheets and merges it into docs, slides etc. that could be used for personalised letters, certificates etc. In this video Dave shared, Eric Curtis uses Autocrat to show how easy it is to generate certificates for his webinars. He has a google form (which includes participants name, email and a quiz) which is completed by participants that populates the sheet. He had a template certificate ready in docs for those that passed and a template letter ready for those that did not pass. Using Autocrat, you can insert text, hyperlinks and also images (by inserting a web address that points to an image). He shows how he can set rules in Autocrat so that those who pass would get email...