Professional training – Process Automation & Low-Code

Google Apps Script

Google Apps Script in 6 focused hours: JavaScript Grundlagen für Apps Script, SpreadsheetApp und Tabellenautomatisierung and Gmail, Drive und Kalender per Skript – practical, with exercises and templates for your daily work.

Duration
6 hours, one session
Level
Intermediate
Format
Online or on-site
Language
German or English
Certificate
Certificate of attendance

Overview

“Google Apps Script” is a compact live course in the field of Process Automation & Low-Code. It centres on JavaScript Grundlagen für Apps Script, SpreadsheetApp und Tabellenautomatisierung and Gmail, Drive und Kalender per Skript – explained with realistic examples and deepened in exercises you can transfer straight to your daily work.

Repetitive tasks in business departments consume time that is needed elsewhere. RPA bots, cloud workflows and low-code platforms take over routine work, connect systems and make processes measurable. In our courses you learn Google Apps Script through concrete automation cases: from process understanding and building stable flows to error handling, operations and governance. You build your own solutions in a practice environment, weigh effort against benefit and receive templates for documentation and handover to operations. Delivered online or on site, at a fixed price per participant.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Focus areas of the course

JavaScript Grundlagen für Apps ScriptSpreadsheetApp und TabellenautomatisierungGmail, Drive und Kalender per SkriptTrigger und ZeitsteuerungWeb Apps mit HtmlServiceFehlerbehandlung und Deployment

Who is this course for?

  • Business users and citizen developers who want to automate routine work themselves
  • RPA developers and automation teams in business units and IT
  • Process owners, business analysts and organizational developers
  • IT leaders and governance owners responsible for platforms and operating models

What you will be able to do

  • You know the key topics of Google Apps Script – JavaScript Grundlagen für Apps Script, SpreadsheetApp und Tabellenautomatisierung, Gmail, Drive und Kalender per Skript, Trigger und Zeitsteuerung, Web Apps mit HtmlService and Fehlerbehandlung und Deployment – and can apply them in practice.
  • You assess processes and decide what is worth automating with Google Apps Script.
  • You build robust flows with error handling and traceable logging.
  • You operate solutions securely: credentials, roles, environments and monitoring.
  • You document your automation so others can understand and extend it.

Course outline

Module 1 Process understanding and getting started with Google Apps Script
  • Assessing which processes suit automation
  • Interface, building blocks and concepts of Google Apps Script
  • Building a first automation step by step
  • Connecting data sources, applications and connectors
Module 2 Focus areas: Google Apps Script
  • JavaScript Grundlagen für Apps Script
  • SpreadsheetApp und Tabellenautomatisierung
  • Gmail, Drive und Kalender per Skript
  • Trigger und Zeitsteuerung
  • Web Apps mit HtmlService
  • Fehlerbehandlung und Deployment
Module 3 Developing stable flows
  • Variables, loops, conditions and data structures
  • Error handling, retries and logging
  • Modularization and reuse
  • Testing and troubleshooting in Google Apps Script
Module 4 Operations, security and governance
  • Managing credentials, permissions and environments
  • Schedules, triggers and monitoring
  • Change management and versioning
  • Documentation and handover to operations
Module 5 Practice project and scaling
  • End-to-end project with Google Apps Script for your use case
  • Business case and metrics for automation
  • Avoiding typical mistakes when scaling
  • Roadmap for the next automations
Module 6 Transfer to your daily work
  • Exercise based on a realistic case
  • Typical mistakes and how to avoid them
  • Checklist and templates to take away
  • Open questions, outlook and resources for further learning

Prerequisites

Basic skills with Windows and office applications are enough for beginner courses. For advanced courses, first experience with the tool or programming logic is helpful. Basic knowledge of the topic is helpful.

Technical requirements

Laptop with a current browser; software, trial licenses or cloud access for the exercises are provided.

Dates & locations

For every location we suggest a date roughly four weeks ahead. Your preferred date is always possible.

  • Munich Fri, 11 December 2026 6 hrs Request
  • Salzburg Mon, 14 December 2026 6 hrs Request
  • Berlin Wed, 16 December 2026 6 hrs Request
  • Augsburg Wed, 16 December 2026 6 hrs Request
  • Hanover Tue, 15 December 2026 6 hrs Request
  • Bremen Wed, 16 December 2026 6 hrs Request
  • Stuttgart Wed, 16 December 2026 6 hrs Request
  • Kaiserslautern Mon, 14 December 2026 6 hrs Request
  • Online Thu, 10 December 2026 6 hrs Request

Frequently asked questions

Do I need to know how to code for Google Apps Script?

Not for beginner courses. Visual editors and wizards guide you through building. Logical thinking and process understanding matter more than programming skills. In advanced courses, expressions, scripts or code are introduced selectively and explained step by step.

Which processes suit Google Apps Script?

Rule-based, recurring workflows with digital inputs are a good fit, such as data transfers, approvals or reports. We show criteria and an assessment matrix you can use to rate effort, benefit and risk for your own processes.

How much does “Google Apps Script” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 6 hours of live training with a trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. For every location we suggest a date roughly four weeks ahead. In the request form you can always describe your preferred date or period in free text – we check availability and get back to you within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run the course exclusively for your team.

Can the course be tailored to our team?

Yes. Tailor-made courses cost approx. €4,500 more, depending on the topic and by arrangement. We agree content, examples and exercises with you in advance.

More courses in Process Automation & Low-Code

All 24 courses in Process Automation & Low-Code