Spreadsheet Automation 101
5.0 (6)
4 Days
·Cohort-based Course
Automate your Google Sheets so they feel like magic. Leave spreadsheet hell behind. Run your entire business in Google Sheets for free.
Spreadsheet Automation 101
5.0 (6)
4 Days
·Cohort-based Course
Automate your Google Sheets so they feel like magic. Leave spreadsheet hell behind. Run your entire business in Google Sheets for free.
Course overview
You Can Become a Spreadsheet Wizard
Too much of your time is spent in spreadsheet hell. Learning, researching, functions and formulas can feel like a lonely job.
Learn to build magical & effective sheets by learning how to automate with Apps Script -- saving you thousands of dollars, hours, and therapy sessions.
Spreadsheet Automation 101 is for
01
Google Sheet nerds who want to take their Google Sheets to the next level. Maybe you already use Zapier or are thinking of it.
02
Startup Founders who want to build an MVP organization that will last through the first years of their newest business.
03
Managers who want to automate their team updates, and keep on top of projects better.
Key outcomes
Learn to automate Google Sheets, so your sheets perform like web apps
Learn to automate almost anything, from data analysis to email notification. You can make Google Sheets do your bidding, even while you sleep. I call this Advanced Sorcery.
You'll learn how to write, read, and use Google Apps Script, faster.
You'll learn how to write actual code in Google Apps Script. Also learn how to read code and do more, faster. We use practical, every day uses of code to learn how it can be used most effectively. I've used code for more than 8 years.
Automate anything, so that your sheets work while you sleep.
I'll show you all the triggers possible for your Apps Script. Trigger scripts to run while you sleep. Trigger email sequences. Trigger reports. Trigger nearly anything.
Learn what Google Sheets can't do, so you don't waste time!
I've lived to tell the tale. I've broken Google Sheets and run up against its limits. Find out what's actually impossible to do in Google Sheets. You can learn to overcome some of these limits.
Spreadsheet Automation 101
See what people are saying
Don J.
Rita X.
Nicole
Ben S.
Andrey
Kenneth L.
Meet your Merlin
Andrew Kamphey
Google Sheets Wizard
I run BetterSheets.co where you can learn to design good looking Google Sheets. Join me as I dive deep into Apps Script. Getting you from knowing nothin to wielding wild magical programming skills.
I worked at a startup that used Google Sheets and I knew nothing about Apps Script. In two weeks, I learned to write one line of Google Script that was used for years, and got me a HUGE promotion. I can teach you my ways.
For me, learning Google Script was the tipping point. Taking me from minimum wage jobs to a $75,000 Director of Digital Operations position. This skill unlocked infinite possibilities and I'm sharing what I learned so your life can change in a positive way too.
Course syllabus
Week 1
Jun
12
Office Hours: Get Value
Jun
13
Office Hours: GetValues
Jun
14
Office Hours: Email Yourself
Email Yourself
Section 3: Email Yourself
Access APIs
Access APIs
Bonus Videos
Bonus Material
Post-course
Jun
21
Office Hours: Access APIs
Course schedule
8-10 hours in 1 week
Friday Jam
6:00 PM - 7:00 PM EST
The Friday before our session, meet your fellow future wizards. Spend time sharing what, if anything, you're working on. Share sheets you've made before. Or just toast to your fellow future wizards.
Monday - Thursday
6:00pm - 7:30pm EST
We'll meet each day from Monday to Thursday. Strap in and hold on tight. We're building, making, creating each and every day!
Programming Pre-Work
2 hours per week
On your own time you'll have to watch the live session pre-work. You'll also get access to all code, so if writing code is daunting, don't worry. Simply copy and paste and it'll work.
I would suggest to schedule 30 minutes each day for this before the live session.
Friday Lab
6:00 PM - 7:30 PM EST
Bonus Q&A session to bring your projects and debug anything you're working on.
Learning is better with cohorts
Active learning, not passive watching
This course builds on live workshops and hands-on projects
Interactive and project-based
You’ll be interacting with other learners through breakout rooms and project teams
Learn with a cohort of peers
Join a community of like-minded people who want to learn and grow alongside you
Frequently Asked Questions
Stay in the loop
Sign up to be the first to know about course updates.