Visão geral dos codelabs de noções básicas do Apps Script
Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Se você não conhece o Apps Script, aprenda o básico com a playlist de codelabs Fundamentos do Apps Script com o Google Sheets.
Essa playlist consiste em um conjunto de codelabs sequenciais. Cada codelab é um tutorial
guiado que oferece instruções detalhadas sobre como criar
um aplicativo de script de exemplo. Se precisar fazer uma pausa, você pode continuar o codelab depois, de onde parou.
Os codelabs nesta playlist se concentram no uso do Apps Script com as Planilhas Google.
O serviço de planilhas é
um dos maiores e mais usados serviços integrados do Apps Script, e
esta playlist apresenta o conteúdo e o uso dele.
A playlist aborda muitos conceitos do Apps Script, incluindo:
Usando o editor no navegador do Apps Script.
Criar e editar macros das Planilhas Google.
Como criar funções personalizadas do Planilhas Google.
Importar dados para o Planilhas Google.
Adicionar, editar e formatar dados das Planilhas Google com o Apps Script.
Criar gráficos e exportá-los para as Apresentações Google.
Buscando dados de serviços de API de terceiros.
Criar menus e caixas de diálogo nas Planilhas Google.
Antes de começar
Não é necessário ter conhecimento prévio sobre o Apps Script para concluir esta
playlist. No entanto, a playlist pressupõe que você tenha alguma familiaridade básica com as Planilhas Google e a notação A1.
Também é útil ter um conhecimento básico de JavaScript, em que o
Apps Script se baseia. Se você não tem experiência com JavaScript, o Codecademy oferece vários cursos de JavaScript.
Observação: o Google não desenvolveu esses cursos.
Todas as partes desses codelabs são realizadas no navegador. Portanto, você não
precisa de nenhum software especial para concluí-los.
Primeiros passos
Você pode começar a playlist com os links abaixo. Cada codelab oferece instruções detalhadas para guiar você pela lição. Quando terminar um codelab, passe para o próximo da lista. Comece com o primeiro codelab, Fundamentos do Apps Script com o Planilhas Google nº 1: macros e funções personalizadas.
[null,null,["Última atualização 2025-08-31 UTC."],[[["\u003cp\u003eThis script automatically creates email drafts in Gmail to reply to Google Forms submissions, particularly useful for course feedback or similar scenarios.\u003c/p\u003e\n"],["\u003cp\u003eIt uses Apps Script services like the Script service to set up triggers, Spreadsheet service to handle data, and Gmail service to create drafts.\u003c/p\u003e\n"],["\u003cp\u003eBy making a copy of the provided spreadsheet and enabling auto draft replies through a custom menu, you can automate feedback responses.\u003c/p\u003e\n"],["\u003cp\u003eUpon form submission, the script generates a draft email with the feedback content addressed to the submitter, allowing for review before sending.\u003c/p\u003e\n"]]],["The \"Fundamentals of Apps Script with Google Sheets\" playlist offers guided tutorials (codelabs) for learning Apps Script basics. These codelabs teach you to use the in-browser editor, create macros and custom functions, manage spreadsheet data, format information, create charts, fetch API data, and add menus/dialogs. Each codelab provides step-by-step instructions, building upon previous lessons and are to be completed in order. A basic familiarity with Google Sheets and A1 notation is assumed.\n"],null,["# Apps Script fundamentals codelabs overview\n\nIf you're new to Apps Script, you can learn the basics using our\n**Fundamentals of Apps Script with Google Sheets** codelab playlist.\n\nThis playlist consists of a set of sequential *codelabs*. Each codelab is a\nguided tutorial that gives you step-by-step instructions on how to build\nan example script application. If you need to\ntake a break, you can pick up the codelab later, right where you left off.\n\nThe codelabs in this playlist focus on using Apps Script with Google Sheets.\nThe [Spreadsheet service](/apps-script/reference/spreadsheet) is\none of the largest and most popular built-in services in Apps Script, and\nthis playlist familiarizes you with its content and use.\n\nThe playlist covers many Apps Script concepts, including the following:\n\n- Using the Apps Script in-browser editor.\n- Creating and editing Google Sheets macros.\n- Creating Google Sheets custom functions.\n- Importing data into Google Sheets.\n- Adding, editing, and formatting Google Sheets data with Apps Script.\n- Creating charts and exporting them to Google Slides.\n- Fetching data from third-party API services.\n- Creating menus and dialog windows in Google Sheets.\n\nBefore you start\n----------------\n\nYou don't need any previous knowledge about Apps Script to complete this\nplaylist. However, the playlist does assume you have some basic\nfamiliarity with Google Sheets and\n[A1 notation](/sheets/api/guides/concepts#a1_notation).\n\nIt's also helpful to have a basic understanding of JavaScript, upon which\nApps Script is based. If you're new to JavaScript, Codecademy offers several [JavaScript courses](https://www.codecademy.com/catalog/language/javascript).\n(Note: Google did not develop these courses.)\n\nEvery part of these codelabs is conducted inside your browser, so you don't\nneed any special software to finish them.\n\nGetting started\n---------------\n\nYou can start the playlist with the links below. Each codelab provides\nstep-by-step instructions to guide you through the lesson. Once you finish a\ncodelab, you can move on to the next one in the list. Start with the first\ncodelab,\n\"*Fundamentals of Apps Script with Google Sheets #1: Macros \\& Custom\nFunctions*\".\n| **Note:** Make sure to complete the codelabs in order. As you progress through the playlist, you'll use what you learn in each codelab to complete the ones that follow.\n\nHere's the **Apps Script Fundamentals** playlist:\n\n1. [Fundamentals of Apps Script with Google Sheets #1: Macros \\& Custom Functions](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-1)\n2. [Fundamentals of Apps Script with Google Sheets #2: Spreadsheets, Sheets, and Ranges](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-2)\n3. [Fundamentals of Apps Script with Google Sheets #3: Working with Data](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-3)\n4. [Fundamentals of Apps Script with Google Sheets #4: Data Formatting](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-4)\n5. [Fundamentals of Apps Script with Google Sheets #5: Chart and Present Data in Slides](https://codelabs.developers.google.com/codelabs/apps-script-fundamentals-5)"]]
