Help & Support
Send Feedback
Document Studio
Create customized documents from your data in Google Sheets or Google Forms. Email documents with built-in mail merge, share files effortlessly or print with Google Cloud Print.
585,385 users
Works with
Install
Overview
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, they can be automatically shared with colleagues or print them via Google Cloud Print. You can create documents in Google Drive and Team Drives.

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.

If you generating PDF documents from Google Forms, any image files uploaded by the form respondent can be embedded inline in the generated document.

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.

You can generate up to 50 documents per day with the free version while premium users can generate 1000+ documents in the 24 period. Go to https://digitalinspiration.com/GA16 to get the premium version.

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 Documents Add-on does not store, share, or upload any of your data.

Document Studio Resources
-----------------------------

Getting Started Guide: 
https://digitalinspiration.com/document-studio-tutorial-6030

Video Tutorials
https://bit.ly/DocumentStudioVideos

Document Studio Knowledgebase
https://digitalinspiration.com/docs/document-studio

Product Website
https://digitalinspiration.com/document-studio

Technical Support:
https://digitalinspiration.com/support

Privacy Policy:
https://digitalinspiration.com/privacy

Changelog
-----------
v97 - Fix permissions issue with sharing merged documents in Google Drive. 
v94 - Security Assessment completed by Google. Scoopes updated.
v91 - New Tutorial - How to generate PDF from Google Form responses - http://bit.ly/FormsPDF
v88 - Automatically skip rows from merging that are hidden in the sheet or filtered. Added support for inline checkout for customers in India.
v87 - Quotation marks and apostrophe issue resolved when different styles are used in document template and source spreadsheet.
v84 - Improved export engine for saving files in PDF and other formats.  
v83 - Bug fix for date issue in Google Forms where the output date in the generated document was off by 1 day for some timezone.
v82 - Added support for Google Team Drives. Now select templates with the File Picker in Team Drives, store merged documents inside Team Drive folders.
v81 - Google Sheets add-ons may have issues when a user is logged into multiple Google accounts in the same browser. This patch resolves the issue by asking the user to switch to the default account.
v78 - Use the preview option to test your settings before running a live document or mail merge. Open sent emails directly from the merge sheet. Merge multiple rows into a single document. Include emoji in email message and subject. Code your own email templates in HTML.
v74 - Added support for embedding inline images uploaded via the File Upload field in Google Forms. Bug fixes.
v70 - You can now include {{placeholders}} inside the Header, Footer and Footnote section of Google Document templates. Bug fixes.
v68: Improved marker detection in Google Slide Templates. Variable markers can now be used inside tables, shapes and groups of shapes or text objects.
v67: Fix for Google Forms to support new lines in Paragraph fields. You can now create create document templates with large number of variable placeholders or {{markers}}
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.
Reviews
A User of Document Studio
November 11, 2019
Hi Amit, Love your tool! Super helpful in everyday business. However, recently faced an issue. Document studio sending a duplicate emails whenever we submit form. set up is Form-> Spreadsheet -> Word Document -> PDF -> Email with PDF attached Could you please help to solve this issue? Please let me know if I can share something more
Submit reply
Cancel
Amit Agarwal
November 23, 2019
Sorry, it was a temporary issue at Google's end and they have resolved it. The issue with multiple documents should therefore be resolved now.
A User of Document Studio
October 30, 2019
It was working exactly how I needed it to, then the free option went away and now I have to find something new....
Submit reply
Cancel
Kim Lizama
October 28, 2019
This app has been a lifesaver for me in trying to help my principal get student surveys out that could be processed, printed and added to the report card. I had learned how to create a Google Doc, but had no idea how to take that info and have it populate our template. I tried another app first, but was not happy with its process and results. I found this app's Youtube video and he described exactly what we needed. It did take a lot of time for me to figure out all of the nuances of what I needed and how to make it work, but his Youtube video was very helpful in walking me through it all. I came back to it many times when I got stuck. I was also able to use the add-on "pdf mergy" to turn all of the individual PDFs into one PDF per teacher that included all of his/her students. The final product is amazing and teachers were thrilled at how easy it was for kids to complete on their end. I could not have figured all of this out without this app and the great Youtube video that explained how to use it so well. Thank you!!
Submit reply
Cancel
Sarah Mokhtari
October 23, 2019
The product did not work like the description stated. When running this in a sheet with 500 or more lines, the add on glitches. I've been emailing for over a month asking for a refund. I've received one reply after sending numerous emails and still have not received a refund.
Submit reply
Cancel
A User of Document Studio
October 16, 2019
I'm using several Google forms that each need to have its own Google doc template. All merge on form submit and they need to work simultaneously. How can I assign a specific template to a specific form ? So far, I'm only able to use one template for all my forms, which is a big inconvenience. Thanks a lot for your help on this.
Submit reply
Cancel
A user of Document Studio
November 20, 2019
i am each need assign a specific kam
A User of Document Studio
October 14, 2019
Work Good,,, but new policy is warning,, because DS can edit your gdrive...?? wew
Submit reply
Cancel
A User of Document Studio
October 13, 2019
Thank you Amit for this great tool, it is really helpful
Submit reply
Cancel
Arum Handini Primandari
October 10, 2019
It start to auto email, and I don't know the problem. There is no warning.
Submit reply
Cancel
A User of Document Studio
September 30, 2019
Great add-on! Have been looking for something exactly like this for a long time! I am taking information from a questionnaire (form to sheet) and creating a document. However, for some reason, although I have copied directly the titles of the columns from the google sheet and placed them into 'curly presses' in the document, only some of the information merges. A lot of the information just stays as I entered it: the titles of the columns in the curly presses. I have tried over and over to fix this, but I have no idea what I have done wrong. Any suggestions would be extremely helpful. Thank you very much!!
Submit reply
Cancel
Elizabeth Taylor
September 27, 2019
I have 27 entries in my sheet, however, need just the 27th entry to be sent as a PDF to my email. Is there a way to only merge a specific entry? (I'm using the free version and only have access to 20 per day)
Submit reply
Cancel
1-10 of 107
Additional information
Search
Clear search
Close search
Google apps
Main menu