Cohort 5

Automate your Google Sheets so they feel like magic. Leave spreadsheet hell behind. Run your entire business in Google Sheets for free.

Andrew Kamphey

Google Sheets Wizard

Spreadsheet Automation 101

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 &amp; effective sheets by learning how to automate with Apps Script -- saving you thousands of dollars, hours, and therapy sessions.

You Can Become a Spreadsheet Wizard

Google Sheet nerds who want to take their Google Sheets to the next level. Maybe you already use Zapier or are thinking of it.

Startup Founders who want to build an MVP organization that will last through the first years of their newest business.

Managers who want to automate their team updates, and keep on top of projects better.

Spreadsheet Automation 101 is for

Key outcomes

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.

Learn to automate Google Sheets, so your sheets perform like web apps

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.

You'll learn how to write, read, and use Google Apps Script, faster.

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.

Automate anything, so that your sheets work while you sleep.

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.

Learn what Google Sheets can't do, so you don't waste time!

See what people are saying

Meet your Merlin

In the first live session, we will code. Access Apps Scripts and find out where the code lives in a Google Sheets. Everyone will open up Google Sheets and type out code that will absolutely work. You'll learn how to do simple math behind the scenes and return data to a cell.

Discover where wizards work

Learn to access data in any sheetLearn code to access data in sheets, rows, columns, or cells. Like a wizard learning the dark arts, you'll feel more powerful with every stroke.

Bring data from the spreadsheet to code and back again

Learn how to harness sending email from your Google Sheet. Send reminders to yourself, or reports to teammates. Send links to access sheets or even download sheets.

Conjure email from Google Sheets

Learn to create a custom menu right along side Help in the top menu bar of Google Sheets. Bring your functions in Apps Script to the front end user of your Google Sheets. Customizing the sheet makes Google Sheets feel like your own personal spellbook.

Bring out the hidden spells, so that others can use your sheets better

Automate your code. Learn how to use installable triggers in Apps Script to create automations. Make your code come alive every day, or every week and do as you command.

Automate nearly anything

One of the most complex parts of Google Sheets is being able to access rows and columns of information. Also known as Arrays of data. Learn the For Loop, a powerful bit of code, to find what you're looking for in a row or a column. Like a wizard would learn to orient and cast their spells precisely

Access Any Data

Learn to use the UrlFetchApp function inside AppsScript to access any open API. Take data from outside and bring it systemically into Google Sheets without having to use expensive software. Maybe you'll create new software ;) Like a wizard harnessing extraordinary power from another dimension.

Learn how to access an API from Google Sheets, without expensive software.

Course syllabus

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.

Friday Jam

We'll meet each day from Monday to Thursday. Strap in and hold on tight. We're building, making, creating each and every day!

Monday - Thursday

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.

Programming Pre-Work

Bonus Q&amp;A session to bring your projects and debug anything you're working on.

Friday Lab

Course schedule

This course builds on live workshops and hands-on projects

Active learning, not passive watching

You’ll be interacting with other learners through breakout rooms and project teams

Interactive and project-based

Join a community of like-minded people who want to learn and grow alongside you

Course completed by

About this course

Get notified about the next cohort

Learn from live sessions