App Icon
Create documents, certificates and invoices from Google Sheets or Google Forms. Integrate with Slack, Asana, Trello, Telegram, Twilio SMS, PayPal Stripe, Mail Merge with Gmail, add QRCode and Barcodes
Listing updated:September 23, 2022
Works with:
6,743,165
Overview
Create pixel-perfect documents from data in Google Sheets and Google Forms responses. Use the built-in Mail Merge tool to email documents, the generated files are saved in Google Drive and generated documents can be automatically shared with colleagues and clients. You can create documents in Google Drive and Shared Drives.

✅ Workflow Automation and App integrations
Document Studio integrates with popular apps including Slack, Trello, Telegram and more. It helps you automate your workflows and create beautiful documents in minutes. Here's a partial list of processes you can automate with Document Studio:

➡️ Generate documents from Google Sheets and Google Forms
➡️ Send text messages (SMS) with Twilio or Message Bird
➡️ Create tasks in Trello or Asana
➡️ Send mail merge with Gmail, Amazon AWS SES, SparkPost or SendGrid
➡️ Send push notifications to mobile with IFTTT
➡️ Post messages in Slack, Google Chat, Discord, or Telegram
➡️ Create folders, copy and share files with Google Drive
➡️ Call webhooks with payloads using POST, GET or any method
➡️ Organize files uploaded through Google Forms
➡️ Create and send invoices with PayPal, Stripe or Razorpay
➡️ Generate dynamic images from templates created in Google Slides
➡️ Send documents for electronic signature with Zoho or Adobe Sign.

✅ Please visit the help center to learn more.
https://digitalinspiration.com/docs/document-studio

If you generate 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.

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 popular file formats including PDF, Microsoft Word, Excel, PowerPoint presentations, OpenOffice formats, ePUB ebooks, HTML web pages or plain text.

✅ Embed Content in Documents and Emails
https://digitalinspiration.com/docs/document-studio/embed
Document Studio includes built-in support for embedding Barcodes, QR Codes, Google Charts, Images, Links and Google Drive files in emails and documents.

## 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.

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.

✅ Getting Started Guide:
https://digitalinspiration.com/docs/document-studio/tutorial
Use Document Studio to process non-disclosure agreements (NDA) for your business. The client will fill out a Google Form and the automation workflow will convert those form submissions into PDF files. The PDF files are securely archived in your Google Drive and a copy of the agreement is also sent to the client as an email attachment. The workflow will also publish a message in the company's internal Slack channel to notify the team that a new vendor has signed up.

✅ Video Tutorials
https://www.youtube.com/playlist?list=PLIO7o3VwD0X9y87q0lTCh3YtIJuIi3kkT

✅ Document Studio Knowledge base
https://digitalinspiration.com/docs/document-studio/apps

✅  Privacy Policy:
https://digitalinspiration.com/docs/document-studio/privacy-policy
Document Studio is built by Google Developer Expert for Google Workspace and 100% compliant with Google API data policies. The source code has been audited by a Google appointed security vendor and the compliance certificate can be provided upon request.
If you are a school administrator in a K-12 school in the United States that uses or wishes to use Google Workspace add-ons by Digital Inspiration, then in addition to accepting our privacy policy and terms of service, you may choose to add the Student Data Privacy Addendum (DPA) to our agreement.



✅ 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.

✅ Product Updates and Changelog
V2022 (August 15, 2022) - The all-new Document Studio is here and includes tons of new features and improvements. 

- Support chart embeds in Sheets, Slides, Docs and Email
- RTL Support for languages like Hebrew and Arabic
- Support for Templated HTML through Scriptlets
- Support merge tags in header, footer and footnotes of document templates
- Resize Embedded Images in Google Docs Template
- Embed URLs in Google Slides using the {{Embed Link, text, link}} notation
- Attach files in Email using the {{Email File, File Name or File Id or File Path}} notation
- File Upload questions in Google Sheets are hyperlinked to the original file (multiple files supported)
- If a file upload question contains a single image, it is added inline in the Google Sheet else for multiple uploads, the file links are added.
- Embed inline images in Sheets, Docs, Email and Slides using the {{Embed Image, file link}} or {{Email Image, file question}} notation
- Add File Attachments column in Google Sheets and attach quick files in email
- IFTTT Push Notifications
- Organize File Uploads from Google Forms in Google Drive
- Uploaded images from Forms are added as inline images in Google Docs, Slides and as links in email templates
- Uploaded files from Forms are added as links in Google Docs, Slide and Email templates
- New option: Create Read Only files in Drive to not allow revisions or comments
- New option: Prevent viewers from downloading and copying files
- New option: Attach generated files in email messages
- Folder Management - Copy or create new files and folder for user onboarding
- Time Delay features lets you postpone the workflow based on criteria
- Combine and Merge multiple documents in one
- Send email with Gmail, Sendgrid (limit 10 MB), Amazon SES, Sparkpost
- File Sharing Options
  - Anyone
  - Anyone with the link
  - Anyone in domain
  - Anyone in domain with the link

v20 - Google has deprecated Google Cloud Print.

v19 - Improved concurrency checks when multiple Google Forms are submitted simultaneously, added option to include Response Edit URL in email notifications, moved email editor to Cloudflare CDN, removed HTML tags from subject line.

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 addresses 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.



Additional information
PricingPaid with free features
Developer
Privacy policy
Terms of service
Document Studio will ask for the permissions shown below. Learn more
Document Studio will need access to your Google account
This will allow Document Studio to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all of your Google Drive files
View and manage your forms in Google Drive
See, edit, create, and delete all your Google Slides presentations
See, edit, create, and delete all your Google Sheets spreadsheets
Send email on your behalf
See, edit, create, or change your email settings and filters in Gmail
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
View, edit, delete, and manage your Google Cloud Print printers and print jobs
Loading
Search
Clear search
Close search
Google apps
Main menu