Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Script Apps Fun with Spreadsheets Mini Projects
Highest Rated
Rating: 4.6 out of 5(28 ratings)
2,100 students

Google Script Apps Fun with Spreadsheets Mini Projects

Explore some of the amazing things you can do with Google Apps Script within Google Spreadsheets
Highest Rated
Created byLaurence Svekis
Last updated 11/2024
English

What you'll learn

  • How to apply Google Apps Script
  • How to apply Google Apps Script in Projects
  • Explore how to use Google Apps Script - Classes and Methods to power up GSuite

Course content

2 sections • 36 lectures • 2h 7m total length

  • SpreadsheetApp Introduction2:45
  • Bound Script Starter Lesson5:11
  • Source Code0:02
  • Add More Content to Spreadsheet10:50
  • Source Code0:09
  • Spreadsheet Formulas with Google Apps Script5:30
  • Source Code0:04
  • Update Sheet Content7:17

    Create a function to update sheet content dynamically with Google Apps Script by selecting active spreadsheet, fetching data range, removing headings, and setting values for the first two columns.

  • Update Content Source Code0:08
  • Spreadsheet UI more options4:44

    Add a custom spreadsheet menu bound to scripts to streamline actions. Use on open to automatically render the UI with items like find, replace, and copy.

  • Add UI menu Source Code0:05
  • Finder and Replace Content5:24

    Build and test the finder and find and replace feature in a spreadsheet app, using the bound script and UI alerts and prompts to interact with users.

  • Finder and Replace Content 29:52
  • Source Code Find Replace Sheet Values0:25
  • Get Cell Values7:15

    Learn to use Google Apps Script to get cell values, formulas, and backgrounds from a range, then loop through cells and update white cells to red.

  • SOURCE CODE GET CONTENTS0:09
  • Get Content as HTML.8:11
  • SOURCE Code0:12
  • Email Spreadsheet HTML table3:32
  • Source Code0:04
  • Copy Spreadsheet as PDF.5:33
  • Copy Spreadsheet as PDF 2.5:48

    Duplicate the spreadsheet, isolate sheet 1 by removing other sheets, create a blob from the sheet, and save the file in a folder for later email attachment.

  • Copy Spreadsheet as PDF 33:41
  • Source Code Copy Files send as email PDF0:15
  • Content Copy.5:23
  • Source Code Active Content Copy0:07
  • Search Drive Files2:58

    Learn to build a drive folder search tool in Google Sheets using Apps Script, prompting users for a search value, filtering folders by name, and returning results to a spreadsheet.

  • Search Drive Files 25:48
  • Drive Searcher Source Code0:14
  • Value Checker if Exists6:29
  • Source Code0:07
  • Course Conclusion Code Review7:49

    Review the Google Apps Script for spreadsheets, including the checker, search folders, and email output features. Master copy, update, and find-and-replace content while handling dynamic ranges and spreadsheet open events.

  • Source Code Google Apps Script2:23

Requirements

  • JavaScript and prior coding experience
  • Prior Programming experience
  • Computer access and internet access
  • Google Account

Description

Course included multiple useful code snippets to help you supercharge your Google Apps Script applications.

The SpreadsheetApp Class has a lot of really great functionality in the course lessons we will be exploring how to make use of some of these functions, adding them to mini projects that students are encouraged to build upon and extend upon. 

Course covers APPLYING Google APPS SCRIPT - Prior JAVASCRIPT experience is REQUIRED for this course.

Topics include

  • Appending new rows of content to Google sheets

  • Setting styling like font size to cells

  • Setting of formulas within cells

  • Updating values dynamically

  • Use of UI object within the spreadsheet Class Ui

  • Creating custom functions find and replace for sheet menu

  • Getting Cell data and updating cell data, getting formulas....

  • Create content from spreadsheet as HTML tables- then email it or use in a web app

  • Email service sending emails to active user

  • Copying spreadsheet as a PDF - creating a blob and emailing the PDF

  • Selecting and getting active selected content

  • Search option added to user menu - searching gDrive folders and returning results into Spreadsheet

  • Adding folder search results to a spreadsheet

  • Checking for values in sheet and updating column values depending on result

  • Copy and duplicate of sheet contents

UI - An instance of the user-interface environment for a Google App that allows the script to add features like menus, dialogs, and sidebars. A script can only interact with the UI for the current instance of an open editor, and only if the script is container-bound to the editor.

Source code is included so you can copy and paste the code to try for yourself.

Course is about applying Google Apps Script and JavaScript

Step by step learning

Fast friendly support is always available within the Q&A section

Experienced instructor with over 20 years of experience ready to help you learn

You have nothing to lose - Join now and start learning to create your own version of this helpful application today!!!

Who this course is for:

  • Web developers
  • Application Developers
  • Coders who want to explore how to use Google Apps Script
  • Anyone who wants to learn more about Google Script
  • JavaScript developers who want to add a new language to their portfolio
  • Anyone who wants to create amazing applications
  • Anyone who wants to power up their Google Suite of Products with really amazing features

Report abuse