Automation With Apps Script

Automate tedious tasks and build killer applications using Google Sheets

Save Time

Save time at work. Automate the tedious tasks.

A Premium Training Course From The Collins School Of Data


Save hours with Apps Script!

Take your analysis skills and career to the next level with Apps Script.

Be in high demand with clients. Get your pick of projects. Build fantastic Google Sheets-based applications that are impossible with formulas or add-ons alone.
Learn to do Automation with Apps Script in this premium, online video training course.


Automate your data

Connect Google Sheets to external web services to import your own data.

Boost your career

Take your career to the next level.

@2020 Collins Analytics LLC
All rights reserved

Access to the Private Facebook Group

Your enrollment is backed up with support.

Join the private Facebook group for students. Ask questions, share insights and knowledge, share your wins, and connect with other students.

I’ll be hanging out there to answer your questions.


All of the Templates and Script Files

There are links under every video to the templates and script files. This alone will save you hours of time.

Lifetime Access To The Course

Your enrollment in the Automation with Apps Script course 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

Lifetime access includes all future updates and upgrades at no extra charge.

This is my way of ensuring that Automation with Apps Script remains an excellent long-term investment for you and your business.

Automatically import CSV data from folders on Drive or from Gmail attachments.

Onboarding new clients? Or new employees? Generate all the documents you need, pre-filled, with just a single click.

Send events in Google Sheets directly to your Google Calendar.

Connect to external web services to import data into Google Sheets, with examples from NASA, MailChimp, PayPal, Facebook and others.



Access to first 8 modules
Includes Templates & Script Files
Includes Future Updates
Never Expires
Private Facebook Q&A Group
Certificate Upon Completion
30-Day Money Back Guarantee
Get The Starter Course
$199 USD

How much time does it take?

I’ve created a lot of content for you… approximately 11 hours of video content. Depending on your experience and comfort with Apps Script concepts, I’d estimate that it will take you 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-15 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 weeks or months, to give yourself time to absorb the knowledge.

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.

Will I get copies of the datasets and solutions?

Yes! All the templates and script files are provided, so you can download your own copies. The template and script file links are available under each lesson. Clicking on the template links will make a copy on your Drive account.

What if I can’t figure out something on my own?

There’s a private Facebook group for students! As a member of this group, you can ask questions, share your ideas and knowledge, and connect with other students.

How do I get access to the private course Facebook group?

When you enroll, you’ll receive the link in an email. It’s also listed in the Index of the first module. Once you’ve joined, feel free to introduce yourself and let us know how you plan to use your newfound knowledge.

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. There is just enough theory to allow you to build useful applications, but not too much that it becomes overwhelming. You start working with Google Apps Script immediately and concepts are taught through practical examples.

What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

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.

Do you offer Parity Purchasing Power discounts?

Yes, I want this course to be affordable to folks overseas in developing countries, who would otherwise not be able to purchase them. How does it work? Drop me a line with proof of where you're based and which course you're interested in, and I'll be glad to offer you a PPP discount on the course.

Why am I being charged VAT?

In order to comply with EU regulations, buyers in the EU will be charged VAT at checkout. This money is passed on to the relevant EU tax collection agency.

Can you provide an invoice for my company?

Yes, of course! You’ll receive a receipt after you purchase, but if you need something additional, just drop me a line.

Frequently Asked Questions

Ok, so why should you learn Apps Script?

Great question! Here are my top three reasons how Apps Script could help you:

#1 You can build cool and useful tools immediately

#2 You start from familiar territory

Once you know a little bit of Apps Script, you can immediately start to build useful tools.

The cool tools I was building was the main reason I was able to stick with learning Apps Script when I hit the inevitable hurdles.

It’s really motivating to see early wins when you’re learning a new subject. Especially when you’re learning something that’s technical and potentially challenging. 

If you use Gmail, Google Sheets, Docs, or other G Suite apps, then you’re already familiar with the look and feel of Google tools. Apps Script is no different and seamlessly extends the possibilities of what you can do with G Suite tools.

It’s very, very easy to get started. There’s no risk of you getting lost in the terminal installing packages or configuring programs.

There are only three steps to get started: 1) Open your browser, 2) Create a new Apps Script project, and 3) Start coding!

#3 No configuration or setup required


Certificate of Completion

Want to show off your newly acquired skills? Or convince your boss to cover the cost?

You’ll get a certificate upon completing the course, for you to share or post on your résumé or Linkedin.

Team Packages

Want multiple members of your team to take the course?

Take advantage of group savings for teams of 5, 10 or 20. Team packages include everything in the Master Package above. 

5 Licences for $124910 Licences for $239920 Licences for $4485


An introduction to the course and notes to help you get the most from the course.

What will you automate today?

Module 1: Introduction

Meet Your Instructor: Ben Collins

Hi! I'm an independent G Suite Developer, specializing in Google Sheets, and the founder of The Collins School of Data.

I create online courses and write about working with data, with a particular focus on data analytics using Google Sheets, Apps Script and Data Studio.

Since 2017 I've created seven online courses teaching professional spreadsheet techniques, taken by more than 20,000 people.

In 2019, I was honored to become a Google Developer Expert (GDE) for the G Suite Technology branch.  The GDE award is given out by Google to only a handful of experienced, recognized developers of Google technologies.

Who is this course for?

This course is for you if you answer YES to any of the following questions:

  • Do you want a faster way to get data into Google Sheets?
  • Do you want to stop doing the same manual tasks over and over?
  • Do you want to build applications on top of Google Sheets?
  • Are you already a Google Sheets power user who wants to take the next step after formulas?

Are there any prerequisites?

You should be familiar with Google Sheets and have had at least some prior exposure to Apps Script, for example through Macros or custom functions. 

(Note: If you’re brand new to Apps Script then I recommend that you also sign up for the free Apps Script Blastoff course, and work through that one first.)

What others are saying

Great course, learn some fairly complex techniques at a pace that allows you to keep up.

- Brett ⭐⭐⭐⭐⭐

If you want to learn how to develop useful programs and make Google work for you, this course is perfect.

- Corey ⭐⭐⭐⭐⭐

You do a really nice job of summarizing and explaining a lot of complex concepts in a short amount of time. Well done!

- Beau ⭐⭐⭐⭐⭐

I have been telling everyone in my position (we are not coders, we are managers) that these courses are worth our time and money to go through. So helpful, but not overwhelming.

- Jeff ⭐⭐⭐⭐⭐

Very informative and useful course to begin building app scripts to simply your workflow.

- Michael ⭐⭐⭐⭐

This course is a great way to get the basics of Google Apps Script and then smoothly transition into more intermediate and advanced concepts.

- Todd ⭐⭐⭐⭐

What's included?

The Automation with Apps Script Course is an online video course. This means you can watch the videos anytime you want.

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

✅ All script files for you to follow along

✅ All the templates for your own use

✅ Access to the private course Facebook group for Q&A

✅ Certificate upon completion

Starter Course

Access to first 8 Modules
Templates & Script Files
All Future Updates
Never Expires
Private Facebook Q&A Group
Certificate Upon Completion
30-Day Money Back Guarantee
Get The Starter Course
$199 USD


Master Package

Get The Master Package
$299 USD
Access to all 12 Modules

Includes OAuth API Example

Includes Template Generator Example

All Templates & Script Files
All Future Updates
Never Expires
Private Facebook Q&A Group
Certificate Upon Completion
30-Day Money Back Guarantee
Want multiple members of your team to take the course?

Take advantage of group savings for teams of 5, 10 or 20. Team packages include everything in the Master Package above. 

5 Licences for $124910 Licences for $239920 Licences for $4485

Team Packages

Fundamental topics within Apps Script, including an overview of the documentation, Variables, Functions, Objects, script performance and much more!

Module 2: Apps Script Building Blocks

This module focuses on working with data in Google Sheets, covering everything from copying data to another Sheet to setting schedules to run your scripts.

Module 3: Working With Data in Google Sheets

How to automate the tedious task of importing CSV data from individual files, from folders of files or from email attachments.

Module 4: Working With CSV Files

Build a time saving tool that automatically creates draft Gmail replies to survey responses from a Google Form.

Module 5: Automated Survey Response Tool

Connect Google Sheets to Google Calendar and use Apps Script to transfer data and create calendar events.

Module 6: Sheets To Calendar

An introduction to APIs and how to retrieve data from third-party web services and transfer into Google Sheets, including an example using a NASA API!

Module 7: Introduction To APIs

Module 8: College Scorecard API Example

An API case study using publicly available College data, including how to deal with paginated data.

Module 9: MailChimp API

An API case study using the MailChimp API, showing how to do basic authentication with API Key in the headers.

Module 10: PayPal API (OAuth Example 1)

An API case study using the PayPal API, showing how to connect using the OAuth 2 authentication protocol.
An API case study using the Facebook API, showing how to connect using the OAuth 2 authentication protocol and Google's OAuth 2 Apps Script library.

Module 11: Facebook API (OAuth Example 2)

Build a tool to save time by automatically generating pre-filled documents, for example when you onboard new clients or employees or students.

Module 12: Automated Template Generator


Access to all 12 modules
Includes OAuth API Examples
Includes Templates & Script Files 
Includes Future Updates
Never Expires
Private Facebook Q&A Group
Certificate Upon Completion
30-Day Money Back Guarantee
Get The Master Package
$299 USD

Most Popular

Most Popular