Amit Agarwal
•  2,016,885
Overview
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.
Create documents from data in Google Sheets and Google Forms responses. Use the built-in Mail Merge tool to email documents, the files are saved in Google Drive, generated documents can be automatically shared with colleagues or print them via Google Cloud Print. You can create documents in Google Drive and Shared 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 and it will link to the uploaded file in Google Drive.

The documents can be generated in popular file 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 20 documents per day with the free version while premium users can generate 1500+ documents in the 24-hour period. Go to https://digitalinspiration.com/buy to get the premium version.

Document Studio is built by Google Developer Expert and 100% compliant with Google API data policies. Certificate can be provided upon request.

How Document Studio Works
-------------------------

Document Studio allows you to automate the creation and sharing of documents in a 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 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.

Use Cases for Document Studio
-----------------------------

1. Education - Create School Certificates, Student Badges with Google Slides, Student Test Results in Google Sheets.

2. Business - Sales Quotes, Purchase Orders with Google Forms, Project Proposals in Google Docs, Vendor Contracts, Client Invoices, Lease Agreement PDFs, Custom Letters

3. Events - Generate Thank-you Letters, Create Event Tickets with QR Badges and Google Maps, Send Event Invites with Gmail

4. HR Orgs - Employee Appraisals, Employee Requests, Presentation Copies, Policy Documents.

Document Studio (with Google Forms and Google Sheets) is also being used by organizations to visually communicate with employees who are working from home during the Coronavirus (COVID-19) crisis.

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

Getting Started Guide:
https://www.labnol.org/getting-started-guide-6030

Video Tutorials
https://bit.ly/DocumentStudioVideos

Document Studio Knowledgebase
https://www.labnol.org/topic/document-studio/

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

Technical Support:
https://digitalinspiration.support

Privacy Policy:
https://www.labnol.org/document-studio-privacy-5877


Product Updates and Changelog
-----------------------------
v17.4 - Merge on Form Submit option restored in the Save section (thanks for the feedback). If a Google Form submission is routed to multiple email recipients and one or more email address is invalid, the notification would still go out to other valid email addresses. 
v17.0 - Google Forms Publisher lets you choose one or more Google Forms for which the documents should be generated. Document Studio can now be easily configured to either send emails, or merge documents or do both tasks simultaneously. The merge documents can be sent as file attachments with mail merge.
v101 - Added option to resize images in documents that use Google Docs, Google Sheets or Google Slides as templates.
v100 - Fix for document template markers.
v99 - Resolved issue related to Google File Picker for selecting folders and documents in Google Drive
v98 - Migrated to Chrome V8, makes the add-on faster and better.
v97 - Fix permissions issue with sharing merged documents in Google Drive.
v94 - Security Assessment completed by Google. Scopes 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 the 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 document templates with a 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
Language:
Sort by:
Profile Picture
A User of Document Studio
July 7, 2020
It is working if i manually merge the spreadsheet but not when a new row is added.
Is this review helpful?
Yes
No
Profile Picture
A User of Document Studio
July 6, 2020
Same issue here. Need help ASAP It is completely non functional at this point
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
July 7, 2020
Sorry for the inconvenience. We've investigated the issue and here's what happened. Google introduced some changes at their end that broke all GSuite add-ons which use the Gmail service to send emails. They have pushed a fix and the add-ons seem to be working again. I would suggest that you reload the Google Sheet, wait for a couple of seconds for the add-on to initialize and it should work as before.
Profile Pciture
A user of Document Studio
July 6, 2020
is one of you using the paid version? maybe they stop supporting just the free one?
Profile Picture
A User of Document Studio
July 6, 2020
We are having the same issue. It's only showing the "Help" option. This is negatively impacting our business. Please get this fixed asap.
Is this review helpful?
Yes
No
Profile Pciture
A user of Document Studio
July 6, 2020
Same! However, this is also showing up on my other add-ons (i.e., Form Publisher)
Profile Pciture
A user of Document Studio
July 6, 2020
Same. It has completely stopped working for me.
Profile Picture
A User of Document Studio
July 6, 2020
It was working well yesterday, but now when I go to the add-on menu --> document studio, the only option I have is "Help" tried logging out and back in, tried the incognito window. Nothing is working.
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
July 7, 2020
Sorry for the inconvenience. We've investigated the issue and here's what happened. Google introduced some changes at their end that broke all GSuite add-ons which use the Gmail service to send emails. They have pushed a fix and the add-ons seem to be working again. I would suggest that you reload the Google Sheet, wait for a couple of seconds for the add-on to initialize and it should work as before.
Profile Pciture
A user of Document Studio
July 6, 2020
is one of you using the paid version? maybe they stop supporting just the free one?
Profile Pciture
A user of Document Studio
July 6, 2020
Same issue here.
Profile Pciture
A user of Document Studio
July 6, 2020
me too... it suddenly stopped working
Profile Pciture
A user of Document Studio
July 6, 2020
Right now it is EST where I live in the States, they are on July 7th after 1am . . . . .
Profile Pciture
A user of Document Studio
July 6, 2020
I'm having similar problems. The automated form filling feature isn't working consistently today, and when I try to open the add-on it keeps giving a server error. Hopefully this is getting fixed!
Profile Pciture
A user of Document Studio
July 6, 2020
I just filled out a ticket and don't even see an email yet that I created it.
Profile Pciture
A user of Document Studio
July 6, 2020
I'm having same issue. Its only showing the "help" option. This is negatively impacting my business. Has anyone created a ticket? Since I can't open i can't see my License Key to properly fill out ticket.
Profile Pciture
A user of Document Studio
July 6, 2020
same here :(
Profile Pciture
A user of Document Studio
July 6, 2020
Same here. Help!!
Profile Pciture
A user of Document Studio
July 6, 2020
Same here! Help! I even uninstalled it and reinstalled it and nothing worked.
Profile Pciture
A user of Document Studio
July 6, 2020
Same here, did all that you did, I even restarted my computer to see if that would help. I also opened in another account that I use this for, still was not working. Keep us all posted!
Profile Picture
A User of Document Studio
July 6, 2020
It do not go for configuration options... not working even tried incognent mode and different brouser
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
July 7, 2020
I would suggest that you reload the Google Sheet, wait for a couple of seconds for the add-on to initialize and it should work as before.
Profile Pciture
A user of Document Studio
July 6, 2020
I also tried - something doesn't work
Profile Picture
A User of Document Studio
July 4, 2020
Great
Is this review helpful?
Yes
No
Profile Picture
A User of Document Studio
July 2, 2020
Please fix wrong sending email to another recipient!!
Is this review helpful?
Yes
No
Profile Picture
A User of Document Studio
July 1, 2020
Fantastic add-on!! The user interface is clear and easy to use, functionalities are great, although I am sure one could do more with Apps Scripts I still haven't found anything I can't do with it. Love it, my data flow and architecture has improved dramatically with this. Thanks!!
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
July 2, 2020
Thank you very much 🎉
Profile Picture
A User of Document Studio
June 25, 2020
Supper, I love its work
Is this review helpful?
Yes
No
Profile Picture
A User of Document Studio
June 21, 2020
While generating a customer response (which is a google sheet) ... if I try to use the markers in a conditional statement like =if(isblank{{Marker}}) I seem to get an error ?? Can someone help me pls
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
July 2, 2020
Can you raise a support request?
Profile Pciture
A user of Document Studio
June 23, 2020
hack gmail code send
1-10 of 104
Additional information
Amit Agarwal
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu