Create documents with Google Sheets and Google Forms responses. Includes Mail Merge, Store merged files in Google Drive and Share
Create documents from your spreadsheet data and Google Forms responses in a snap. Use built-in Mail Merge to email documents, files are saved in Google Drive and can be automatically shared or printed.
Use Document Studio to create professional looking and sophisticated documents including personalized business letters, student test results, customer invoices, event tickets, vendor contracts, purchase orders, sales pitches and any other type of document that you need to generate on a repetitive basis. You’ll never have to copy-paste data again.
The documents can be generated in a range of formats including PDF, Microsoft Word, Excel, PowerPoint presentations, OpenOffice formats, ePUB ebooks, HTML web pages or plain text.
You can also include Google Maps images, QR Code images and PayPal payment links in your generated documents and emails using the built-in spreadsheet functions that become available once you install Document Studio.
How Document Studio Works
Document Studio allows you to automate the creation and sharing of documents in few easy steps.
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.
Bonus Features in Document Studio
Document Studio includes Mail Merge so you can automatically send the generated documents to one or more recipients in personalized emails. The included WYSIWYG email designer helps you create nice looking emails with your own brand logo images.
The addon is integrated with Google Cloud Print and the generated documents can be sent to any of your printers as soon as the files are generated.
All your documents are stored in Google Drive and you can personalized the file name as as well the folder path where those files are saved. Use built-in sharing options to immediately share the generated documents with customers, team members or anyone else.
Your information is 100% safe in your Google Drive. The Google Addon does not store, share, or upload any of your data.
Document Studio Resources
Getting Started Guide:
Document Studio Knowledgebase
v63: Bug fixes, date and time are now formatted in the Google Spreadsheet timezone
v60: Added support for Gmail Aliases. Mail Merge documents and forms from any of your email accounts that are connected to Gmail.
v59: Documents are regenerated when an existing form response is edited and resubmitted by the respondent. Improved Google Sheet formulae for QRCODE, GOOGLEMAPS and PAYPAL.