Google Script Create Google Docs on the fly from templates [Free Coupon]

Google Scripts is a powerful resource with so much to offer. This course covers Google Script, drive, sheets, docs
Instructed by: Laurence Svekis | Subject: Office Productivity, Google

Description

Google Apps Script sheet data to doc using templates course! Learn how to use the power of Google App Script to power up your Google sheets and Google docs. This course will walk you through how to setup a Google Doc generator using a Google Doc as a template and storing the data in Google Sheets. Source code is included so you can get started quickly includes all methods and classes use for this type of project which can also be used for similar custom applications Once you start using Google Script you will be amazed at how easy it is and how much power you get with just a few simple built in classes. Google script is JavaScript with a bunch of Google predefined classes, methods. It gives you the ability to connect apps together. Within this project we show you how to access the Google Script editor, all you need is a Google account and you are ready to create apps! Using the script editor you can access your google spread sheet data and use it like a database. Create a template or as many as you like, the app can pull them in dynamically by searching your google drive and pulling them into the script. Use Google script then to read the file contents and select all the fields you want to have inputs for within your template. All this data goes into the Google Spreadsheet which then gets access by the part of the app that creates documents from the template. Open the dialog window select the template, all the fields for the template get populated into the dialog form which allows the user to easily enter values to populate the new template with. Select create and the script will make a new document in your Gdrive folder using the template and updating the fields with new data. All this in a few lines of code built using Google Script.

Outcome

1. Create Google Docs with script
2. Use Google sheets to store data and access data
3. Send and retrieve data from Google Sheets

Take This Course

Course Info

• 31 Lectures
• 2.5 Hours
• Language: English
• Subject: Office Productivity, Google
• Instructed by: Laurence Svekis
• Last updated on August 2017
• Platform: Udemy