Google Apps Script Build 28+ Fun Projects Sites Workspace

Explore getting started with Google Apps Script, learn JavaScript in the cloud, and connect to Google Suite to automate documents, spreadsheets, and email with the online editor.

Get started with Google Apps Script, a cloud-based JavaScript platform for custom functions across Sheets, Docs, Forms, and Slides, with projects in Drive or script.google.com.

Learn to use the Google Apps Script editor, create your first script with a default function, log dates and outputs, and manage runs, debugging, triggers, and web app publishing.

Learn to create and open Google Docs using the Document class in Google Apps Script, set document names, access by ID, and append content to the body.

Create a new spreadsheet with the spreadsheet app class, name it, open by id, and append a row to the first sheet with test values, updating the doc as well.

Master JavaScript variables in Google Apps Script by declaring var, naming conventions like camel case, data types (strings, numbers, booleans), and scope (global and function), with logging using typeof.

Explore arrays in Google Apps Script, including basic creation, length, index, looping with for each, and methods like push, pop, and shift using a fruits example.

Explore JavaScript objects in Apps Script, learn to store related data and functions, work with arrays inside objects, and access properties with dot or bracket notation while testing objects.

Explore JavaScript functions in Google Apps Script: declare and call functions, return values, log results, and reuse dynamic blocks of code to square numbers and control execution.

Apply logic with conditions in Apps Script using if statements to check a passed-in value and return different results; cover greater than, greater than or equal to, and else branches.

Explore how loops in JavaScript run multiple lines of code, using for and while loops to increment counters, log values, and break when conditions are met.

Learn how to use JavaScript inside Google apps script to connect to spreadsheets, manipulate sheets by name, and manage arrays with loops and conditions.

Learn to create and deploy a Google Apps Script web app, using content and HTML services to output text and HTML, configure access, versions, and developer versus executable links.

Learn to send emails with Google Apps Script using the mail app class and Gmail services. Retrieve the active user's email, craft HTML emails with subject, body, and attachments.

Learn to use Google Apps Script to access the default calendar, create an event with a start time and end time, handle permissions, and reference the event by its ID.

Explore how to access Google Drive, create and update files with content, set mime types, and manage permissions, IDs, and sharing for Drive items using Google Apps Script.

Explore key Google Apps Script capabilities, showing how JavaScript runs in the cloud to automate and connect Gmail, Drive, Sheets, Docs, and advanced services.

Build a Google Apps Script web app that acts as an endpoint for JavaScript fetch calls, supporting doGet and doPost, handling parameters and spreadsheet data, and returning JSON outputs.

Explore creating a Google Apps Script project that handles form submissions, updates spreadsheets, and sends emails via triggers to automate data workflows, and adds ui elements to the spreadsheet menu.

Set up a Google form, link it to a spreadsheet, and add Apps Script to automatically capture responses like emails and names within G Suite.

Learn to use the script editor in a bound Google apps script inside a spreadsheet to send email with recipient, subject, and body, manage permissions, and test form submission triggers.

Set up a trigger with Google Apps Script to automate form submissions into spreadsheet and send email notifications, using the event object, logger.log, and JSON string API to inspect values.

Copy form submissions to a dedicated users sheet via a trigger, retrieving range values and appending a structured row with id, name, and email.

Copy form submissions to both the form responses and the user sheet to maintain duplicates. Map submission data using the values array and range for dynamic name and email fields.

Sorts the user sheet by a chosen column, starting at row two, using the active sheet and the users sheet. Logs data and demonstrates sorting in ascending or descending order.

Learn to verify email delivery by scanning a Google Sheets data range, identifying unsent records, and sending emails where needed, then updating the sheet to mark sent rows.

Implement quick fixes in Google Apps Script by sending emails from spreadsheet data, adding test functions, and making confirm columns flexible. Prepare a spreadsheet UI menu button to run functions.

Create a custom spreadsheet UI with an advanced menu in Google Apps Script, enabling on-open triggers to run functions like chucker and checker, and support sorting and email updates.

Learn how form submissions flow into a spreadsheet, trigger automation with Apps Script, mirror data to a users sheet, and send welcome emails.

Build a web app with Google Apps Script that searches YouTube and returns results as json, then display data on the page and connect it to a spreadsheet.

Set up a standalone Google Apps Script project and connect the YouTube Data API via advanced services, then test pulling search results and data like uploads and playlists.

Connects Google Apps Script to the YouTube advanced service, demonstrates using search.list with id and snippet, and shows how to query, handle results, and log output for a web app.

Learn to parse YouTube search results by iterating the items array, extracting each video's id and snippet title for readable output, then build a web app to display the links.

Build a web app with Google Apps Script using doGet and HTML service, deploy with access settings, and render HTML templates from index files for client-server data exchange.

Create a client-side HTML page with a text input and search button, displaying results in an output area, and encode the search term for a backend call to Google Script.

Experience connecting client-side Google Script Run to backend functions, using success and failure handlers and callbacks, passing a search word, and logging results to the console.

Fetch results from a search API and render them on the client page by mapping items to title, description, video id, and thumbnails for HTML output.

Transform the YouTube API response into a visible HTML layout by iterating video objects and building boxes with images, titles, descriptions, and links using video IDs.

Apply styling to the output of Google Apps Script app by adjusting width, height, borders, margins, and overflow. Deploy as a YouTube search app and track results in a spreadsheet.

Use Google Apps Script to create and track YouTube results in a new spreadsheet, open by ID, select the videos sheet, and append rows with key data.

Connect Google Apps Script to the YouTube Data API via advanced services, build a front-end web app with Do Get and index.html, and display searchable video results.

Create a spreadsheet-based email workflow by selecting ranges and updating values, sending emails via an HTML template and alerts, using Google Apps Script from the sheet menu.

Set up a Google spreadsheet with name and email headers, update the sent column when emails go out, add a UI button to send confirmations, and prepare Google Apps Script.

Write a bound Google Apps Script inside a Google spreadsheet, using the Script Editor to create a custom UI menu with onOpen, and log results to verify functionality.

Learn to fetch the active sheet and active cell, retrieve the user role, and display it in a UI alert, then select a range to send emails.

The lecture describes obtaining user role information, constructing a user object from the selected spreadsheet range, and using that object to populate an email template.

Build an alert with a yes/no button in Google Apps Script to confirm sending emails. Validate user selection, craft the email template, and test behavior with logs.

Learn to build and test an HTML email template with Google Apps Script HTML service, by creating a template from file, populating it with a test user, and logging output.

Learn to send an email with Google Apps Script using the mail app service in one line, including subject, HTML body, the template, and permissions, targeting a test user.

Learn to connect Google Apps Script workflows to a spreadsheet, update a specific column when a role triggers an action, and send email notifications with dynamic messaging.

Review the Google Apps Script project that sends emails from a spreadsheet, using HTML templates, confirmation prompts, and a UI menu to validate data and track sent status.

Explore Google apps script with spreadsheet code snippets to append rows, style cells, set formulas, and update data dynamically; build mini projects with ui menus, custom functions, and html tables.

Learn to create a bound script in a Google spreadsheet, use the script editor, and append a row to the first sheet with proper permissions and project naming.

Learn Google Apps Script for spreadsheets: append rows, find last row and last column, use dynamic ranges to read and write values, adjust font size, and clear contents.

Learn to use Google Apps Script to compute per-row totals by applying a =SUM(A2:B2) formula in column C across dynamically updating rows, highlighting the results in red.

Create a function to update sheet content by selecting the active spreadsheet and retrieving the data range. Remove headings with slice, then loop through rows and set values dynamically.

Enhance Google Sheets with a bound script by creating a custom spreadsheet UI menu via onOpen, wiring items like update content, finder, and copy content.

Explore how to build a finder and find-and-replace function in Google Apps Script, using the spreadsheet UI, alerts, and prompts to communicate results and handle user input.

Create a finder and replacer in Google Apps Script that takes a target value from a prompt, searches the entire data range, and replaces matches with a new value.

Select cells, retrieve formulas, values, and backgrounds from a range using Google Apps Script; loop with for each, log outputs, and update white backgrounds to red.

Generate HTML from spreadsheet data using Google Apps Script. Build HTML output with HTML service and doGet to render a web app, deploying development and production versions.

Add an advanced menu item to email the spreadsheet table. The emailTable function fetches the active user’s email, builds an HTML table from the sheet, and sends it via mail.

Learn how to copy a single spreadsheet sheet into a pdf using a blob, save it to Google Drive, and manage temporary copies with drive and folder operations.

Leverage Google Apps Script to duplicate a spreadsheet, isolate sheet one, convert it to a PDF blob, name the file after the sheet, and save it in the target folder.

Finalize a three-part Google Apps Script project by exporting a PDF and sending it via email attachment with a dynamic recipient, a subject, and an HTML body.

Copy the user’s selected content from the active spreadsheet by retrieving the active range, then create a new sheet named test after deleting any existing test sheet.

Add a folder search option in Google Apps Script and display results in a spreadsheet by prompting the user for a search term with ok or cancel.

Build a function to search a drive folder by a term, create or replace a sheet named after the term, and log file details like name and URL.

Create a checker function in Google Apps Script to search a value in a sheet, update column D, and apply green or red formatting based on found status.

Review and reinforce how to manipulate Google Sheets with Apps Script, including updating values, searching folders, emailing HTML tables, and building UI actions like find-and-replace, copy content, and PDF exports.

Learn to build a JSON API from a Google spreadsheet and expose it via a web app endpoint that JavaScript can fetch with Ajax to display on any web page.

Set up your development environment with brackets, create index.html and a JavaScript file. Use a Google account to create a sheet and connect the front end to Google Apps Script.

Learn to write Google Apps Script, build a web API to extract spreadsheet data, and deploy a web app that outputs the content to a web page.

Learn to access a spreadsheet with Google Apps Script, open by id or url, select a named sheet, get a data range, and log values for debugging.

Create a web app with Google Apps Script by implementing a doGet function, returning content via ContentService, and publish as a web app to run anonymously.

Connect to the web app URL, fetch JSON data, and display spreadsheet content in an output area after the DOM content loads, then build and append HTML elements.

Build a client-side workflow to post name and message data to a Google sheet via a web API, using fetch and form data, with notes on open unauthenticated posting risks.

Learn to handle post requests in a Google Apps Script web app by implementing doPost, parsing post data, and returning a JSON response with status, name, and message.

Learn how to post data to a Google spreadsheet from a web app, generate a unique id from the last row and timestamp, and clean input with a regex.

Debug and clean a web app built with Google Apps Script, ensuring data submission saves to a spreadsheet, retrieves responses, and reveals inputs with the returned id.

Build a web app that posts and retrieves data to a Google Apps Script web app using doGet and doPost, with JSON and spreadsheet storage.

Build a dynamic image gallery that pulls images from Google Drive, outputs JSON via Apps Script to a web app endpoint, and renders them on your site with JavaScript.

Set up a Google Apps Script web app to pull images from a Google Drive folder and display them as a JSON-driven gallery on a web page.

Create a web app using Google Apps Script, output content with the content service, and serve JSON data via a get method for Ajax-powered web pages.

Fetch drive images with Google Apps Script by looping a folder, extracting file name, id, and shareable link set to view, and outputting a json array.

Connect to a web app JSON to fetch image URLs from Google Drive and render them on the page after the DOM content loads using fetch.

Dynamically generate image elements from JSON data, set their src attributes, style them as a left-floating gallery, and wire click events to preview images in a modal.

Create a JavaScript-driven modal popup that displays a clicked image by injecting its URL into the modal body, styling the overlay and close button, and revealing the modal on click.

Implement a robust modal close for the JavaScript image popup, enabling close via the X and outside clicks, and load new images from Google Drive into the gallery.

Explore how the image gallery built with Google Apps Script works, including Ajax data fetch, Drive folder rendering, and a modal viewer powered by JavaScript interactions.

Create and upload images from an html5 canvas to Google Drive with Apps Script, using base64 and blobs, return URLs for linking, and retrieve Drive images in base64 for display.

Create a web app in Google Apps Script using the HTML service to serve an index.html hello world page and deploy as a web app with executable and developer URLs.

Convert Google Drive images to base64 using Google Apps Script, extracting image bytes via blob, encoding with Utilities.base64, and rendering as data URLs in HTML5 canvas workflows.

Learn to pass base64 image data from a Google Apps Script server to the client via an html template, render image in the browser, and output it to the DOM.

Build an interactive web app front end with HTML, canvas, and JavaScript to render text and images and enable saving canvases to Google Drive via Google script.

Track the user's mouse on the canvas with client side JavaScript to dynamically place text or load a default image, using click events, a 2D canvas context, and interactive buttons.

Compute x and y from the click position and canvas bounding rectangle, then add text at those coordinates using a text input and a 40-point font.

Load and draw the logo on the canvas at a set position using the ad image function and image two from the data gs source.

Upload images from your computer into a canvas background, resize proportionally to a max size, then add text and logos before saving with Google Apps Script.

Learn to convert a canvas image to a data URL, pass the base64 data to Google Apps Script, and upload it to Google Drive using a doUpload function.

Use google apps script to decode base64 data into an image blob, save to a Drive folder by ID, and return the file URL.

Create date-based random file names by converting timestamps to base 60 or base 36, and email the active user on image uploads with the image URL.

Encode images as base64, render them in a Google Apps Script web app, and manage uploads via doUpload and doGet with a canvas editor.