Apps Script Blastoff!

Learn what Google Apps Script is and why you should learn it.


Lesson 1

A free, introductory course teaching Google Apps Script from scratch
with Ben Collins

Build your first automations using Macros and see the code behind them.


Lesson 2

Understand the Apps Script developer environment and write your first code.

Hello World!

Lesson 3
Create  your own custom formulas to use in Google Sheets.

Custom Functions

Lesson 4

Starting Templates and Solution Files

Use these free templates and what you’ve learned to create spreadsheet masterpieces.

What’s Inside

Who's teaching this course?

Google Sheets Developer & Instructor

Hi, I'm Ben Collins!

I'm an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards.

I work primarily with Google Sheets, Apps Script and Data Studio, and also have extensive experience with Excel, SQL and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C.
@2019 Collins Analytics LLC
All rights reserved

The Landing Page Builder For Marketers

The Collins School of Data

What You'll Get

  • Access to all 25 video lessons
  • Each lesson is 5 - 15 minutes
  • All the templates
  • All the source code
  • Best of all, it's free!

Go from zero coding knowledge to automating your work

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!

You will learn the basic foundational techniques in Apps Script, even if you’re brand new to coding.

Is this course really free?


I wanted to give back to the community and say a big thank to all those who have purchased one of my premium courses. 

I get a lot of emails and questions about learning 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.

Who is this for?

This course is intended for complete beginners up to intermediate level users of Google Apps Script, who want to learn how to automate processes and unlock the full potential of their G Suite experience.

No prior knowledge of coding is assumed.



A free, introductory course teaching Google Apps Script from scratch

Module 1: Introduction to Google Apps Script

An introduction to variables and data types in Apps Script.

Variables & Data Types

Lesson 5
Learn how to use math operators and conditional logic in your code.

Operators & Conditionals

Lesson 6

Functions are the backbone of Apps Script. Learn about them in this lesson.


Lesson 7
An introduction to arrays and how to use them.


Lesson 8

Module 2: Apps Script Fundamentals

An introduction to objects and how to use them.


Lesson 9

All the looping knowledge you need to know to get started.


Lesson 10
Techniques to get data out of a Google Sheet using Apps Script

Getting data out

Lesson 11
Working with data in your Apps Script code.

Working with data

Lesson 12

Pasting data into Google Sheets from Apps Script.

Inserting data

Lesson 13
Add your own custom menus to your Google Sheets.

Adding custom menus

Lesson 14

Module 3: Apps Script and Google Sheets

Learn how to use Apps Script to create custom formulas in Google Sheets.

Adding formulas

Lesson 15

How to format Google Sheets using Apps Script code.

Formatting Sheets

Lesson 16
How to add charts to Google Sheets via Apps Script.

Adding charts

Lesson 17
An introduction to the project: an automated feedback tool.

Project Introduction

Lesson 18
An introduction to Google Forms for this project.

Google Forms

Lesson 19

How to connect to Google Forms with Apps Script.

Forms + Apps Script

Lesson 20
How to pass data from your Google Sheets into your Google Forms.

Sheets to Forms

Lesson 21

Module 4: Automated Feedback Tool (PROJECT)

How to send emails from your Google Sheets window using Apps Script.

Sending emails

Lesson 22

More advanced formatting options for emails with Apps Script.

Formatting emails

Lesson 23
Setting triggers to run Apps Script functions automatically.

Automation with triggers

Lesson 24
Completing the project with automation.

Automating Forms

Lesson 25

Apps Script Blastoff!