Saturday 9 December 2017

Creating Personalized Documents on Google Spreadsheet With Simple Steps.


Document Studio is a Google Add-on that allows you to create reports and documents using the merge data that is stored on the Google Sheets. You can also generate documents with live data from the Google Forms Submissions. The documents that are created can be sent within the personalized email messages by utilizing the built-in Mail merge which has a built-in sharing option that can quickly share the documents with other recipients. 

The Documents can be created in Word, Excel, PDF, PowerPoint, ePUB ebooks, Open Office format, HTML web pages from Google Docs. Such files can be uploaded to Google Drive and can be shared and also you can send the file directly to the printer through Google Cloud Print.

The businesses workflows can be integrated with Document Studio and you can do a lot of things such as produce Sales Quote, Purchase Order, School Certificates, Event Invites, Policy Documents and much more. Document Studio offers flexibility on one platform with many features and functions that helps you generate quality documents. 

To get Started with Document Studio the following are the steps on how to use Document Studio:-

First create a Template in Google Slides, Google Sheets or in Google Docs and insert Placeholders and enter the details such as Name and Address for merge Fields.

Now Open a Google Sheet with the source data and the column heading will coincide with the placeholders in the template while the rows will correspond to the records. 

After that, install the documents merge add-on and follow the wizard to create the documents. Document Studio will generate one document per row on the sheet. 
The Document Studio also consist of a WYSIWYG email editor that helps in sending the merged documents to the multiple or single recipient inside the personalized email messages. 

G Suite is comprised of many features and services that will help you in creating documents, spreadsheets, and slides. You can also use the additional G Suite Features such as Hangout, Gmail, Drive, Hangouts, Vault, and Jam board that will revamp your workflow and also your workspace. Document Studio is an Add-on to Google Docs, Spreadsheet or Slides that will help you in creating documents from the Google Spreadsheet data and quicker response from Google Forms. You can use the built-in Mail merge to email files and documents that are saved in the Google Drive which can also be automatically printed or shared to other recipients. Document Studio can used to generate professional and sophisticated documents that consist of customized customer invoices, business letters, purchase orders, student test results and other type of documents. Google Maps images, QR Code Images and PayPal Payment links can be inserted in the generated emails and documents by using the built-in spreadsheet function. All the Documents will be saved on the Google Drive so you don’t have to worry about the storage and it is 100% secure in the Google Drive.

No comments:

Post a Comment