Google Script Create Google Docs on the fly from templates

Google Script Create Google Docs on the fly from templates, available at $64.99, has an average rating of 4.65, with 34 lectures, based on 115 reviews, and has 8770 subscribers.

You will learn about Create Google Docs with script Use Google sheets to store data and access data Send and retrieve data from Google Sheets This course is ideal for individuals who are JavaScript application developers or Anyone who wants to do more with Google Apps or Anyone who wants to learn more about connecting Google Apps together or Anyone who wants to make use of full suite of Google script apps It is particularly useful for JavaScript application developers or Anyone who wants to do more with Google Apps or Anyone who wants to learn more about connecting Google Apps together or Anyone who wants to make use of full suite of Google script apps.

Enroll now: Google Script Create Google Docs on the fly from templates

Summary

Title: Google Script Create Google Docs on the fly from templates

Price: $64.99

Average Rating: 4.65

Number of Lectures: 34

Number of Published Lectures: 34

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Create Google Docs with script

Use Google sheets to store data and access data

Send and retrieve data from Google Sheets

Who Should Attend

JavaScript application developers

Anyone who wants to do more with Google Apps

Anyone who wants to learn more about connecting Google Apps together

Anyone who wants to make use of full suite of Google script apps

Target Audiences

JavaScript application developers

Anyone who wants to do more with Google Apps

Anyone who wants to learn more about connecting Google Apps together

Anyone who wants to make use of full suite of Google script apps

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.? Google spreadsheet is used as a data source the scope of this course is how to use Google Script to create Google Docs on the fly.? In the course?Google Sheets is used as a data source for the listing of created documents and templates storing the doc id and other important data so that it can then be referenced to link out to the Google Doc that was created.

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.

This course is designed to illustrate what can be done with Google Script and how it can be used to create applications that do a lot.

Please note that the scope of this course is Google Script, there is some front end coding like HTML,CSS,JavaScript and jQuery which will not be covered in detail! ?Google Script is pretty much?JavaScript so you need to be familiar with JavaScript in order to follow the course content. ?Classes and methods that are native to Google Script will be introduced to help help the application. ?Do to the large number of classes and methods only relevant ones to complete the application will be covered in this course. ?By the end of the course you will have a clear path on how to develop apps using Google Script to enhance what you can do within your Google Suite of Apps.

This course is taught by an instructor with over 18 years of web development experience having worked with Google Script for over 2 years. ??

I’m here to help you learn how to build applications and ready to answer any questions you may have. ?Join now and see what Google Script can do and how you too can use Google Script to produce some amazing applications.

Google Apps Script?is a?scripting?language based on JavaScript that lets you do new and cool things with G Suite products like Docs, Sheets, and Drive. There’s nothing to install — we give you a code editor right in your browser, and your?scripts?run on?Google’s?servers

GSuite Services used within this course

DocumentApp : The document service creates and opens Documents that can be edited. ?Google Docs
DriveApp : Allows scripts to create, find, and modify files and folders in Google Drive.
SpreadsheetApp : This class allows users to open Google Sheets files and to create new ones. This class is the parent class for the Spreadsheet service.?

Course Curriculum

Chapter 1: Introduction to using Google Script

Lecture 1: Introduction to creating Google Scripts and App project within this course

Lecture 2: Make Google Folders and Files

Lecture 3: Setup Files and Headings

Lecture 4: Create menu items to launch functions

Lecture 5: Source Code for GS

Lecture 6: Create HTML Popup Dialog Window

Lecture 7: Source Code to Get HTML file contents

Lecture 8: Build HTML frontend

Lecture 9: List gDrive files

Lecture 10: Source Code

Lecture 11: List Google Drive Contents into Google Spreadsheet

Lecture 12: Source Code

Lecture 13: Read Document Content use body content in Google Script

Lecture 14: Use Google Script Get Spreadsheet data and return as an array

Lecture 15: Source Code

Lecture 16: create dynamic select list

Lecture 17: Use Data to generate fields for input to template

Lecture 18: picker.html source code

Lecture 19: Get form input values

Lecture 20: Pass Data to Google Script from html

Lecture 21: Source Code HTML

Lecture 22: Source Google Script

Lecture 23: Planning to create doc into folder

Lecture 24: Copy document into drive folder

Lecture 25: Generate Doc from a template doc

Lecture 26: HTML script tweaks and styling

Lecture 27: Source Code Picker.html

Lecture 28: Google Script Tweak

Lecture 29: Google Script Source Code

Lecture 30: App testing and conclusion

Lecture 31: Course Resources

Chapter 2: Bonus Section

Lecture 1: How to create and update a doc coding example

Lecture 2: Source Code Apps Script create and update Google Doc

Lecture 3: Apps Script Copy Doc

Instructors

Laurence Svekis
Instructor, GDE, Application Developer

Rating Distribution

1 stars: 1 votes

2 stars: 2 votes

3 stars: 12 votes

4 stars: 37 votes

5 stars: 63 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!