Automation with Apps Script

Automate tedious tasks and build killer applications in Google Sheets

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.


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?

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 20,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 G Suite.

Google recognized me as a Google Developer Expert for G Suite 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 Data Studio, Microsoft Excel, SQL and Tableau. I've previously taught data courses and workshops for General Assembly in Washington, D.C..


Course Curriculum


  Introduction
Available in days
days after you enroll
  Apps Script Building Blocks
Available in days
days after you enroll
  Copying Data
Available in days
days after you enroll
  Importing CSV Files
Available in days
days after you enroll
  Automated Survey Response Tool
Available in days
days after you enroll
  Sheets to Calendar
Available in days
days after you enroll
  Introduction to APIs
Available in days
days after you enroll
  College Scorecard API
Available in days
days after you enroll
  MailChimp API
Available in days
days after you enroll
  PayPal API (OAuth Example)
Available in days
days after you enroll
  Facebook API (OAuth example)
Available in days
days after you enroll
  Automated Document Generator
Available in days
days after you enroll
  Closing
Available in days
days after you enroll

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

Get started now!