Learn to Code In Google Sheets in Less Than 1 Hour

In the first lesson, we'll show you why coding in Google Sheets is so powerful, and we'll introduce you to the fundamentals of coding.

Drop a comment down in the Q&A section. Tell me what you're trying to do. Why are you learning to code in Google Sheets?

In this section of the "Learn to Code in Google Sheets" course, you will learn how to write your own custom functions using Google Apps Scripts. A function is a piece of code that performs a specific task and can be called upon to execute that task whenever it is needed. By creating your own functions, you can save time and improve your efficiency by reusing code instead of writing it from scratch every time. In this lesson, we will cover the basics of writing functions in Google Sheets, including how to define a function, how to pass arguments to a function, and how to return values from a function.

You will learn how to pull data from a Google Sheet and use it in your Google Apps Scripts, and you will also learn how to write data from your scripts back to Google Sheets. By the end of this lesson, you will have the skills and knowledge you need to effectively use data from Google Sheets in your scripts, and to write data from your scripts back to Google Sheets."

In this section of the "Learn to Code in Google Sheets" course, you will learn how to write a Google Apps Script that moves data from one spreadsheet tab to another. You will learn how to specify the source and destination tabs, and how to handle errors and exceptions in your script. By the end of this lesson, you will have the skills and knowledge you need to efficiently copy data from one tab to another using Google Apps Scripts.

In this section of the "Learn to Code in Google Sheets" course, you will learn how to create a trigger for any Google Apps Script. You will learn how to specify time-driven and event-driven triggers. By the end of this lesson, you will have the skills and knowledge you need to automatically run almost any Google Apps Script you can make. You'll also learn about some limitations that exist.

Concepts include

• Send Emails with “MailApp”

• Access APIs

• Create More Types of Triggers (Event driven)

Find out what graying out means. Learn a neat new keyboard shortcut to edit lots of text at one time.

A quick video to show you some simple automation technique with Apps Script.

Recreate the first apps script automation I made 10 years ago, in a few minutes. This once took me two weeks to figure out.

Write a single line of apps script to make sure anyone opening the sheet starts on the same tab.

Here is a quick 2 minute video that shows you a simple tool to count merged rows in an active cell.  Coding in sheets makes it simple to build internal tools like this.

Learn how to get information from one spreadsheet file to another spreadsheet file with apps script and not importrange()