79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

Better Sheets
Create Free accountMember Login

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Upgrade
AppSumo badge

Spreadsheet Automation 101

31 Tutorials

0 seconds

Dive into Google Apps Script so that you can automate your business processes. Learn how to automatically send emails to yourself and others with data from inside your sheets.

31Tutorials

Spreadsheet Automation 101: Introduction to Pre-course Videos
Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.
Spreadsheet Automation 101: Functions
Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
Spreadsheet Automation 101: Variables
Dive deeper into the world of variables. Learn what variables do. Learn how to assign information to variables.
Spreadsheet Automation 101: Dot Notation
Learn how Dot Notation allows you to go deeper into the functions.
Spreadsheet Automation 101: Camel Case
Learn the importance of camel case. Camel Case is a simple technique that involves capitalizing the first letter of each word in a text string, except for the first word. This creates a consistent and easily readable format for text that may be used in formulas, labels, or other applications.
Spreadsheet Automation 101: Parentheses
We’ll tackle the importance of parenthesis, as well as when we should not use them. Learn how to make a functional function with parentheses. I’ll also teach you how to fix an error you might get with using parentheses.
Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp
Learn to write codes in Apps Script. Understand what SpreadsheetApp is used for. Get to know getActiveSpreadsheet and use it correctly.
Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy
Learn about the strategy and concept of the SpreadsheetApp. Understand rows, columns, and cells better.
Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax
Make A1 not so limited. Learn more about A1 Notation and how it can be changed to row, column. Do more with A1 Notation.
Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()
Learn the difference between getActiveSpreadsheet() and get ActiveSheet(). Don’t get confused. Learn more with this lesson.
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu
This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!

FREE

This Seems Like Automation
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

13

Spreadsheet Automation 101 Lesson 2: Get Values - Introduction
Get Values is done in the Apps Script. In this lesson, you’ll learn what changing .getValue() to .getValues() do. You’ll also learn about Logger and For Loop, which I mention here briefly.
Spreadsheet Automation 101 Lesson 2: Arrays
Learn the basics of Arrays – how to create one, how to reference rows and columns of data in a different way, and how to get an entire column or row in Apps Script.
Spreadsheet Automation 101 Lesson 2: For Loop
Learn about the syntax of the For Loop. Find out how to do fantastic automations.
Spreadsheet Automation 101 Lesson 2: Bracket Notation
Learn how and when to use Bracket Notation in an array. No memorization is needed!. You’ll also be able to see the gap between what it is that’s missing.
Spreadsheet Automation 101 Lesson 2: Logger.log()
Learn to log any variable you want and get notes inside your log. Debug your code to understand what’s going on and find out where you went wrong.
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes
Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger
One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.
Spreadsheet Automation 101 Lesson 3: Email Yourself Introduction
This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
Spreadsheet Automation 101 Lesson 3: MailApp
Learn about the needed variables for the Mail App to work. In this lesson, I’ll walk you through how you can email yourself or other people the items in a to-do list that hasn’t been done yet.
Spreadsheet Automation 101 Lesson 3: Email Yourself For Loop
I’ll walk you through how you can receive an email about tasks that haven’t been done.
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger
Learn about how to add and delete Triggers very quickly. I’ll teach you how you can send out an email regularly using Triggers.
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop
Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Use any URL to scrape the web or access an API and get that info into your Google Sheet.
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Capture data from OMDb in our Google Sheets with a free API Key. It’s easier than it sounds. Let’s do this!
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Use getData and UrlFetchApp functions, as well as Logger to get OMDb API data in our Google Sheet. Learn how to access an API outside of Google Sheets.
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Learn how we get information out of a JSON response. I’ll even show you how you can bring in some cool images in Google Sheets!
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.