Google Script: Create Google Docs on the Fly from Templates [Video]

Google Script: Create Google Docs on the Fly from Templates [Video]

Laurence Svekis
New Release!

Google Scripts is a powerful resource with so much to offer. This course covers Google Script, Drive, Sheets, and Docs
Mapt Subscription
FREE
$30.00/m after trial
Video
$155.55
RRP $182.99
Save 14%
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$155.55
$29.99 p/m after trial
RRP $182.99
Subscription
Video
Start 14 Day Trial

Frequently bought together


Google Script: Create Google Docs on the Fly from Templates [Video] Book Cover
Google Script: Create Google Docs on the Fly from Templates [Video]
$ 182.99
$ 155.55
The On-Page SEO Guide: Rank Page 1 in Google, Yahoo and Bing [Video] Book Cover
The On-Page SEO Guide: Rank Page 1 in Google, Yahoo and Bing [Video]
$ 92.99
$ 79.05
Buy 2 for $35.00
Save $240.98
Add to Cart

Video Description

This course will walk you through how to set up a Google Docs generator using Google Docs as a template and storing the data in Google Sheets. The source code is included so you can get started quickly, and includes all the methods and classes used for this type of project (they can also be used for similar custom applications). Google spreadsheets are used as a data source. The focus of this course is on how to use Google Script to create Google Docs on the fly. In the course, Google Sheets is used as a data source to list created documents and templates, storing the doc ID and other important data so that they can then be referenced to link to the Google document that was created. 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. Google Script is JavaScript with a bunch of Google predefined classes and methods. It gives you the ability to connect apps together. The focus of this course is on Google Script and frontend coding such as HTML, CSS, JavaScript, and jQuery (which will not be covered in detail).

Style and Approach

Within this project you will be shown 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 spreadsheet 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 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 is then accessed by the part of the app that creates documents from the template. Open the dialog window and 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.

Video Preview

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

Authors

Video Details

ISBN 139781789802399
Course Length2 hours 22 minutes
Read More

Read More Reviews

Recommended for You

The On-Page SEO Guide: Rank Page 1 in Google, Yahoo and Bing [Video] Book Cover
The On-Page SEO Guide: Rank Page 1 in Google, Yahoo and Bing [Video]
$ 92.99
$ 79.05
Google Script - DocumentApp for Beginners [Video] Book Cover
Google Script - DocumentApp for Beginners [Video]
$ 88.99
$ 75.65
Hands-on Google Cloud Platform(GCP) - Data Engineer [Video] Book Cover
Hands-on Google Cloud Platform(GCP) - Data Engineer [Video]
$ 51.99
$ 44.20
Hands-on Google Cloud Platform (GCP) - Cloud Architect [Video] Book Cover
Hands-on Google Cloud Platform (GCP) - Cloud Architect [Video]
$ 41.99
$ 35.70
Machine Learning and Tensorflow - The Google Cloud Approach [Video] Book Cover
Machine Learning and Tensorflow - The Google Cloud Approach [Video]
$ 41.99
$ 35.70
Hands-On Web Development with TypeScript 3 [Video] Book Cover
Hands-On Web Development with TypeScript 3 [Video]
$ 124.99
$ 106.25