Google Apps Script Project Sheet UI custom Functions

Explore how you can create a custom Google Sheet option within your Google Sheets UI menu.

PopUp alert connects to Google Apps Script to run custom spreadsheet code o find and select cells that match the value.

Explore Google Apps Script and how it can be used to run code using data from your Spreadsheet

Discover the amazing things you can do with Google Apps Script

Course covers some of the commonly asked for functionality using Google Apps Script and Google Spreadsheets

Do more with your Spreadsheets adding a custom UI menu with advanced options

Search – uses UI prompt to ask the user for a search term, searches all the sheets within the spreadsheet and highlights the cells with matching content.

Email – Lets the user email themselves the selected content from the spreadsheet, construct an html table some selected active spreadsheet data.  Send the email.

Copy –Copy selected content to a new sheet, takes the selected data create a new sheet and builds the content from the selection.

JavaScript and prior coding experience is REQUIRED DO NOT TAKE THIS COURSE WITHOUT JavaScript Experience

Source code is included – Best way to learn is to try the code and create your own version of this project