Google Script Create Google Docs on the fly from templates
4.8 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,014 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Script Create Google Docs on the fly from templates to your Wishlist.

Add to Wishlist

Google Script Create Google Docs on the fly from templates

Google Scripts is a powerful resource with so much to offer. This course covers Google Script, drive, sheets, docs
4.8 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,014 students enrolled
Created by Laurence Svekis
Last updated 8/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 11 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create Google Docs with script
  • Use Google sheets to store data and access data
  • Send and retrieve data from Google Sheets
View Curriculum
Requirements
  • JavaScript
  • HTML CSS
  • jQuery
  • Google Account
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.

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. 


Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:25:50
+
Introduction to using Google Script
31 Lectures 02:31:30


Setup Files and Headings
04:17

Create menu items to launch functions
07:13

Source Code for GS
00:02

Create HTML Popup Dialog Window
08:22

Source Code to Get HTML file contents
00:04

Build HTML frontend
06:40

List gDrive files
08:24

Source Code
00:07

List Google Drive Contents into Google Spreadsheet
11:04

Source Code
00:11

Read Document Content use body content in Google Script
12:00

Use Google Script Get Spreadsheet data and return as an array
06:23

Source Code
00:37

create dynamic select list
05:16

Use Data to generate fields for input to template
09:19

picker.html source code
00:40

Get form input values
07:16

Pass Data to Google Script from html
06:25

Source Code HTML
01:45

Source Google Script
01:08

Planning to create doc into folder
06:07

Copy document into drive folder
07:25

Generate Doc from a template doc
08:36

HTML script tweaks and styling
08:22

Source Code Picker.html
02:08

Google Script Tweak
03:16

Google Script Source Code
01:17

App testing and conclusion
04:39

Course Resources
01:12
About the Instructor
Laurence Svekis
4.2 Average rating
14,197 Reviews
313,199 Students
188 Courses
Instructor, 18+yrs Web Experience

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today

Providing Web development courses and digital marketing strategy courses since 2002.

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"