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 Sheets Expert - Automate Your Processes in 5 Days training are: Mastery of advanced formulas (QUERY, IMPORTRANGE), basic JavaScript knowledge, experience managing large databases.. A preliminary interview validates your eligibility.

Is the training available in person?

Yes, the Training Google Sheets Expert - Automate Your Processes in 5 Days training is available in in-person. The format can be adapted to your needs (inter, intra, custom).

Training Google Sheets Expert - Automate Your Pr... | 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

9 spots remaining for the next session

FormatParticipantsDateDetails

Which format do you prefer?

Methods, approaches, and teaching resources

The Training Google Sheets Expert - Automate Your Processes in 5 Days 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 Sheets Expert - Automate Your Processes in 5 Days 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 Sheets Expert - Automate Your Processes in 5 Days 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

Develop custom Apps Script scripts to automate repetitive tasks.

Create advanced custom functions integrating external APIs.

Build interactive dashboards with dynamic charts and triggers.

Optimize performance of massive sheets using SQL-like queries.

Integrate Google Sheets with Google Workspace and third-party tools for seamless workflows.

Debug and secure complex Sheets applications in production.

Complete a final deliverable project deployable in the enterprise.

Training program

Module 1Apps Script Fundamentals: scripts and triggers (Google Sheets, Apps Script editor, events).

Dive into the Apps Script editor, create your first scripts to manipulate data, formulas, and cells in Google Sheets, set up onEdit and time-driven triggers to automate cleanups and updates, test on real cases like automated imports, produce a functional deployable script that boosts your productivity from day one.

Module 2Custom Functions: advanced formulas (Apps Script, QUERY-like, libraries).

Design powerful custom user functions in Apps Script, integrate complex SQL-like queries in Google Sheets, manipulate massive arrays with map, filter, and reduce, develop a reusable library for statistical analyses, apply to real enterprise datasets, leave with custom formulas that transform your spreadsheets into professional analytics tools.

Module 3API Integrations: external connections (Sheets API, UrlFetch, OAuth).

Master API calls via UrlFetchApp in Google Sheets, connect to Google Drive, Gmail, and third-party services like Salesforce, handle OAuth2 authentications for secure imports, build automated data pipelines, simulate real flows with practical exercises, obtain ready-to-use connectors that eliminate manual copy-paste and save hours per week.

Module 4Advanced Dashboards: UI and performance (Data Studio-like, Sparklines, Apps Script UI).

Build interactive dashboards in Google Sheets with HTML sidebars, dynamic charts, and custom slicers via Apps Script, optimize loading for 100k+ rows, integrate advanced Sparklines and heatmaps, test on concrete business cases like sales reporting, deliver a professional dashboard that impresses management and accelerates decisions.

Module 5Projects and Optimization: professional deployment (debugging, quotas, security).

Complete a capstone project integrating all tools, debug with Logger and Stackdriver, manage quotas and errors for scalability, secure access via Permissions and add-ons, deploy as a public extension, optimize code for maximum performance, leave with a concrete deployable portfolio that showcases your expertise and transforms your business processes.