Visão Geral

O curso Developing Custom Functions and Add-ons for Google Workspace foi desenvolvido para profissionais que desejam criar soluções personalizadas dentro dos aplicativos Google, como Sheets, Docs, Gmail e Forms, utilizando Google Apps Script.
Os participantes aprenderão a desenvolver funções customizadas, construir complementos (add-ons) e integrar APIs do Google Workspace para automatizar fluxos de trabalho e expandir funcionalidades nativas.

Objetivo

Após realizar este curso Developing Custom Functions and Add-ons for Google Workspace, você será capaz de:

• Criar e implantar funções personalizadas no Google Sheets usando Apps Script.
• Desenvolver e publicar add-ons para Google Workspace.
• Utilizar APIs do Google Workspace e serviços avançados.
• Automatizar tarefas e integrar serviços externos com Apps Script.

Publico Alvo

•  
• Desenvolvedores que desejam criar extensões e automações para o Google Workspace.
• Profissionais de TI e administradores de sistemas que buscam aumentar a produtividade com scripts personalizados.
• Analistas de dados e consultores que usam o Google Sheets e outros aplicativos Google em seu dia a dia.
•  

Pre-Requisitos

• Conhecimento básico de JavaScript.
• Noções gerais sobre Google Workspace (Gmail, Docs, Sheets, Forms, Drive).
• Conta Google ativa para testes e desenvolvimento.

Materiais

Conteúdo Programatico

Module 1: Introduction to Google Apps Script

1. Overview of Google Apps Script architecture
2. Understanding project types (bound and standalone scripts)
3. Setting up the Apps Script development environment
4. Exploring triggers and permissions

Module 2: Creating Custom Functions

1. Writing simple custom functions for Google Sheets
2. Handling inputs and outputs
3. Using built-in services (SpreadsheetApp, Logger, Utilities)
4. Testing and debugging custom functions

Module 3: Working with Google Workspace Services

1. Interacting with Google Sheets, Docs, and Drive via Apps Script
2. Automating Gmail and Calendar tasks
3. Reading and writing data between services
4. Using advanced services and APIs

Module 4: Developing Add-ons for Google Workspace

1. Understanding add-on structure and manifest files
2. Creating custom menus, dialogs, and sidebars
3. Using HTML Service to build user interfaces
4. Packaging and testing add-ons

Module 5: Publishing and Deploying Add-ons

1. Publishing add-ons privately within a domain
2. Publishing to the Google Workspace Marketplace
3. Version control and script deployment
4. Managing OAuth scopes and permissions

Module 6: Integrating External APIs

1. Connecting Apps Script with third-party APIs
2. Handling authentication and HTTP requests
3. Using Cloud APIs and Google Cloud Console
4. Building automation between Google Workspace and external systems

Module 7: Best Practices and Optimization

1. Writing efficient and maintainable code
2. Error handling and debugging techniques
3. Managing quotas and performance limits
4. Security and compliance considerations

Module 8: Capstone Project

1. Designing a real-world automation using Apps Script
2. Developing and publishing a working add-on
3. Testing and demonstration of final project