Following on from my previous post about using Google Forms to help compile profiles for new bloggers, I have a few updates to share.
I wasn't satisfied with using an add on that only had a limited trial period, and thanks to my mate Vicki, I have another tool called Autocrat that does the job for free. Yay! To get Autocrat, you need to use the add ons menu in Google Sheets. Helpful tip if you're going to use this add on is to make sure your spreadsheet settings are accurate: File > Spreadsheet Settings > General.
Fiona also suggested that it might be helpful to record a demonstration of the merging process, so I have done that too. Please let me know how you get on with this, if you use it. I would also be interested to know of any other classroom uses you can think of for this kind of 'form + template + merge = save admin time' idea.
