For those of you who haven’t seen it yet, here is a very good Google Sheets add-on created by Amit Agarwal from Digital Inspiration called Document Studio. It offers you a practical way to automate your workflow and enhance your productivity. Document Studio allows you to ‘generate sophisticated and pixel-perfect documents automatically from merged data in Google Sheets, Excel files or even Google Forms submissions.’
Document Studio supports Mail Merge allowing you to easily email your generated documents as attached files in your emails. As a teacher, you can use this add-on to collect responses of a Form you submitted to your students and combine that with data from a Google Sheets spreadsheet or Excel file you have previously created to generate a single document which can take the form of a PDF, Excel, Word, PowerPoint, HTML, ePub, or plain text. You can then share your generated document via email or print it using Google Cloud Print. The way Document Studio works is easy and simple:
‘1. Add the source data in a Google Sheet or import from Excel and CSV files. You can also create documents from new Google Forms submissions.
2. Build your templates with markers in Google Docs, Google Sheets or Google Slides.
3. Document studio will quickly generate multiple documents, one per row in the source sheet, replacing the markers in the template with the actual data.’
Watch the video below to learn more about Document Studio