Become great at automation with Apps Script

Online course

By David Sottimano,

Independent consultant

Course length: 5h 06min

Sign up to All-Access

English subtitles Certificate included

Some of the companies that train their teams at CXL:


Learn by example and by building mini applications to automate your daily workflow. This course focuses on practical skills and touch on theory when it is required.

Understanding what’s possible, where to find information, and understanding general concepts are more important than memorization, therefore no prior programming experience is required.

Advanced concepts will be broken down into manageable chunks and make sure you’re confident before heading into the next phase of learning.

Introduction video (4 minutes)

Skills you will master

APIApps ScriptAutomationGoogle SheetsJavaScriptMarketing automation

Alex B.

CXL has helped me tremendously in my journey to become the best digital marketer I can be.

It has opened my eyes to the capabilities of tools like GTM and Google Sheets. You guys have humbled me by teaching me that there’s so much more to learn!

Ap S.

CXL is just the best place to grow for a marketer. I learned more in a few months via CXL than what I learned in 8, 9 months on my own.

After taking this course you’ll…

  • Develop a file explorer in Google docs that allows access to your entire organization’s repository.
  • Understand the basics of Google Apps Script, where it can be used, it’s limitations, and how you can use Apps Script to automate your workflow.
  • Since Apps Script is JavaScript, you’ll learn the basics of this programming language as well. We’ll go through data types, functions, object, methods and more.
  • You’ll learn how to approach a problem with a developer mindset. Programming isn’t about memorization, it’s about problem solving and being able to find the answer.

David Sottimano

Independent consultant

David’s marketing career has taken him from sales/PR all the way to technical SEO and development. He’s worked and lived in 3 continents for prestigious clients and agencies across the world, specializing, but not limited to technical SEO. For the past 3 years, he’s dedicated most of his time to self-teaching development to automate most of his work and deliver better results for clients.

Notable roles: Senior consultant with Distilled/DMG, previous Moz associate and has been running his own consultancy for the past 5 years.

Your course curriculum

Automation with Apps Script

1 What is Apps Script?

For the beginner, we take a look at what Apps Script is, what it can do, where it lives in the Google Workspace environment, and talk about permissions. Topics covered: What Apps Script is, where to write Apps Script code in Docs, Sheets, Slides and ho

2 Your first script

We’ll write our first function that checks if a cell contains any word in a list. Topics covered: Write your first Apps script function in SheetsLearn how to run the function as a custom function from a Sheet cell and in the web IDELearn basics of Java

3 First look at the Apps Script Documentation

Being able to read and understand the documentation is the key to success, also, being able to describe your problem accurately so you can search stackoverflow will be essential. We’ll go through some lingo and explore the documentation together. Topic

4 Writing pseudocode and pulling data from an API

The goal is to pull data in from an API and output to a sheet. Before we even start writing code, we’ll correctly step through the problem first and write code last. Topics covered: Understand the basics of an API, HTTP request, JSON, and how to pull t

5 Refactoring our first function

Refactoring (or rewriting) our first function to include error handling, logging, JS DOC and more. Topics covered: Understand all the weird ways you can declare a function in Apps Script (JS) , subtle differences of ES6 including variable types and exp

6 Storage, caching and permissions in Apps Script

We’ll go through how to store data efficiently in Apps Script while exploring how roles/permissions affect storage of data and how to share scripts securely. Topics covered: Learn how to store/retrieve data in Properties ServiceLearn how to use the cac

7 Create a bookmarking service

We’ll create our first mini application that will allow you to turn a spreadsheet into a bookmarking service Topics covered: How to create a web appCreate a useful application using more advanced Apps Script featuresMake an application you’ll use every

8 Building your first add-on

We’ll look at the mechanics behind building a Sheets add-on, what the necessary components are and how to communicate between the client and server side. Topics covered: Write your first sheets add-onUnderstand how to communicate between the add-on and

Show off your hard-earned skills and strengthen your profile.

LinkedIn found that people who add credentials to their profile receive 6x more profile views than those who don’t.

Add your certificates to your profile, share your accomplishments with the world, and join our alumni network.

Subscribe to CXL and get access

  • 120+ courses (full list here) on all aspects of data-driven marketing (new courses added every month)
  • 10 minidegrees that give you advanced level skills

Got a team, multiple users? Get our Teams All-Access plan instead.

The CXL guarantee

  • 7-day no questions asked money back period
  • You can immediately apply learnings and improve your results.

Need help convincing your boss?

Click here for a pitch deck, swipe files and tips.

Subscribe to CXL

Get access to this and 100+ other training programs.

See plans and pricing

or

Request a free trial (for teams 2+)

Learn Apps Script: FAQ

What will you learn in this course?

After taking this course, you will:

  • Develop a file explorer in Google docs that allows access to your entire organization’s repository.
  • Understand the basics of Google Apps Script, where it can be used, it’s limitations, and how you can use Apps Script to automate your workflow.
  • Since Apps Script is JavaScript, you’ll learn the basics of this programming language as well. We’ll go through data types, functions, object, methods and more.
  • You’ll learn how to approach a problem with a developer mindset. Programming isn’t about memorization, it’s about problem solving and being able to find the answer.

What does the course include?

Our Apps Script training includes 9 lessons, 32 downloadable resources, 5h 06min of video material, several assignments, and a final exam.

Are subtitles available for the lessons?

Lessons have English subtitles and transcriptions available.

Will I receive a certificate of completion?

After taking this course, you will receive the Apps Script Certification from CXL, with credentials that you can add to your LinkedIn profile.

What is the refund policy?

All plans come with a 7-day refund period .

How long will it take for me to finish it?

This is entirely up to you – it’s how many study hours per week you can put in. This course is 5h 06min long.