Google Apps Script: Beginner to Advanced Training Course
Google Apps Script is a JavaScript framework for light-weight development in a G Suite environment. Using Google Apps Script, users can leverage the power of Google products by automating tasks, connecting Google products to data sources, and more.
This instructor-led, live training (online or onsite) is aimed at web developers who wish to use Google Apps Script to develop in a G Suite environment.
By the end of this training, participants will be able to:
- Develop web applications with Google Apps Script.
- Build add-ons to extend Google products, such as Gmail.
- Perform system administration tasks.
- Connect to a data source from a Google product.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction
Google Apps Script Overview
- What is Google Apps Script?
- Google App Scripts features
Preparing the Development Environment
- Setting up Google Apps Script
Google Spreadsheet
- Writing a Google script
- Scripting UI options
- Accessing data sources
- Working with Bootstrap
- Using jQuery
Stand Alone Scripts
- Designing interfaces
- Adding scripts
Google Drive
- Getting data
- Creating and moving content
Gmail
- Working with emails and chat threads
- Automating tasks
Google Calendar
- Importing data
- Automating tasks
Summary and Conclusion
Requirements
- JavaScript experience
Audience
- Web Developers
Open Training Courses require 5+ participants.
Google Apps Script: Beginner to Advanced Training Course - Booking
Google Apps Script: Beginner to Advanced Training Course - Enquiry
Testimonials (5)
Learned a whole lot about the topic
Zsolt Langviser - Accenture Industrial SS
Course - NestJS: Beginner to Advanced
The training has good content and easy to follow
David Phetole Leshabela - Vodacom SA
Course - React with Next.js
The breadth of the topis covered was quite a bit and the trainer tried to do justice to that.
Lakshmipriya Sivakumar - Deque Systems Inc
Course - Spring Boot, React, and Redux
trainer very knowledgeable clear classes explains the importance of learn the topic gives enough background on topic
Li Fang Bren Ong - DBS Bank Limited
Course - Ant Design
Although I had a pretty good knowledge of the subject already, I found out a lot useful stuff during the course.
Stefan-Lucian Bucur - Cegeka NV
Course - Building Interactive Applications with React, Redux and GraphQL
Upcoming Courses
Related Courses
Ant Design
7 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at developers who wish to use Ant Design to enhance the User Experience for their React application.
By the end of this training, participants will be able to implement Ant Design's React components to develop beautiful enterprise-class web applications.
Aurelia Javascript Framework
14 HoursThis instructor-led, live training in Slovenia (onsite or remote) is aimed at developers who wish to use Aurelia to create and build front-end applications.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start developing front-end applications.
- Two-way bind HTML form controls using the DOM-batch mechanism.
- Integrate Aurelia to any third-party library or framework such as jQuery.
Gatsby: Beginner to Advanced
14 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at web developers who wish to use Gatsby to build front-end web applications.
By the end of this training, participants will be able to:
- Use Gatsby to build a web application.
- Generate PWAs (Progressive Web Applications) for fast loading speeds.
- Pull data from different data sources with GraphQL.
- Deploy Gatsby web applications to on-premises services or cloud services.
Building Web Apps using the MEAN stack
35 HoursCourse Objective:
MEAN stack is a full-stack JavaScript solution that helps you write scalable, robust, and maintainable web applications quickly and easily using MongoDB, express, AngularJS, and Node.js.
By the end of this hands-on intensive training course, the students will be able to:
- Store the data in NoSQL, document-oriented MongoDB database that brings performance and scalability.
- Use Node.js, the server-side platform built on Google V8’s runtime for building fast, scalable network applications.
- Use Express, a simple yet powerful web application development HTTP server framework built on top of Node.js.
- Use AngularJS framework that offers declarative, two-way data binding for web applications.
- Take advantage of the ‘full-stack JavaScript’ paradigm i.e. store documents in JSON-like format in MongoDB, author JSON queries in Node.js/Express.js, and forward these JSON documents back to an Angular-based frontend.
- Get acquainted with the latest web application development trends in the IT industry.
NestJS: Beginner to Advanced
14 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at web developers who wish to use NestJS to create easily maintainable and scalable web applications.
By the end of this training, participants will be able to:
- Build a back-end application using NestJS.
- Test back-end services with Postman.
- Implement authorization and authentication in back-end applications.
- Deploy back-end applications.
Next.js 14 Advanced Development
21 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at intermediate-level to advanced-level web developers and technical architects who wish to explore the advancements of Next.js 14 and gain the knowledge to build cutting-edge web applications.
By the end of this training, participants will be able to:
- Leverage the full potential of Next.js 14 for building complex applications.
- Utilize the latest features such as Middleware, React Server Components, and Edge Functions.
- Implement best practices for performance, scalability, and SEO.
- Troubleshoot common issues in Next.js applications effectively.
Node.js & Express.js Basics, working with PM2 & WebStorm
21 HoursAudience:
Typically, a Project Manager, Aanalyst, Developer or anyone who needs:
- Explore the node.js framework and architecture
- Explore Express.js as a solution for web development
- Assess Node.js & Express.js as solutions for web development
- Advantages and disadvantages over Java
- To have a good understanding of an application’s structure and deployment mechanisms
- To carry out Installation / production environment / architecture tasks and configuration
- To be able to assess code quality, perform debugging, monitoring
- To implement advanced production like Logging
Objectives:
- Explore the advantages and characteristics of Node.js (In comparison with Java)
- Explore Express.js: Architecture, administration (In comparison with Java EE)
- Explore and apprehend all the features and functionalities of the webstorm platform for Node.js
- Explore and apprehend all the features and functionalities of the pm2 production process manager
- Explore and apprehend advanced logging with Winston.js
Description:
The course is normally 3 days (7 hours a day) and has a heavy emphasis on hands on practice. Most of the concepts are discovered through code readings, exercises and labs.
Nuxt.js and Vue.js
14 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at web developers who wish to use Vue JS and Nuxt.js for end-to-end web development.
By the end of this training, participants will be able to:
- Influence a single-page application using Nuxt.js configuration.
- Implement server side rendering for optimizing SEO.
- Generate a static site from VueJS and Nuxt.js code.
Next.js 14 - Advanced
21 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at advanced-level developers who wish to master the latest features in Next.js 14, optimize performance, and implement modern React techniques.
By the end of this training, participants will be able to:
- Implement advanced React hooks and concurrent features.
- Understand and utilize Next.js routing strategies effectively.
- Leverage Server Components, Server Actions, and hybrid rendering approaches.
- Optimize data fetching, caching, and incremental static regeneration.
- Use Next.js as a backend solution with Edge Functions and Edge Runtime.
- Manage state using React Context, Redux, and atomic state libraries.
- Optimize application performance for Web Core Vitals.
- Test, monitor, and deploy Next.js applications efficiently.
Building Interactive Applications with React, Redux and GraphQL
28 HoursIn this instructor-led, live training in Slovenia, participants will learn how to build React applications using Flux and GraphQL. The course covers installation, setup, integration, testing, deployment and best practices as it walks participants through the creation of a series of sample applications that demonstrate how to add additional levels of complexity and "coolness" to an application using the most advanced toolkits and techniques.
Developing applications with React requires a different kind of thinking, compared to what some developers are accustomed to, especially when coming from the mindset of other MVC frameworks such as AngularJS and Bootstrap.
This training covers the fundamentals behind of the technologies used each step of the way so that participants are not only able to build a functional application, but also understand why a particular approach is used. This lays the groundwork for thinking independently and creatively about the design and the desired results for building their own applications in the future.
React with Next.js
14 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at web developers who wish to use Next.js to create React applications.
By the end of this training, participants will be able to:
- Develop server-side web applications and static sites in Next.js.
- Handle and store data with MongoDB.
- Secure a web application with AuthO authentication.
Spring Boot, React, and Redux
14 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at web developers who wish to build functional front-end and back-end web applications with Spring Boot, React, and Redux.
By the end of this training, participants will be able to:
- Build a front-end application with React and Redux.
- Create RESTful APIs with Spring Boot.
- Secure web services with Spring security and JWT web tokens.
Svelte
14 HoursThis instructor-led, live training in Slovenia (remote or onsite) is aimed at developers who wish to use Svelte to develop web applications that are faster than React applications and are simpler to construct.
By the end of this training, participants will be able to:
- Start writing a web app quickly and with minimal overhead.
- Write web apps that handle state without relying on external dependencies or plugins.
- Use features such as scope styling to eliminate the need for extra extensions and custom syntax for CSS.
- Build standalone Svelte components and integrate them into the codebase of an existing React project.
Advanced Svelte JS
14 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at intermediate-level developers who wish to learn advanced concepts and features of Svelte for developing web applications.
By the end of this training, participants will be able to:
- Use advanced techniques for developing Svelte applications.
- Develop web applications with the Svelte framework.
- Quickly prototype with TailwindCSS and DaisyUI.
Managing Vue JS State with Vuex
7 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at developers and programmers who wish to create, manage, and update Vue applications using Vuex.
By the end of this training, participants will be able to use Vuex for building adaptable and maintainable single-page applications.