All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
4 days left at this price!

This plan includes

  • Limited free courses access
  • Play & Pause Course Videos
  • Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Email & Chat Support
Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to 11,000+ Courses
  • Ads free experience Courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Direct Support
  • Email & Chat Support
  • Cancel Anytime
$29
$29
$29
  • Create Google Docs with script
  • Use Google sheets to store data and access data
  • Send and retrieve data from Google Sheets

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. 

  • JavaScript
  • HTML CSS
  • jQuery
  • Google Account
  • 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
View More...
  • Section 1 : Introduction to using Google Script 31 Lectures 02:22:32

    • Lecture 1 :
    • Introduction to Google Scripts Preview
    • 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 source code
    • Lecture 19 :
    • Get form input values
    • Lecture 20 :
    • Pass Data to Google Script from html
    • Lecture 21 :
    • Source Code
    • Lecture 22 :
    • GS Source Code
    • 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
    • Lecture 28 :
    • Google Script Tweak
    • Lecture 29 :
    • GS Source Code
    • Lecture 30 :
    • App testing and conclusion
    • Lecture 31 :
    • Course Resources
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

683686 Course Views

20 Courses

Instructor, 18+yrs Web Experience I'm here to help you learn, achieve 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 tobring 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!"
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • the-extreme-web-development-course

    The Extreme Web Development Course

    By : Paul Carlo Tordecilla

    Lectures 124 Beginner 4:26:22
  • develop-your-own-chrome-extension-firefox-plugin

    Develop your own Chrome Extension &...

    By : Harshit Srivastava

    Lectures 15 Beginner 2:1:54
  • the-ultimate-codeigniter-3-course

    The Ultimate Codeigniter 3 Course

    By : Paul Carlo Tordecilla

    Lectures 23 Beginner 2:17:35
  • superb-advance-javascript-become-javascript-professional

    Superb Advance Javascript - Become ...

    By : Paul Carlo Tordecilla

    Lectures 28 Beginner 1:28:39
  • application-development-with-ibm-watson

    Application development with IBM Wa...

    By : Harshit Srivastava

    Lectures 14 Intermedite 1:42:29
  • learn-react-16-and-redux-by-building-real-world-application

    Learn React 16 and Redux by buildin...

    By : Haider Malik

    Lectures 74 Beginner 6:46:11

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.