What will I get out of this course?

Apps Script 101 is designed to give you time back. Your investment of a few hours will pay EXTREME dividends when you no longer spend your time on repetitive tasks–in fact, you won't even need to think about them.

This course is designed to be practical and efficient. You'll develop the foundational tools you need to build from, and I won't waste your time on anything you don't need to know.


What is Apps Script?

Apps Script is a simple and approachable programming language that allows you to interact directly with Google productivity tools such as Google Sheets, Gmail, Calendar, Forms, Docs, etc.

Apps Script essentially allows you to write a program that mimics what you would do with a mouse and keyboard (for example: clicking "Compose" in Gmail, copy-pasting in an email template, copy-pasting in the email address and first name in the correct spots, clicking "Send" – but it can do it for 100 different email addresses and a 100 different names all at once).


Who should take this course?

Anyone who wants to spend less time on repetitive tasks! This course is designed for busy people with no prior programming experience. You'll get a practical foundation in programming, then jump into a specific applications that will be relevant to your work.


Course Requirements

  • Familiarity with Gmail and spreadsheets
  • A belief that you can learn anything (if you're unsure, that's okay, I believe in you!)

Course Non-Requirements

  • Absolutely no programming experience required - This course is designed as a practical guide to get you from your first line of code to a working application that saves you time in your day

What You'll Build

Hi! I’m Chad

My job at Google was to automate different operational processes using Apps Script programs. After a while, I built this course to teach my coworkers. Since then, I've taught hundreds of non-technical Googlers (for most of them, it was their first experience programming) and expanded to teach non-profits and other consulting engagements. I'm now excited to bring the course to you!


I consider myself a lifelong teacher. I love helping others understand how things work, and I especially enjoy helping people find more efficient ways to do things.

Even as far back as high-school, I preferred to explain the homework rather than let my friends copy it (they were disappointed).

Throughout college, I was a STEM tutor, and decided I actually really enjoyed teaching. After college I joined Teach For America, where I taught high school mathematics. That was one of the most challenging and rewarding experiences of my life. Finding a way to make math engaging for a variety of high schoolers with different education backgrounds, literacy levels, mathematical abilities, interests, and personal situations made me a much better teacher (and, I would argue, person).

I'm excited to teach you Apps Script because I believe time is our most valuable non-renewable resource. Automating tasks allows you to free up more time for whatever you find important.


I hope you'll join me in class!


Credentials

Former Google Employee

Teach For America Math Teacher

Master of Arts in Teaching

Bachelor of Science in Engineering


Photo credit

A former student

Testimonials

"Chad made programming accessible, fun, and immediately useful. I'm a content strategist, not a programmer, and since his class, I've automated a lot of menial work for my teams. Three hundred colleagues use one of my tools, and it saves about $55k a week."

—Aaron Shifflett, Content Strategist


"I am taking Chad's Apps Script class currently and it is so helpful in both my professional and personal life! 10/10 would highly recommend 👍🏼 "

—Kelsey Germaine, People Operations Specialist


"Chad's Apps Script 101 course completely changed my approach to work for the better - inspired a very human way of thinking about automation. Great intro to programming 🤓"

—Joshua Encarnacion, Head of Talent

What You'll Learn with Chad

  Welcome
Available in days
days after you enroll
  PART 1: Building Blocks of Programming
Available in days
days after you enroll
  PART 2: Build an Email-from-Spreadsheet App
Available in days
days after you enroll
  PART 3: Build a USEFUL, automated email-from-spreadsheet App
Available in days
days after you enroll
  Wrap up
Available in days
days after you enroll
  BONUS CONTENT
Available in days
days after you enroll

Apps Script Use Cases

  • As an operations professional, automate business processes such as approval requests, notifications, or audits
  • As a salesperson, write a script to automatically send a personalized email to any leads that respond to a Google Form (you could even create your own drip campaigns!)
  • As an HR leader, write a script to automatically email all new employees with a welcome email (you could even automatically add orientations and trainings to their calendars!)
  • As a landlord or roommate, write a script to automatically email tenants or roommates with a rent reminder each month
  • As a manager or owner, enjoy the peace of mind from knowing that a task will reliably get done every time because a script has been scheduled (you don't need to worry about the employee forgetting, making a mistake, or having an emergency come up)
  • As an under-resourced non-profit, write a script to automatically create personalized thank you emails to donors (these could even be fancy pdfs!)
  • As a recruiter, write a script to automatically email you when you haven't gotten back to a candidate in over a certain number of days (or email the candidate with a personalize message directly!)
  • As a communications expert, write a script to send personalized emails in bulk
  • As an administrative business partner (or otherwise incredibly organized individual), write a script to automatically color-code your executive's Google Calendar by type of event (e.g. coffee chat = green) or by which events are able to be rescheduled vs. fixed
  • As a proactive teammate, write a script to automatically send an email to your team asking for weekly meeting agenda topics in advance
  • As a data analyst, write a script to move structured data from a spreadsheet to a slide template for presentations
  • As a company culture champion, write a script to automatically match coworkers together for coffee/lunch chats