Academy ↓
Hey there stranger!
Sign up to get access.
Spreadsheet Automation 101: Introduction to Pre-course Videos
About this Tutorial
Video Transcript
0:09 We're going to learn how to use App Scripts again and again and again. In this particular section, I've put in a few videos that'll help you later on.
0:21 They're not in any particular order, but they go through fundamentals of app script that I think are very, very important.
0:29 Now, I hope that you've already done the Learn to Code course that I offer. It's about 38 minutes. It's only, I think five videos no six videos, sorry, five fundamental videos, and then a six, one that goes off a little off the rails a little bit and gives you some more insights.
0:49 But Learn to Code is a very good introduction to just getting through all of the muck and problems and issues of like the fundamentals.
0:57 Sort of one of the interesting things that I found when I was taking coding courses, programming courses and learning myself, is I got stuck a lot on the fundamental tutorials.
1:10 I, I found them to be out of context. I didn't know how this would particularly be used later on. So here's the fundamentals in this particular course.
1:23 I've tried to put them in the pre-course material so that when we enter the actual course material, we can just start running start coding right away.
1:33 But and I've taught this kind of material a few times now, and almost every single time one of the questions comes up about parenthesis, about function syntax, about variables, about Camel case dot notation, all sorts of little things that I end up spending a little bit of five to 10 minutes in the course, sort of going away and, and teaching.
1:57 So I've put these upfront to one so that you have these fundamentals down when you start. But if you end up skipping them now and you go through the course and you're like, but what is this dot thing?
2:11 Or what is, why is there app parenthesis? You can always come back to these later on and, and watch them, and we focus on just that thing.
2:20 I also share with you some errors that might occur if you don't do do it the way that abs script wants you to do it.
2:26 So just in case you see those errors, you can also come back and see, oh, is one of these errors in here.
2:34 So this is all to help you. And if you have more questions, feel free to reach out, ask the questions, especially if you get further and deeper into the course and you're like, Hey, what about, what is this thing?
2:46 I can always add it later on. So I really wanted to get you going. So yeah, enjoy the pre-course videos, all about the fundamentals of app script here in spreadsheet Automation 1 0 1.
3:00 Bye.
Courses
Spreadsheet Automation 101: Introduction to Pre-course Videos
Breaking Through Errors In Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
Tips to Navigating Thousands of Lines of Code In Apps Script
Spreadsheet Automation 101: Functions
Spreadsheet Automation 101: Variables
Spreadsheet Automation 101: Dot Notation
Spreadsheet Automation 101: Camel Case
Spreadsheet Automation 101: Parentheses
Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp
Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy
Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax
Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu
This Seems Like Automation
Spreadsheet Automation 101 Lesson 2: Get Values - Introduction
Spreadsheet Automation 101 Lesson 2: Arrays
Spreadsheet Automation 101 Lesson 2: For Loop
Spreadsheet Automation 101 Lesson 2: Bracket Notation
Spreadsheet Automation 101 Lesson 2: Logger.log()
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger
Introduction to Spreadsheet Automation 101 Lesson 3
Spreadsheet Automation 101 Lesson 3: MailApp
Spreadsheet Automation 101 Lesson 3: Email Yourself For Loop
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Automatically Clear Content | Refresh Reuse Recycle Templates
Automate Google Sheets With Zero Experience
Automatically Uncheck A Daily Checklist
Activate A Certain Sheet When Opening a Spreadsheet
Scoping Functions in Apps Script