Google Apps Script Complete Course Beginner to Advanced

Explore the document class in Google Apps Script, using getBody to access the current document and append content such as paragraphs and page breaks.

Learn to retrieve a Google document's contents from the body, translate the selection to Spanish using the language app, and append the translation back, noting lost formatting.

Learn to access a document body with Google Apps Script, retrieve a paragraph using body.getChild(0), log its text, and update content and attributes like font size.

Learn to manipulate the document body in Google Apps Script by retrieving, editing, and styling paragraphs, including setting text, colors, and attributes, and looping through them.

Explore looping through the Google Apps Script document body, counting children, filtering for paragraphs, accessing text, and replacing or appending content with length checks.

open a google doc by id, access the body, and apply foreground color, background color, bold, and font size by iterating elements and updating text.

Learn to build a Google Apps Script that copies content from one document to another, stripping formatting and preserving text, lists, and tables.

Explore bound DocumentApp scripts, access documents by id or url, use onOpen to run code, and build a custom UI with menus, items, separators, and submenus.

Explore how to create and customize ui alerts and prompts in Google Apps Script, capture user responses, and access active user details, locale, and timezone through the script service.

Explore using the HTML service to render HTML in Google Apps Script and display it in a modal dialog for Docs or Sheets, including HTML files, CSS styling, and JavaScript.

Leverage bound content interaction by using the document app to get the active document, access the cursor, insert text with the date, and manipulate the selection and document id.

Select content, verify a nonempty range, and iterate over elements to extract editable text. Apply bold using start and end offsets and handle partial selections.

Translate selected content in Google Apps Script by extracting text, translating from English to Spanish with a built-in function, and storing the result in a new output variable.

Learn to bind multiple scripts to a single document, expose two menus, and implement a find-and-replace workflow using ui prompts and the replaceText method.

Learn to search a document for specific text with find text, update content and attributes using range elements, and loop through results to apply foreground color changes.

Explore transforming selected text in Google Apps Script using JavaScript string methods, looping through the selection, extracting start and end indices with substring, and updating text to uppercase.

Build and test a Google Apps Script document app exercise that finds hello text, appends world, and uses start/end positions, bookmarks, and UI controls.

Learn to build and format Google Docs with DocumentApp by creating titles, tables, headings, and lists, and by inserting content with color attributes. Manage document name and versions while editing.

Learn to insert images into Google document using DocumentApp in Google Apps Script by fetching images from a URL or Drive, converting them to blobs, and inserting or appending them.

Learn to create and clear a Google Docs template in DocumentApp, then build paragraphs and placeholder slots. Replace placeholders such as first name and date with user input using replaceText.

Create a Google Apps Script standalone that uses the spreadsheet app to create a new spreadsheet named spreadsheet app tester, run once, log its URL, and grant Google Drive permissions.

Create and style spreadsheets with Google Apps Script by generating new sheets, retrieving IDs, and applying color to ranges using notation or coordinates.

Learn to get and set values in Google Apps Script using range objects, get values, set values, and two-dimensional arrays, log outputs, and update specific cells in a spreadsheet.

Read the first sheet of a google spreadsheet, create a google doc, and insert the sheet data as a table with the first row as a bold header.

Grab dynamic spreadsheet data by using get last row and get last column to determine the range, then insert content into a Google document without fixed values.

Create a tracking sheet to log document name, id, url, and created date, using get sheet by name and append row, then increment and track table numbers for new documents.

Explore the Google Apps Script sheet class by auto-resizing columns to fit text, and using clear options for contents, formats, notes, and targeted sheets in practice.

Manipulate sheets with Apps Script: copy sheet contents to a new spreadsheet, insert or delete columns and rows, and manage sheet index, name, and protection.

Open a bound script for a spreadsheet, use get active spreadsheet and get active sheet to reference the current sheet, log its url, and access sheets by name.

Create a bound Google Apps Script in a spreadsheet, add custom functions such as a times five function and an is email function, and apply them directly to cells.

Create a custom UI in Google Sheets using getUi to build an advanced menu with items and prompts, leveraging onOpen to bind scripts and run functions.

Create a spreadsheet UI with modal and sidebar in Google Apps Script. Output HTML content, set height and width, and use show modal dialog or show sidebar to control focus.

Google Apps Script basics by learning to get selected content, log ranges, and build a dynamic HTML UI to display range details, then append values to another sheet.

Learn to select content from a sheet and append it to another with Google Apps Script, handling objects, converting to strings and arrays, and looping through rows.

Copy content between sheets using Google Apps Script by leveraging copyTo with an active range, getRange, and destination range, enabling precise overwrites across sheets.

Learn to loop through a spreadsheet with Google Apps Script, using a UI prompt to search for a value, identify its row and column, and highlight matches.

Learn to build a dynamic sidebar in Google Apps Script by using UI, HTML templates, and iframe sandboxed output to render HTML in spreadsheets.

Explore additional UI options in Google Apps Script, including multiple HTML files, sidebar and modal dialogs, and embedding JavaScript to interact with content, set dimensions, and customize titles.

Connect a client-side HTML page with Google Apps Script backend, using an output div click to invoke a server function, return data, and update the page.

Learn to fetch active sheet data in Google Apps Script and pass row values and headings to the client side for dynamic HTML output.

Configure Google Apps Script triggers for a spreadsheet, wiring on open, on change, and on edit to log changed content. Explore time-driven triggers and form submit events, and review logs.

Create a menu in Google Sheets using Apps Script, wired to on open with get UI. Add items to generate content and show info modals, then log and validate functions.

Learn to generate random content and manage spreadsheets with Google Apps Script. Create and delete sheets, and fill 4 columns by 10 rows with random values using range and setValue.

Insert a new column before existing data in a google sheet, copy ten values from the main sheet using get values and get range, then paste with set values.

Learn to add formulas to a Google Apps Script menu, create an add formula function, apply a sum across B1:C1:D1 into the range E1:E10, and style with red bold text.

Open a Google Sheets modal with HTML service using a file template and evaluate to display an info HTML in a 1200 by 600 window.

Build a Google spreadsheet dashboard, display it in an html file via a modal, and pass sheet data by looping sheets into an array and using a template.

Learn to pass Google sheet data to a modal and display it in a dashboard by building a dynamic output div and populating a sheets dropdown with JavaScript.

Learn to run scripts client-side with Google Apps Script using JavaScript, triggering on sheet changes, passing data to the back end, and handling responses with on success.

Learn to fetch data from a Google Sheet by name using Apps Script, verify the sheet exists, retrieve values, and render results in a dashboard table with optional styling.

Explore Google Sites basics, including creating classic and new versions, templates, themes, and app script integration. Learn to customize navigation, page settings, and insert calendars, Drive content, gadgets, and HTML.

Discover how to create and publish a new Google Sites site, compare new and classic sites, customize themes, and embed content such as spreadsheets and Google scripts across pages.

Publish a Google Apps Script as a web app using doGet to output HTML via the HTML service, then deploy with versioning and access controls.

Explore the Google Sites service in Apps Script to access a classic site by URL, retrieve the title, and inspect editors, owners, and viewers.

Master how to build a Google Apps Script web app by rendering HTML with HTML service and doGet, using templates or files, and publishing the app with bootstrap via CDN.

Discover how the Google Drive app class enables accessing and modifying files and folders via a standalone script, listing root folder contents and collecting file names.

Learn to select a specific folder by its id, access it with the Drive app, and retrieve its files using folder.getFiles, demonstrating how new files update the list.

Fuse google sheets with drive app using apps script to create folders through a ui prompt, binding the script to a sheet, and manage folders in a parent folder.

Use DriveApp to create a folder, obtain its ID, and dynamically create a plain text file inside it from a string, then rename the file as needed.

Create a drive folder listing in a spreadsheet with Google Apps Script, iterating folders to capture name, id, owner, created date, last updated, url, and viewers.

Create a Google doc in the root folder, capture its ID, and move it to a target folder using drive app methods like get file by ID and add file.

Explore drive search techniques in Google Apps Script by querying folders with title contains a user-provided term, paging results, logging IDs and URLs, and appending them to a sheet.

Learn to search drive files in Google Apps Script by following the folder search pattern, adding file queries, and updating the UI to show file names and URLs.

Explore how to use the Drive app search parameters to query folders and files, including title, contains, full text, mime type, modified date, and visibility via the Google Drive SDK.

Learn to manage drive permissions with Google Apps Script by listing folder IDs, adding and deleting editors or viewers, and updating the bound spreadsheet to reflect changes.

Create a standalone Google Apps Script that acts as a redirector web app, reads a URL parameter, searches Drive folders by title, and redirects to the matched folder.

Learn to build a Google Apps Script web app that renders search results via an HTML template, passes data, and redirects to a data URL.

Explore the GmailApp class in Google Apps Script to send mail with recipient, subject, and HTML body, manage Gmail permissions, and future lessons cover drafts, updates, and on-the-fly attachments.

Learn to create draft emails with the Gmail app using GmailApp, attach Drive files, convert them to PDFs, and manage drafts before sending.

learn to view and manage Gmail drafts with Google Apps Script by retrieving drafts, looping through them, updating subject and body, and logging IDs and messages.

Create and send emails from an HTML template in Google Apps Script by building a simple HTML file, injecting dynamic content, and sending HTML messages to multiple recipients.

Learn to send bulk emails with Google Apps Script by reading recipient data (first name, last name, email) from a spreadsheet, personalizing messages, and updating the sheet with send status.

Explore using the Gmail app in Google Apps Script to fetch chat threads, check their count, and email the first thread's message count to the active user.

Set up Gmail filters and labels to organize incoming emails, then use Google Apps Script to fetch labeled threads and append subjects, dates, and senders to a spreadsheet.

Explore the calendar service in Google Apps Script by creating and managing events in your default calendar, including all-day events, with code that logs event IDs and handles permissions.

Learn to add location, guests, and descriptions to calendar events in Google Apps Script. Create and customize events with start and end dates, all-day or recurrent options, and manage invites.

Create a calendar event in Google Apps Script by selecting the default calendar, setting start and end times, and applying options like description, guests, reminders, and color.

Learn to create all-day events in a calendar app with Apps Script, using start and end dates, title, optional guests, invites, and event IDs for future reference.

Create and manage a repeating calendar event series using a calendar app, defining start and end times, weekly rules, and an end date to visualize recurring events in week view.

Create calendar events with precise start and end times in Google Apps Script, using multiple date formats, 24-hour clocks, color coding, and month indexing.

Learn the easiest way to create calendar events from a description using Apps Script, defaulting to the next Thursday at 4 p.m. with an event ID logged for verification.

Create a new calendar with Google Apps Script using an options object, name it exercise calendar, set turquoise color, and log its name and ID for retrieval.

Learn to manage calendars with Google Apps Script by retrieving calendars by ID or by name, setting colors, and adding or updating events and descriptions.

Learn to fetch all calendars, both owned and subscribed, loop through them to extract names and IDs, and export calendar data into a spreadsheet using Google Apps Script.

Explore creating and listing calendars by name in Google Apps Script, and learn to handle multiple calendars, IDs, and ownership with get calendars by name and related methods.

Learn to work with calendar events in Google Apps Script by using get events on the default calendar for a day, treating results as an array, looping, and logging.

Fetch calendar events for a dynamic one-week window using start and end times with milliseconds, apply a search for apps, then log and export to a Google spreadsheet.

Discover how to deposit calendar events into a spreadsheet using Google Apps Script, pulling from the default calendar and appending rows with event title and start time.

Learn to update calendar event statuses with Google Apps Script, clearing a week’s invites by looping through events, inspecting owner and invited statuses, and deleting or updating RSVP states.

Combine app script workflows to read all calendars for the week, format event details with utilities, and send a weekly html email to the active user using a time-driven trigger.

Discover how Google script connects calendar, documents, Drive, Gmail, and Sheets to build web applications quickly. Explore HTML and advanced Google Services to combine apps and streamline workflows.

Build a google apps script image uploader from scratch that uploads images to Google Drive, records data in Google Sheets, and emails image links with a screenshot.

Learn to render HTML content in Google Apps Script using the HTML service, including doGet, creating HTML outputs, testing with a developer version, and publishing as a web app.

Learn to render html content with templates using template evaluate, pass parameters, and return content, including dynamic hello world output, and compare template rendering to using an html file.

Learn how to render HTML content from files in Google Apps Script using the HTML service, outputting from files and templates with variables, and optional bootstrap styling.

Build an HTML form without bootstrap, wire a submit button, and use vanilla JavaScript to prevent submission, display output, and prepare data for an Ajax-like call to Google Apps Script.

Learn how to send data from the front end to a Google Apps Script back end using ajax-like calls, client-side runs, and a success callback.

Learn to upload images to Google Drive using Apps Script by handling file inputs, converting to blobs, saving into a Drive folder, then returning a usable image URL.

Enhance image uploads by rendering server responses and status, outputting dynamic HTML with image links, and tracking uploads in a spreadsheet via Google Apps Script.

Create an image uploads spreadsheet and log each upload by appending a row with image URL, name, and date using Google Apps Script.

send an email notification when a new image is uploaded, using the mail app in Google Apps Script to include the image URL and a subject like 'new image uploaded'.

Integrates Google Apps Script web app with ajax to upload images to Drive, update a spreadsheet, and send emails, then embeds the final image uploader in Google Sites with permissions.

Set up a bound Google Form in Google Drive and link responses to a spreadsheet. Implement Apps Script triggers to send emails and collect name, email, group, and opt-in preferences.

Bind a Google Apps Script to a spreadsheet, automate form submissions with an on form submit trigger, log data, and configure current project triggers for future automation.

Set up an on form submit trigger in Google Apps Script to run a function when a form is submitted, configure notifications, grant permissions, and capture values for email responses.

Learn how to send HTML emails from Google Apps Script by passing values and named values, logging data as objects and arrays, and delivering form submissions to recipients.

Send emails with MailApp in Google Apps Script by simulating form submissions with a test array, then define recipient, subject, and body, and explore HTML templates.

Learn to create an html email template in Google Apps Script using a main and content table, populate hash tokens with a date, and send via the html service.

Learn to generate and send html emails from templates with the html service, replacing date, group, and message fields. Preview the result; next, attach a dynamic pdf.

Learn to attach dynamically generated pdfs to emails by converting html to pdf with html service and blob, then save to drive for tracking.

Loop through form submission data to send automatic emails from a default template, and log each send in a tracker sheet while managing spreadsheet access and permissions.

Iterate the sheet data with a for loop, checking opt-in status. Send emails via a function to opted-in recipients and log the sent date, email, and group to the tracker.

Review and update Google Apps Script project by automating form responses to Google Sheets, sending templated emails, generating PDFs, and scheduling weekly group emails with a tracker.

Set up the essential tools for creating a contact form with Google Apps Script, including Chrome devtools, the Brackets editor, a default template, and Google Sheets for submissions and emails.

Create a new spreadsheet named contact form data and add fields for id, timestamp, name, email, and message. Explore bound and standalone scripts and publishing a web app.

Learn to send email with Google Apps Script using the Gmail service, including sendEmail with recipient, subject, and body, plus permissions and basic form integration.

Connect to a Google spreadsheet with spreadsheet app, open by id, and append a row to the messages sheet with id, date, email, and number. Verify permissions and review logs.

Build a web app with Google Apps Script using doGet and doPost triggers, deploy as a web app, and test access with developer and test URLs while viewing logs.

Learn to retrieve request parameters with the content service in Google Apps Script, output text or json content via doGet and doPost, and echo parameters like id back as json.

Learn to submit HTML form data with fetch to a web app URL, handle the JSON response, and log the status and returned data.

Learn to post data to a Google Apps Script web app, handle the response status, display a ticket ID, reset the form, and update the page output.

Learn to simulate form data, handle doPost/doGet in Google Apps Script, map to sheet headings, and append a new row to the messages sheet.

Learn to send an email on submit using mail or Gmail app, structure an email object with recipient, subject, and html body, and pass name and message while testing permissions.

Generate a unique random ID and a timestamp in Google Apps Script using a date-based ID and a ternary check for null values, updating the form output.

Build and send a styled HTML email template in Google Apps Script by rendering email.html with HTML service and populating it with id, name, and message.

Build a functional Google Apps Script web app by connecting to a spreadsheet, processing form parameters, creating a unique id and timestamp, updating the sheet, and sending emails.

Wrap up the Google Apps Script project with a live contact form, test submissions, and review how spreadsheets act as the back end to send emails, track submissions, and notify you.