Google Apps Script Complete Course New IDE 100+ Examples

Master modern JavaScript fundamentals for Google Apps Script, including variables, functions (arrow format), loops, and json stringify and json parse, using date, math, the online editor, and built-in libraries.

Master JavaScript basics in Google Apps Script by declaring variables with const, let, and var, using strings, logging with the logger, and passing values to functions.

Learn how JavaScript objects and arrays work in Google Apps Script, using dot and bracket notation, and apply array methods like push, pop, shift, unshift, reverse, sort, document app examples.

Explore loops and conditions in JavaScript within Google Apps Script, mastering for and while loops, array iteration with for each, and how array and object memory share references.

Explore built-in JavaScript methods in Google Apps Script, including date and math objects, random number generation, and stringify to convert objects to strings for data handling.

Explore the Google Sheets service in Apps Script, managing spreadsheets, ranges, sheets, and macros. Use bound and standalone scripts, build UI menus, and debug with a logging system.

Create a bound script for a Google sheet, record and edit macros, and customize cell formatting and values through the macro code using the SpreadsheetApp class.

Explore how to customize spreadsheet services with Google Apps Script using SpreadsheetApp, access the active spreadsheet, and log its URL, ID, and name; learn to use macros to generate scripts.

Select the active sheet, fetch its name and data range, and log values while iterating to build and test custom functions in Google Apps Script for Sheets.

Explore how to select and update sheets with Google Apps Script, using bound and standalone scripts, open by id or URL, get sheet names, and handle permissions.

Learn to open a spreadsheet by id, check for an existing sheet, and insert or activate a new sheet with a chosen name.

Open a spreadsheet by ID, access the first sheet, and loop through 50 rows to set alternating background colors across the A to E range, using a checkerboard pattern.

Learn to select a range in Google Apps Script, retrieve values with get values, and update cells by setting values and background colors using 2D arrays and row/column ranges.

Explore the Google Apps Script editor, read execution logs, and use go to definition, references, and symbols to debug with breakpoints, the debugger, and the command palette.

Select data from a GSuite sheet, determine last row and last column, and retrieve the full data range and values, including handling blank cells.

Learn to retrieve the active selection and range, access the active sheet, and get values in both standalone and bound Google Apps Script.

Learn to copy the user-selected range in a bound Google Apps Script into a brand new sheet, creating or updating sheets and pasting values while managing range dimensions.

Build a bound spreadsheet script that adds a custom menu with items and a submenu, activated by onOpen via the ui object to run functions.

Create a custom log in a log sheet and copy selected content via an advanced menu. Use on open to append to the next available row.

Learn to create and manage spreadsheet ui alerts and prompts with Google Apps Script, using on open triggers, a custom menu, and log entries.

Show a Google Apps Script sidebar by creating HTML output from a file or template and using the evaluate method, while persisting a counter with the document properties on open.

Learn how to append and insert rows in Google Sheets using Apps Script, update content with get last row, set values, and manage a test spreadsheet.

Learn to build a prepend function in Google Apps Script that inserts a top row from an array, handling multi-dimensional values and cloning to avoid mutation.

Discover how to run Google Apps Script custom functions directly in sheets, using A1 notation, active ranges, and distinct names from built-ins to build and apply formulas.

Learn to add notes and comments to sheet cells using Google Apps Script through a UI menu and prompts. Add comments to the active cell and handle overwriting.

Learn to use spreadsheet services with Google Apps Script to manipulate sheets, ranges, and UI components, explore dot-methods, open by ID or URL, and build your own functionality.

Explore the Google Docs services in Google Apps Script. Create and edit documents with the DocumentApp class, manipulating body content, tables, images, and text via the UI menu.

Explore the document service and DocumentApp to create a bound script in Google Docs, access the active document, and append a hello world paragraph with page breaks.

Create and manipulate a standalone Google Apps Script to open a document by id or URL, append content, and generate new documents with paragraphs and page breaks.

Learn to access paragraph content in Google Apps Script using DocumentApp. Open by ID, get the body and paragraphs, loop through them, and set text, headings, and text alignment.

Explore interacting with document paragraphs using Apps Script. Learn to select, update, append, and navigate paragraphs and list items, including getting text, siblings, and inserting horizontal rules.

Open a document by its id with DocumentApp, access the body, and edit as text in rich text mode. Insert, format, and log text using indices and offsets.

Apply style attributes in Google Apps Script by selecting a doc, reading body paragraphs, and updating font size, foreground, and background colors with style objects.

Learn to replace text in a document body with Google Apps Script using replaceText and regex patterns. Handle case-insensitive matches and apply foreground and background colors to found text.

Learn to manipulate Google Docs with a bound script using DocumentApp to append list items by list ID, retrieve text, and loop to create multiple items.

Create a lorem ipsum template doc and copy its content into another document with a script. Retrieve the source and target IDs, clear the active document, then append the content.

Create a bound script to append a table to the document, using a multi-dimensional array and spreadsheet data via spreadsheet app.

Create a custom UI menu for a bound Google Docs script with DocumentApp, binding items to functions and triggering on open, then use alerts and prompts to handle user responses.

Create a custom menu in Google Apps Script on open, insert bold lorem ipsum from a template at the cursor, using DocumentApp and cursor checks.

Add a highlighter tool to the UI menu to prompt for a term, search the document body, and highlight all matching words with a colored background and white text.

Learn to add modal and modal less dialogs to the docs UI with showModalDialog, create an onOpen menu, and build HTML content via the HTML service.

Add side one and side two functions to show the sidebar in Google Apps Script, render HTML from a popup file, and reuse same HTML for the sidebar and modal.

Learn to insert images into a bound Google Docs document using Apps Script, fetch images from the web as blobs, and insert them at the cursor or start.

Explore the document app in Google Apps Script, comparing bound and standalone scripts. Learn to access the document body, get text, set attributes, append content, and connect Google Sheets data.

Explore the DriveApp service in Google Drive to manage files, folders, IDs, and permissions with Apps Script, and build mini projects that list folders, search drive, and integrate with spreadsheets.

Explore how the Google Apps Script drive app service lists drive files with getFiles, iterates with a loop, and logs file names. Learn about permissions and unverified app warnings.

Fetch files from a specific folder with DriveApp in Google Apps Script by folder ID. List the folder contents as objects and update your script to search within that folder.

Learn how to create files and folders in Google Drive with Apps Script using DriveApp, including file names, HTML content, mime types, and folder by ID with required permissions.

Master drive details with Apps Script: fetch storage used and limit, get files by id, get folders by name, and log results for drive one and drive two.

Leverage Google Apps Script with the Drive app to search files by name, move matches to trash, and restore recently trashed items based on last updated times.

Explore Google Drive file permissions and sharing options, including editors, viewers, owners, and anyone with the link, and learn to list and update these permissions with Apps Script.

Automate file conversion in Google Apps Script by turning html and doc files into pdfs, saving them in a new pdf folder, and retrieving their urls.

Retrieve details of files in a Drive folder, loop through items, collect url, size, download URL, and id, then create a spreadsheet with a file info sheet and append rows.

Learn how to search Google Drive from Apps Script, return matching file objects with id, url, size, owner, and mime type, and optionally search inside a specific folder.

Create a bound script in a spreadsheet that prompts for search term, searches Drive for files with titles containing the term, and writes results to sheet using a UI menu.

Explore the DriveApp class to manage drive files and folders, search by query terms, and log results into spreadsheets with methods and examples for reporting.

Explore Gmail app service and mail service in Google Apps Script to send emails, compose html templates, attach files, manage labels and threads, and search messages.

Learn to send emails with Google Apps Script using the mail and Gmail app services. Build functions, supply to, subject, and body, and manage permissions for sending.

Learn to send emails with the mail service using sendEmail, manage quotas, obtain the active user email with session, craft html bodies, and attach drive files via advanced options.

Master the Gmail app service to send emails, create and manage drafts, and attach drive files using session data and html content.

Fetch inbox threads with GmailApp, count unread messages, and inspect threads and messages. Learn to reply to threads and individual messages, including HTML replies.

Learn to send emails from a template using Google Apps Script, leveraging the HTML service to generate and send HTML bodies from a file, with replacements via regular expressions.

Transform a Google doc into an HTML email template, fetch and authorize the HTML, dynamically replace content, and send the updated HTML via Gmail.

Read a recipient spreadsheet, personalize an html email template with first name, last name, title, and message, and send emails via Google Apps Script. Update the spreadsheet with sent status.

Automate Gmail message starring with Apps Script by fetching inbox threads, iterating messages, and toggling stars on messages, not threads, based on subject keywords like alert.

Learn to create and manage Gmail labels with Google Apps Script, including creating labels, retrieving by name, applying labels to inbox threads, and removing labels when needed.

Access chat threads in the GmailApp class and retrieve chats and messages. Iterate with for each, log thread objects, count messages, and set start and max to control retrieved chats.

Master GmailApp search to query your inbox with parameters, start and max positions, and attachment filters, then examine threads and messages and log content and labels.

Explore how to fetch and process Gmail attachments with the GmailAttachment class using Apps Script. Retrieve attachments from threads, inspect content types, convert to blobs, and save PDFs to Drive.

Discover the Gmail app service in Google Apps Script, accessing threads, messages, labels, and drafts. Create drafts, apply labels, and connect with the spreadsheet and drive services.

Explore the Google Apps Script calendar service to access and modify calendars, manage events and guests, set recurrences, and connect with other Google services across default and additional calendars.

Learn to use the calendar service in Google Apps Script by creating a standalone script, listing calendars, and accessing names, IDs, and today’s events.

Learn to retrieve owned and all calendars, search by name or id, and access calendar details and settings using Google Apps Script, including default calendars and ids.

Create a brand new calendar, update its name, hex color, and description, set its hidden status, and finally delete the calendar.

Access the Google Apps Script calendar event class by selecting the default calendar, retrieving events, and updating properties such as title, color, time, location, description, visibility, and guest permissions.

Create and update calendar events using the calendar app class, from description-based to all-day and multi-day events, with start/end times, colors, and guest invites.

Learn to create events in Google Calendar with Apps Script, including all-day and regular events, add guests, set colors, and build weekly recurring event series with recurrence rules.

Learn to delete calendar events with apps script by retrieving events from the default calendar within a date range and iterating to remove them, with practical examples.

Learn how to programmatically create a Google Calendar event in Apps Script, add guests by email, and retrieve and inspect guest details such as email, name, status, and additional guests.

Create a Google Apps Script mini app that generates a spreadsheet from calendar events within 30 days, populates with random entries and lists start time, end time, id, title, description.

Create a standalone Google Apps Script to connect to Google Slides and create a presentation. Use SlidesApp, retrieve the presentation ID, log results, and manage permissions.

Learn to update Google Slides with code using bound and standalone scripts, access the active presentation, add slides, and apply layouts and colors.

Learn to select the active Google Slides presentation with Apps Script, loop through slides and layouts, insert and update text boxes, and customize text and background colors across page elements.

Update the Google Slides UI with a Google Apps Script that adds an image from Drive to the active slide, configures its position and size, and removes the current slide.

Insert text into slides using Apps Script by selecting the active slide, adding a text box or shape, obtaining the text range, and setting content and alignment.

Explore how to use Google Apps Script to access slide layouts from the slide master, update layouts, insert text boxes and shapes, and apply changes across presentations.

Generate a slide presentation from a spreadsheet using Google Apps Script. Create, name, and move slides into a folder, then build title and subtitle slides with random background colors.

wrap up building a slide presentation from spreadsheet data by generating slides, setting title and subtitle text from rows, and removing the first slide before finalizing.

Learn to automate Google Slides with Apps Script, accessing presentations, inserting and editing page elements and text ranges, and aligning text in bound or standalone scripts.

Discover how to create and modify Google Forms with Apps Script, including adding items and setting quizzes. Push responses to a spreadsheet and build a math quiz project.

Create a new Google form from scratch using Apps Script Forms Service, add a text item, manage permissions, and update the form by ID to customize content.

Learn to add and configure form items in a Google form using Apps Script FormApp, including text, checkboxes, multiple choice, grid, date items, and page breaks.

Learn to use Apps Script to open a form by id, inspect items, and update a text item's title, required status, and help text, with changes reflected in the form.

Create a Google form quiz using the form app class, add a multiple-choice question with yes, no, and unsure options, and configure correct and incorrect feedback for each choice.

Open a Google form by ID and pull its responses with FormApp. Iterate item responses, log titles and responses, and capture feedback and scores for export to a spreadsheet.

Learn to export form responses to a custom spreadsheet using Google Apps Script. Create a new sheet, name it form data, and append headers and responses.

Create a math quiz in Google Forms with Apps Script by generating ten random addition problems, randomizing question order and choices, and providing immediate feedback.

Learn to create, open, and update Google Forms with FormApp, add diverse items, and configure settings like shuffle, progress bars, and response options.

Explore google workspace services with mini projects using content service, web apps, and url fetch, combining client and server side code to connect to APIs and output data.

Learn to use the Contacts app class in Google Apps Script to view, create, update, and delete contacts, and access emails and names with proper permissions.

Learn to use the language app service in google apps script to translate text, create a project, connect to a spreadsheet, loop through cells, and write translations to column B.

Learn to use the maps service in Google Apps Script to generate maps, find directions, geocode addresses with the geocoder, and render a map with markers in a Google Doc.

Create a tester apps script to explore base services. Use the session service to access the active user and email, and log data or export via document or mail apps.

Learn how the content service outputs content in formats like xml and json via a doGet web app, deploy a web URL, and output downloadable content as a file.

Explore the HTML service in Google Apps Script to return HTML for web apps with doGet and outputs from strings, files, or templates, then deploy the web app.

Learn to output spreadsheet data from Google Apps Script to a web app client using Html service templates, pass data as json, and render it on the page with parameters.

Demonstrates building a client-side web app that sends data to a Google Apps Script server and appends it to a spreadsheet, using doGet, html service, and google.script.run.

Explore how to use the google apps script properties service to store, retrieve, update, and delete document, script, and user properties in a bound script, with practical examples.

use the UrlFetchApp class to fetch http or https endpoints, parse the json response, and log data while appending names to a spreadsheet and saving a json file to drive.