Visão Geral

Este Curso Google Apps Script Fundamentals and Advanced cobre desde os fundamentos até os recursos avançados do Google Apps Script, capacitando os participantes a criar automações, integrações, aplicativos web, add-ons e soluções sofisticadas dentro do ecossistema Google Workspace.
O curso aborda manipulação de dados em Sheets, automação de Gmail e Drive, criação de formulários dinâmicos, triggers, serviços avançados, integração com APIs externas, desenvolvimento de Web Apps e Add-ons profissionais.

Objetivo

Após realizar este curso Google Apps Script Fundamentals and Advanced, você será capaz de:

• Desenvolver automações funcionais usando Google Apps Script
• Criar, manipular e processar dados em Google Sheets via script
• Integrar Gmail, Drive, Docs, Forms e Calendar
• Criar funções personalizadas e automações agendadas
• Criar Web Apps completos com HTML, CSS e JS integrados
• Consumir APIs externas com autenticação e segurança
• Criar Add-ons profissionais para Google Workspace
• Aplicar boas práticas de scripting, logging e monitoramento

Publico Alvo

• Analistas de TI
• Desenvolvedores Full-Stack ou Front-End
• Administradores de Google Workspace
• Analistas de processos e automação
• Profissionais de suporte técnico
• Equipes de operações e produtividade
• Consultores de automação corporativa

Pre-Requisitos

• Noções básicas de lógica de programação
• Conhecimentos básicos de JavaScript
• Familiaridade com Google Workspace (Sheets, Drive, Docs, Gmail, Forms)

Materiais

Conteúdo Programatico

Module 1 — Fundamentals of Google Apps Script

1. What is Google Apps Script
2. Script Editor overview
3. Containers and standalone scripts
4. Permissions and scopes introduction
5. Apps Script ecosystem

Module 2 — JavaScript Essentials (Apps Script-focused)

1. Variables, scopes, functions
2. Arrays, objects, loops
3. JSON manipulation
4. ES5 vs ES6 support
5. Practical exercises

Module 3 — Sheets Automation (Fundamentals)

1. Reading and writing data
2. Working with ranges
3. Custom functions
4. Basic formatting and formulas automation
5. Data validation automation

Module 4 — Gmail Automation

1. Reading and filtering emails
2. Sending automated messages
3. Managing labels
4. Email parsing and notifications

Module 5 — Drive Automation

1. Creating folders
2. Generating files dynamically
3. Managing permissions
4. File search and organization automation

Module 6 — Forms and Docs Integration

1. Creating and editing forms via script
2. Handling form responses
3. Generating documents from templates
4. Mail merge automation with Docs

Module 7 — Triggers and Automation Workflows

1. Simple triggers
2. Installable triggers
3. Time-based triggers
4. Event-based triggers
5. Error handling in scheduled tasks

ADVANCED SECTION

Module 8 — Advanced Sheets Operations

1. Advanced Services (Sheets API)
2. Batch updates
3. Large dataset optimization
4. Data pipelines with Sheets

Module 9 — Web Apps Development

1. HTML Service
2. Creating UI with HTML/CSS/JS
3. GET and POST request handling
4. Deploying Web Apps with permissions
5. Form submissions and APIs in Web Apps

Module 10 — Integrating Google Calendar

1. Creating events programmatically
2. Creating agenda automation
3. Event updates and synchronization
4. Calendar Advanced Services

Module 11 — APIs, Fetch and External Integrations

1. Using UrlFetchApp
2. REST API consumption
3. OAuth workflows
4. Integrating with CRM/ERP external systems
5. Handling responses and errors

Module 12 — Advanced Services and Libraries

1. Using built-in advanced services (Drive, Sheets, Admin, BigQuery)
2. Creating and publishing custom libraries
3. Versioning and dependency management

Module 13 — Add-ons Development

1. Add-ons architecture
2. UI best practices
3. Publishing and deployment
4. Marketplace requirements
5. Authorization scopes and security

Module 14 — Error Logging, Monitoring and Best Practices

1. Logging and debugging
2. Stackdriver / Cloud Logging
3. Exception handling
4. Performance optimization
5. Secure coding guidelines

Module 15 — Administrator Tools and Workspace Management

1. Managing API scopes as an admin
2. Automation governance
3. Auditing and deployment control
4. Policy and security considerations

Module 16 — Final Project (Hands-on)

1. Building a complete automation solution integrating:
2. Google Sheets
3. Gmail
4. Drive
5. Calendar
6. Forms
7. Implementing a Web App interface
8. Documentation and deployment
9. Final presentation