Please ensure Javascript is enabled for purposes of website accessibility
Google Apps Script: Mini Projects With Google Sheets

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. Read more.

5.0( 1 REVIEWS )
32 STUDENTS
1h 59m
Course Skill Level
Intermediate
Time Estimate
1h 59m

I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today. Providing Web development courses and digital marketing

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

Who this course is for:

  • Web developers
  • App 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 apps
  • Anyone who wants to power up their Google Suite of Products with really amazing features

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

Requirements: 

  • JavaScript and prior coding experience
  • Prior programming experience
  • A Google account

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.

Our Promise to You

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

10 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

About This Course

Who this course is for:

  • Web developers
  • App 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 apps
  • Anyone who wants to power up their Google Suite of Products with really amazing features

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

Requirements: 

  • JavaScript and prior coding experience
  • Prior programming experience
  • A Google account

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.

Our Promise to You

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

10 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

Course Review

5.0

5.0
1 Ratings
  1. Anonymous

    Great Course

    5.0

    I really enjoyed this course. It is was excellently paced and very informative.

Are you interested in higher education?