Is the training Qualiopi certified?

Yes, Learni is a Qualiopi-certified training organization. This certification guarantees the quality of our courses and enables funding through OPCO and other mechanisms.

How can I fund my training?

Our courses are eligible for OPCO funding. Learni supports you through the funding process. A personalized quote is available upon request.

What are the prerequisites for this training?

The prerequisites for the Training Google Apps Script - Automate Google Workspace training are: Daily use of Google Workspace (Sheets, Docs, Drive) and basic knowledge of conditional logic. A preliminary interview validates your eligibility.

Is the training available in person?

Yes, the Training Google Apps Script - Automate Google Workspace training is available in remote. The format can be adapted to your needs (inter, intra, custom).

Training Google Apps Script - Automate Google Wo... | Learni

The story of Learni

Founded by passionate advocates of learning and innovation, Learni set out to make professional training accessible to everyone, everywhere in the world. Our team works in the largest cities such as Paris, Lyon, Marseille, and internationally, to support talents and organizations in their skills development.

Configure your training

Response within 24hNo commitment100% free

7 spots remaining for the next session

FormatParticipantsDateDetails

Which format do you prefer?

Methods, approaches, and teaching resources

The Training Google Apps Script - Automate Google Workspace training is delivered in-person or remotely (blended-learning, e-learning, virtual classroom, remote in-person). At Learni, a Qualiopi-certified training organization, each program is designed to maximize skills acquisition, regardless of the training mode chosen.

The trainer alternates between demonstrative, interrogative, and active methods (through practical exercises and/or real-world scenarios). This pedagogical approach ensures concrete and directly applicable learning in the workplace.

Teaching resources provided

To ensure the quality of the Training Google Apps Script - Automate Google Workspace training, Learni provides the following teaching resources:

Mac or PC computers, high-speed fiber internet, whiteboard or flipchart, video projector or interactive touchscreen (for remote sessions)
Training environments installed on workstations or accessible online
Course materials, practical exercises, and supplementary resources
Post-training access to materials and teaching resources

For in-house training at a location external to Learni, the client ensures and commits to having all necessary teaching materials (IT equipment, internet connection...) for the proper conduct of the training action in accordance with the prerequisites indicated in the communicated training program.

* contact us for remote feasibility** ratio varies depending on the training followed

Assessment methods

The assessment of skills acquired during the Training Google Apps Script - Automate Google Workspace training is carried out through:

During training: case studies, practical exercises, and professional scenarios
At the end of training: self-assessment questionnaire and skills evaluation by the trainer
After training: training completion certificate detailing acquired skills

Training accessibility

Learni is committed to the accessibility of its professional training programs. All our training programs are accessible to people with disabilities. Our teams are available to adapt teaching methods to your specific needs. Do not hesitate to contact us for any accommodation request.

Training objectives

Master the fundamentals of Google Apps Script for professional automations

Develop simple scripts connected to Google Sheets and Docs

Implement triggers and events for recurring business tasks

Design custom functions optimizing collaborative workflows

Deploy certified script applications in Google Workspace

Optimize manual processes via Google libraries and APIs

Training program

Module 1Google Apps Script Fundamentals: Environment and First Scripts (Editor, JavaScript Syntax)

Discovery of the Google Apps Script editor integrated into Workspace, creation of a first script project to automate a simple task in Sheets, hands-on with adapted JavaScript syntax, practical exercises on basic functions like getValue and setValue, immediate testing with deployment in test mode, production of a deliverable script to automatically sort data, personalized feedback from the trainer to consolidate skills from the first day.

Module 2Google Apps Script Data Manipulation: Sheets and Dynamic Data (Formulas, Ranges, Loops)

In-depth exploration of Sheets services via Apps Script, manipulation of cell ranges with getRange and setValues, integration of loops and conditions to process real company datasets, exercises on CSV data import and automated report generation, creation of a complete script to analyze monthly sales, interactive debugging with Logger and console, delivery of a reusable template to immediately boost your daily productivity.

Module 3Google Apps Script Events: Triggers and Reactive Automations (onEdit, onFormSubmit)

Configuration of time-based and event-driven triggers for instant reactions in Workspace, implementation of onEdit to validate entries in real-time in Sheets, connection to Forms to automatically process submissions, practical cases on email notifications via GmailApp, development of a collaborative approval workflow, real-condition tests with multi-user simulations, obtaining a ready-to-deploy script avoiding hours of weekly manual work.

Module 4Google Apps Script Integrations: Docs, Drive, and External APIs (Advanced Services)

Multi-service connections with Docs to generate templated documents, Drive file management via scripts for automatic organization, simple API calls with UrlFetchApp to enrich external data, exercises on merging Sheets-Docs reports, creation of a personalized interactive dashboard, performance optimization with batch operations, production of an ongoing project integrating all tools, demonstrating concrete business value for your team.

Module 5Google Apps Script Deployment: Libraries, Security, and Production (Web Apps, Add-ons)

Preparation for professional deployment with permission management and OAuth, creation of web apps accessible via shared links, integration of community libraries for extended features, securing sensitive scripts, final exercises on a complete Sheets add-on, code review and final optimization, delivery of a certifying portfolio of deployable scripts, support for immediate production rollout in your company.