Introduction To Google Apps Script

A free, introductory course to give you a taste of Google Apps Script

🔥 Go from zero coding knowledge to automating your work

🔥 100% online video training course.

🔥 It's free! :)

Go from zero coding knowledge to automating your work with Google Apps Script.

This course will set you up to:

  • Understand what Google Apps Script is and why you should use it
  • Know the building blocks of Apps Script
  • Have the confidence to write your own programs
  • Build some cool automated tools you can use right away
  • Know your way around the Apps Script developer environment
  • ...and much, much more!

Each lesson is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own business.

This course will teach you the basic foundational techniques in Apps Script, even if you’re brand new to coding.

A little bit of Apps Script knowledge goes a long way!

Demand for technical careers is soaring and will continue to do so for decades to come. Coding literacy is fast becoming a skill that sets you apart from other job candidates in today’s job market.

Our jobs, and by extension our lives, are becoming ever more dependent on algorithms, automations, data and an ability to understand, interpret and communicate around these topics.

Don't get left behind!

Learn how to use Google Apps Script to automate boring tasks, save yourself time and build cool stuff!

Ready to join?


About the course

If you want to...

  • Learn how to code
  • Learn Google Apps Script (which means you'll know your way around Javascript)
  • See how you can customize your G Suite workflows
  • Automate tedious tasks at work
  • Build cool applications around Google Apps
  • Integrate your different Google Apps together

...then Introduction To Google Apps Script is for you.

Inside this course I share all the beginner-relevant knowledge I’ve built up over the past 5 years programming with Apps Script.

I’ve packaged it all into a series of simple, bite-size video lessons, complete with Google Sheet templates, that anyone can follow.

What's included:

📚 5 modules | 25 videos

Actionable, bite-size video lessons teaching key Apps Script topics.

💻 Templates and Source code!

All the templates and source code is provided with each module, available for your use:

🔄 Lifetime access to the course

Your enrollment in Introduction To Apps Script comes with lifetime access to the course material.

That way you can take a break from the material if you’re out of town, on vacation, or just swamped for a few days.

Interruptions happen, and your course videos will ALWAYS be here for you when you’re ready.

👩‍🎓 Certificate of Completion

Want to show off your newly acquired skills?

You’ll automatically get a certificate upon completing the course, which you can share or post on Linkedin.

Ready to join?


Why is this free?

I believe in giving back to this community.

I get a lot of emails and questions about Google Apps Script, so I saw a clear need for some structured training on this topic. So here it is. ;)

I've poured a lot of sweat and tears into this course, so if you enjoy it and get some value from these lessons, you can "pay me" by sharing this with a friend or colleague who you think might benefit. 😉

Your Instructor

Ben Collins
Ben Collins

Hi! I'm an experienced data analytics instructor and freelance spreadsheet developer.

I help individuals and businesses better understand their data through analytical insights and visualizations.

Over 50,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One, and other Fortune 500 companies.

My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and Google Workspace.

Google recognized me as a Google Developer Expert for Google Workspace Technology in 2019, one of only a handful worldwide.

I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Looker Studio, Microsoft Excel, BigQuery, SQL, and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
How much time does it take?
I’ve created a lot of content for you. Depending on your experience and comfort with technical topics, I’d estimate that it will take you 10 - 20 hours total time to get comfortable with the material. HOWEVER… I know you’re busy so each topic is divided into a series of 5-10 minute videos so you don’t have to plan days and days around studying this topic. I’d advocate doing the lessons in batches spread across a few days, weeks or months, to give yourself time to absorb the knowledge.
Will I get copies of the source code?
Yes! All the source code is provided, so you can make your own copies.
What if I can’t figure out something on my own?
The course is beginner-friendly and assumes no prior knowledge of coding, so I'm confident you'll be able to follow it through to the end. However, I get that you'll have your own specific questions. I'll point you to the best resources for asking those questions.
What if I don’t have a technical background?
Don't worry, you’re not alone! This course focuses on practical techniques and teaches concepts through real-world examples, so that you won’t get lost in abstract theories and dense lectures. As long as you aren’t afraid to roll up your sleeves and put some effort in, then you’ll be able to grasp the content of this course. You’re free to watch the lessons in any order and as many times as you like, so you can watch and re-watch topics if you want!
How is this course different from other online courses?
This course is Google Apps Script-focused and entirely practical. We start working in Apps Script immediately and concepts are taught through practical examples.
Is this course really free?