ONLEARN COURSE
Automate Your Workflow with Google Apps Script in Sheets
Unlock powerful custom functions, triggers, and automations directly within your spreadsheets to save hours and eliminate manual tasks.
IntermediateEnglish3 sections5 hours515 students
What you’ll be able to do
- Write basic to intermediate Google Apps Script functions to automate tasks in Google Sheets.
- Understand and utilize Sheet, Range, and Cell objects for data manipulation.
- Create custom menus and dialogs to trigger scripts directly from Google Sheets.
- Implement event-driven scripts (e.g., onOpen, onChange) for dynamic automation.
- Debug Apps Script code effectively using the built-in debugger and Logger service.
- Automate email notifications and data transfers between sheets.
- Develop practical, real-world automation solutions for common spreadsheet tasks.
Inside this course
3 sections · 15 activities · 5 hours total length
01Getting Started with Google Apps Script
- Introduction to Google Apps Script and the Script Editor10:00
- Your First Script: 'Hello World' in Google Sheets15:00
- Understanding Script Bindings and Permissions12:00
- Working with Logger and Basic Debugging10:00
- Exercise: Create a Simple Greeting Function20:00
02Interacting with Google Sheets Data
- Accessing Sheets, Ranges, and Cells15:00
- Reading and Writing Data to Cells and Ranges20:00
- Manipulating Rows and Columns15:00
- Filtering and Sorting Data with Scripts18:00
- Exercise: Data Cleanup and Formatting25:00
03Advanced Scripting and Automation Triggers
- Creating Custom Menus and Dialogs15:00
- Understanding Event-Driven Triggers (onOpen, onChange)18:00
- Time-Driven Triggers and Schedulers15:00
- Sending Automated Emails with GmailApp20:00
- Project: Automated Daily Report Emailer30:00
About this course
Unlock the power of automation in Google Sheets! This intermediate course teaches you to write custom scripts with Google Apps Script, transforming repetitive tasks into efficient, one-click solutions.
Who this is for
- Office professionals and data analysts who use Google Sheets regularly.
- Anyone looking to automate repetitive tasks and save time in their workflow.
- Business owners or team leads seeking to streamline data management processes.
- Individuals interested in learning practical coding skills for productivity gains.
Before you begin
- A Google account (free to create)
- Basic familiarity with Google Sheets functions and interface
- No prior coding experience required, but basic logic understanding is beneficial
LEARNING EXPERIENCES
281 ratingsLearner ratings
4.8 / 5 · Average learner rating
A few useful details
How will I learn?
Work through the course sections and activities in your Onlearn course player, at your own pace. Your progress is saved to your account.
Is this a subscription?
No. Each course is purchased separately with one payment.