Spreadsheet Automation 101

5.0

(6 ratings)

·

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.

See what people are saying

        WOW! Thank you Andrew, that was so beyond what I was hoping for! Your help with my little sheet project is appreciated more than you know. I now have new ideas I never thought of before to use Sheets in my business to actually make money from.
Don J.

Don J.

Don Jones Marketing
        This first day was amazing. I learned a lot and got great feedback in such a short timespan. Glad to be part of this.
Rita X.

Rita X.

Analyst | Programmer
        I was able to improve my understanding of how to leverage the tool as much as possible so that I can rely less on Zaps or other software for automations.
Nicole

Nicole

Better Sheets Member
        Andrew shows how humble Google Sheets solutions that are sometimes simple but provide real down to earth value and solutions to customers with common real world solutions. You can use this knowledge to build and provide personal or client solutions.
Ben S.

Ben S.

Better Sheets Member
        I can organise, control, and automate so many things now. I even got a promotion by learning this skill. I want to thank Andrew who is the most helpful guy on the internet!!! I threw some really hairy problems at him and like a trooper he never said No, he always helped me to the best of his ability.
Andrey

Andrey

Better Sheets Member
        The creativity, expertise and problem solving you brought to the working sessions was really incredible. I so rarely get to work with developers who can take a concept and run with it. I appreciated seeing the workarounds and approach you took with my requirements and I found that super valuable!
Kenneth L.

Kenneth L.

Product Manager
A pattern of wavy dots
Be the first to know about upcoming cohorts

Spreadsheet Automation 101

|

Bulk purchases

Meet your Merlin

Andrew Kamphey

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.

A pattern of wavy dots
Be the first to know about upcoming cohorts

Spreadsheet Automation 101

|

Bulk purchases

Course syllabus

01

Discover where wizards work

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.

02

Bring data from the spreadsheet to code and back again

Learn to access data in any sheet

Learn 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.

03

Conjure email from Google Sheets

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.

04

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

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.

05

Automate nearly anything

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.

06

Access Any Data

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

07

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

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.

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.

A pattern of wavy dots
Be the first to know about upcoming cohorts

Spreadsheet Automation 101

|

Bulk purchases

Learning is better with cohorts

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

What if I break my spreadsheet?
What happens if I can’t make a live session?
I work full-time, what is the expected time commitment?
What’s the refund policy?
How do I contact you after the course?
A pattern of wavy dots
Be the first to know about upcoming cohorts

Spreadsheet Automation 101

|

Bulk purchases

Stay in the loop

Sign up to be the first to know about course updates.