Overview What You Will Learn Curriculum Instructor

Course Overview

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. Explore how you can start using Google Apps Script to run code to make things happen within Google Suite of Apps. 

The course covers the following regarding Apps Script and how to use it:

  1. Apply JavaScript methods within Apps Script like date
  2. Create a document using script - add contenat to the document
  3. Create a Spreadsheet using the script
  4. Get object info like ID and URL
  5. Using session to get active user email address
  6. Using Mail Service to send emails via script
  7. DocumentApp and accessing updating existing docs by id
  8. SpreadsheetApp and accessing data contained in existing sheets
  9. Bound script in Docs and Sheets
  10. How to add UI menu items?
  11. Running script functions from UI menu tab
  12. Creating UI alerts
  13. UI prompts to get user input and data
  14. Active document get cursor location
  15. Creating a new sheet using a script
  16. Updating and copying sheet data selected by the user

What You Will Learn

  • Learn about Google Apps Script and how to apply it
  • Learn how to edit and create Google Scripts
  • Learn about Gsuite of applications with Google Apps Script

Program Curriculum

  • Google Script Setup
  • Get Coding Google Apps Script
  • Create Google Files
  • Create Spreadsheet Add Content
  • Send an Email Google Script
  • DocumentApp Class
  • Update Element Text
  • Get Update Spreadsheet
  • Bound Script UI Alert
  • Bound Script UI Prompt
  • ActiveDocument Cursor
  • ActiveSpreadsheet
  • Copy Sheet Data to New Sheet
  • Conclusion Apps Script
  • $7 Million Cybersecurity Scholarship by EC-Council

Instructor

Laurence Svekis

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!

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • Introduction to Raspberry Pi

    Introduction to Raspberry Pi

    Short Course

    Introduction to Raspberry Pi

    Software Development

    Learn How to Create Software and Hardware Projects using Rasp...

    $49.99

    Beginner

    2 hr 0 m

  • Hands-on React Native

    Hands-on React Native

    Short Course

    Hands-on React Native

    Software Development

    Learn to build modern, beautiful & powerful native iOS an...

    $49.99

    Beginner

    6 hr 32 m

  • Learn Python Programming with 100 Practicals

    Learn Python Programming with 100 Practicals

    Short Course

    Learn Python Programming with 100 Practicals

    Software Development

    Learn Python Programming from scratch.

    $69.99

    Beginner

    5 hr 30 m

  • Game Development with C# and Unity – Reinforce Your C# Codes

    Game Development with C# and Unity – Reinforce Your C# Codes

    Short Course

    Game Development with C# and Unity – Reinforce Your C# Codes

    Software Development

    Learn to write code that is not just functional, but clean, m...

    $49.99

    Advanced

    4 hr 18 m

  • React.JS Crash Course: The Complete Course for Beginners

    React.JS Crash Course: The Complete Course for Beginners

    Short Course

    React.JS Crash Course: The Complete Course for Beginners

    Software Development

    Create web apps that are robust, quick, user-friendly, and re...

    $59.99

    Beginner

    2 hr 0 m

  • Optimizing and Securing Ansible Playbooks

    Optimizing and Securing Ansible Playbooks

    Short Course

    Optimizing and Securing Ansible Playbooks

    Software Development

    Efficiently Automating Container and System Management with S...

    $99.99

    Intermediate

    5 hr 0 m

  • OAuth, OpenID, and SAML Crash Course Security for Web and Mobile

    OAuth, OpenID, and SAML Crash Course Security for Web and Mobile

    Short Course

    OAuth, OpenID, and SAML Crash Course Security for Web and Mobile

    Software Development

    Learn how OAuth2, OpenID, and SAML work as open standards for...

    $49.99

    Advanced

    1 hr 0 m

  • Spring Core Framework with Spring Tool Suite

    Spring Core Framework with Spring Tool Suite

    Short Course

    Spring Core Framework with Spring Tool Suite

    Software Development

    The hands-on learning experience of Spring Core Framework

    $49.99

    Intermediate

    1 hr 37 m

1 8