Forms, Sheets, Slides, and Certificates.. Oh My!

If you are a Googly geek like me then you are always trying to find new cool and efficient ways to use the tools you have at your fingertips. 

I have loved AutoCrat for years and now that you can use with Slides... it is a worthy blog post and YouTube video how-to for staff to use.  It is hard to put my smile into this post, I am grinning  😊.

So here goes.  AutoCrat combined with Google Forms and Google Slides gives you endless possibilities for auto-creating documents from a Google Form submission.

YouTube How-To - https://youtu.be/Ku8XFxE4Wzk (14min step by step)

Here are the steps in words:

• Create a Google Form with the information that will go onto your certificate, award, poster, etc.
• Create a "Slide" document to be your certificate, award, poster, etc.
• Create tags inside the slide document for the fields from the form by indicating them surrounded by <<FIELD NAME>>
• From the Google Sheet that the Form creates, get the add-on called AutoCrat, install and run
• Cruise through the AutoCrat wizard to connect your Sheet to your Slide document.  Make sure you set to Trigger on Form
• Get a short URL for your form to share with your staff so they can use from anywhere at anytime.
• Sit back and enjoy as the forms come in and the certificates get created instantly and shared with the staff.

A big thank you to CloudLab a part of New Visions Public Schools for their creation of AutoCrat