About This Course

Google Sheet 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 where you are encouraged to build and extend upon. 

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

Requirements

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

What you’ll learn:

  • Appending new rows of content to Google Sheets
  • Setting styling like font size to cells
  • Setting of formulas within cells
  • Updating values dynamically
  • Using of UI object within the spreadsheet 
  • Creating custom functions
  • Getting and updating cell data
  • Creating content from spreadsheet as HTML tables – then email or use it in a web app
  • Sending emails to active users
  • Copying spreadsheet as a PDF – creating a blob and emailing the PDF
  • Selecting and getting active selected content
  • Searching option added to user menu – searching Google Drive folders and returning results into Sheet
  • Adding folder search results to a spreadsheet
  • Checking for values in sheet and updating column values depending on result
  • Copying and duplicating of sheet contents

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 Apps 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

Our Promise to You

By the end of this course, you will have learned more of how to use Google Sheets.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about the functions of Google Sheets.

Course Curriculum

Section 1 - Introduction
Spreadsheet App Introduction 00:00:00
Bound Script Starter Lesson 00:00:00
Add More Content To Spreadsheet 00:00:00
Spreadsheet Formulas 00:00:00
Update Sheet Content 00:00:00
Spreadsheet UI 00:00:00
Finder And Replace Content 00:00:00
Finder And Replace Content 2 00:00:00
Get Cell Values 00:00:00
Get Content As HTML 00:00:00
Email Spreadsheet HTML Table 00:00:00
Copy Spreadsheet As PDF 00:00:00
Copy Spreadsheet As PDF 2 00:00:00
Copy Spreadsheet As PDF 3 00:00:00
Content Copy 00:00:00
Search Drive Files 00:00:00
Search Drive Files 2 00:00:00
Value Checker If Exists 00:00:00
Course Conclusion Code Review 00:00:00
Finder And Replace Content 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel