Google Apps Script: Mini Projects With Google Sheets

No Rating(0)
See all reviews

This course is designed for those interested to learn the basics of Google Sheets and its many functionalities, how to style cells, add formulas, create custom functions, and return search results into a Google Sheet.

Watch Free For 30 Days

start free access

-or-

buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This Courseintermediate

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

Course Sections

Spreadsheet App Introduction

Bound Script Starter Lesson

Add More Content To Spreadsheet

Spreadsheet Formulas

Update Sheet Content

Spreadsheet UI

Finder And Replace Content

Finder And Replace Content 2

Get Cell Values

Get Content As HTML

Email Spreadsheet HTML Table

Copy Spreadsheet As PDF

Copy Spreadsheet As PDF 2

Copy Spreadsheet As PDF 3

Content Copy

Search Drive Files

Search Drive Files 2

Value Checker If Exists

Course Conclusion Code Review

Finder And Replace Content

Reviews

No Reviews found for this course.