Unlock the power of Google Apps Script with practical automation and development training designed to help learners create customized solutions within Google Workspace. Using JavaScript-based scripting, participants can learn how to automate repetitive tasks, connect Google services, and improve productivity across everyday business workflows.
Course Overview:
The Google Apps Script training course gives you a detailed knowledge on coding like Automating data calculation, Fetching and sending data from third party software like Trello & Salesforce, connecting different sheets, Documents and other tools, setting a trigger based on an event. This course is ideal for someone who use google sheets and have no coding background.
Course Objectives:
- Know Handling Spreadsheet and Loop
- Understand IF Statement and Array
- Using Commonly used Functions in Spreadsheet
- Understand usage of Menus, Dialogs and Sidebars, User Interfaces, Add-Ons
- Store and Serve Data
- Know about Triggers & Events and Sending email with details from Google Form
Course Audience:
This Google Apps Script Training is suitable for individuals and professionals who want to automate tasks, improve productivity, and develop customized solutions using Google Workspace:
- Developers and Programmers – Professionals who want to use JavaScript and Google Apps Script to develop automation tools and custom Google Workspace solutions.
- Business Professionals – Individuals who want to automate repetitive tasks, streamline workflows, and improve productivity using Google Workspace applications.
- Data Analysts – Professionals who regularly work with Google Sheets and want to automate data processing, reporting, and spreadsheet-based workflows.
- Google Sheets Users and Power Users – Users who want to extend Google Sheets beyond standard formulas and functions by creating custom scripts and automation.
- IT Professionals and System Administrators – Professionals interested in managing, automating, and integrating Google Workspace processes.
- Office and Administrative Professionals – Individuals who handle repetitive documentation, data entry, reporting, or email tasks and want to automate routine processes.
- Project Managers and Team Leaders – Professionals seeking to improve team workflows through customized Google Workspace automation.
- Students and Aspiring Developers – Learners interested in gaining practical experience with JavaScript-based automation and Google Workspace development.
- Freelancers and Entrepreneurs – Individuals who want to create customized automation solutions for business operations and client projects.
Pre-requisites:
- Fundamental knowledge of Google Spreadsheet
- Basic Experience with coding will be helpful but not mandatory
Course Duration:
- 35 hours – 5 days
Course Content:
Introduction
- Introduction
- script Editor: Where codes are written
- Writing the first line of code
- Good Practices for writing Codes
Handling Spreadsheet and for Loop o Accessing an outside spreadsheet
- What can we do with the Spreadsheets?
- Introduction to for Loop
- More on for Loop
IF Statement and Array
- IF Statements o Array of Variables
- Combining Array and for Loop
Commonly used Functions in Spreadsheet
- Get Last Row of Spreadsheet
- Copy to: Copying from one cell to another
- Change Name, Hide and Show Sheets
- Customized Menu
- Pop Up Dialogue Box
Menus, Dialogs and Sidebars
- Custom Menus
- Dialogs / Sidebars
User Interfaces to Create and Serve HTML
- Client-to-Server Communication
- Template HTML o Restrictions
- Migration to IFRAME
Add-Ons o Translate for Google Docs
- Notification for Google Forms
- Translate for Google Slides
- Progress bars for Google Slides
Store and Serve Data
- Script/user/Document Properties
- External Databases via JDBC
- Content Service
Live Project: Send email with details of Google Form
Course Customization Options
To request a customized training for this course, please contact us to arrange.
