Learn Sheets Macros & Apps Script taught by Googler

Automate Your Spreadsheets & Boost Productivity

Created byRajiv Pujala

Last updated 8/2025

English

What you'll learn

Write powerful SQL queries in BigQuery to select, filter, aggregate, join, and analyze large datasets with ease.
Master advanced BigQuery SQL concepts including subqueries, window functions, arrays, structs, and nested data types.
Handle real-world data scenarios such as modifying schemas, transforming strings and dates, and working with NULLs and missing values.
Optimize BigQuery performance using techniques like partitioning, clustering, execution planning, and automation.
Apply Google-scale best practices and insider tips for writing efficient, clean, and production-ready SQL — taught by a Googler.

Course content

4 sections • 28 lectures • 3h 19m total length

Introduction0:38
Welcome to Google Sheets Macros & Apps Script – Taught by a Googler — your one-stop course to automate tasks, build powerful tools, and take your spreadsheets to the next level!
In this hands-on course, you'll learn how to:
Record Macros to automate repetitive actions
Write custom functions and workflows using Google Apps Script (JavaScript for Google Workspace)
Build real-world automations like approval workflows, data processors, custom menus, and more — the same way it’s done inside Google
Whether you're a spreadsheet power user, a business analyst, or a non-coder looking to unlock the true potential of Google Sheets, this course will teach you how to think like a Googler and work smarter, not harder.
No prior coding experience? No problem.
You’ll go from zero to script-savvy with clear, practical examples and guided walkthroughs.
? By the end of this course, you'll be building automations that impress your team and save hours every week.
Let’s get started!

1 Access a Sheet Tab with Google Apps Script10:12
This video teaches how to programmatically select and interact with specific tabs within your Google Sheet using Google Apps Script, a foundational skill for targeted automation.
2 Rename a Sheet Tab with Google Apps Script5:23
This video teaches how to programmatically change the name of any sheet tab in your Google Sheet using Google Apps Script.
5 Clear Values in a sheet tab using Google Apps Script6:03
This video teaches how to programmatically clear all data or specific ranges within a sheet tab using Google Apps Script.
6 Read the value from a cell using Google Apps Script4:04
This video teaches you how to retrieve the content of a specific cell from your Google Sheet using Google Apps Script's getRange().getValue() method.
7 Number of Rows and Columns in Sheet tab4:08
This video teaches you how to programmatically determine the total number of rows and columns, including the last populated row and column, within a sheet tab using Google Apps Script.
8 Read multiple values using For Loop10:16
This video teaches you how to efficiently read multiple values from a range of cells in your Google Sheet by iterating through them using a "for loop" in Google Apps Script.
9 Change a value in a cell4:35
This video teaches you how to programmatically modify the content of a specific cell in your Google Sheet using Google Apps Script's getRange().setValue() method.
10 Change multiple values in a cell6:41
This video teaches you how to efficiently modify the content of multiple cells in your Google Sheet at once, either by setting a range or iterating, using Google Apps Script.
11 Copy data from Sheet1 tab to Sheet2 tab7:45
This video teaches you how to programmatically transfer data from one sheet tab to another within the same Google Sheet document using Google Apps Script.
23 Insert a new sheet and rename it5:56
This video teaches you how to programmatically add a brand new sheet tab to your Google Sheet and immediately
24 Delete a sheet3:23
This video teaches you how to programmatically delete a sheet tab from your Google Sheet using Google Apps Script.

3 AND Function in Apps Script5:08
This video teaches you how to use the AND logical function within Google Apps Script to combine multiple conditions, returning true only if all conditions are met.
4 OR Function in Apps Script5:28
This video teaches you how to use the OR logical function within Google Apps Script to combine multiple conditions, returning true if at least one condition is met.
16 While Loop5:17
This video teaches you how to implement a while loop in Google Apps Script, allowing you to repeatedly execute a block of code as long as a specified condition remains true.
20 Dictionaries12:29
This video teaches you how to utilize dictionaries (also known as objects in JavaScript/Apps Script) to store and manage data as key-value pairs, improving data organization and retrieval.

12 onOpen10:07
This video teaches you about the onOpen simple trigger in Google Apps Script, which automatically runs a specified function whenever a user opens the associated Google Sheet.
13 Multiple Functions3:22
This video teaches you how to organize and manage your Apps Script code by breaking it down into multiple, reusable functions, improving readability and maintainability.
14 Dialog box4:48
This video teaches you how to create and display various types of dialog boxes (alerts, prompts, and custom HTML dialogs) in your Google Sheets using Google Apps Script to interact with users.
15 Sleep Function7:44
This video teaches you how to pause your Google Apps Script execution for a specified duration using Utilities.sleep(), which can be crucial for managing API call limits or allowing time for processes to complete.
17 Hide Sheets5:16
This video teaches you how to programmatically conceal specific sheet tabs in your Google Sheet using Google Apps Script, useful for decluttering or securing sensitive data.
18 Unhide Sheets4:57
This video teaches you how to programmatically reveal previously hidden sheet tabs in your Google Sheet using Google Apps Script.
21 Sort the data7:46
This video teaches you how to programmatically sort data within your Google Sheet based on single or multiple columns, in ascending or descending order, using Google Apps Script.
22 Record a Macro with custom tuning6:48
This video teaches you how to leverage the macro recorder in Google Sheets to automate repetitive tasks, and crucially, how to then edit and refine the automatically generated Apps Script code to create more dynamic and customized solutions.
25 Change Aesthetic values for Header17:40
This video teaches you how to programmatically adjust the visual appearance of header rows in your Google Sheet, including font styles, colors, and background, using Google Apps Script.
26 Authentication - who can run the macros17:40
This video teaches you about the crucial authorization process in Google Apps Script, explaining why and when scripts require user permission to access data or perform actions, and who typically needs to grant these permissions.
27 Consolidation using Formulas7:12
This video teaches you how to combine data from multiple sheets into a single, consolidated view within Google Sheets using various formulas like QUERY and IMPORTRANGE, allowing for dynamic updates.
28 Send an email9:01
This video teaches you how to send emails directly from your Google Sheet using Google Apps Script, including sending plain text, HTML emails, and emails with attachments.

Requirements

No prior SQL or BigQuery experience is required — this course is beginner-friendly and starts from the ground up.
A Google account to access BigQuery via Google Cloud (free tier is sufficient for practice).
Basic computer skills and comfort using web-based tools like Google Sheets or Google Drive.
Curiosity and willingness to learn — that’s the only real must-have!

Description

Welcome to Google Sheets Macros & Apps Script – Taught by a Googler, your one-stop course to automate tasks, build powerful tools, and take your spreadsheets to the next level!

In this hands-on course, you'll learn how to:

Record Macros to automate repetitive actions.
Write custom functions and workflows using Google Apps Script (JavaScript for Google Workspace).
Build real-world automations like approval workflows, data processors, custom menus, and more — the same way it’s done inside Google. You'll gain practical skills to streamline operations and boost efficiency across your projects. Plus, discover how to debug your scripts effectively and implement best practices for scalable, maintainable code.

Whether you're a spreadsheet power user, a business analyst, or a non-coder looking to unlock the true potential of Google Sheets, this course will teach you how to think like a Googler and work smarter, not harder.

No prior coding experience? No problem. You’ll go from zero to script-savvy with clear, practical examples and guided walkthroughs. By the end of this course, you'll be building automations that impress your team and save hours every week. Empower yourself to transform tedious manual work into intelligent, automated solutions. Let’s get started!

Thank you for taking this course, I wish you all the best

Who this course is for:

Beginners who want to learn SQL using BigQuery — no prior experience needed!
Aspiring data analysts, engineers, or data scientists looking to build strong foundations in cloud-based SQL.
Working professionals who want to upgrade their SQL skills and understand how things work at Google-scale.
Students and graduates preparing for tech careers, internships, or certifications in data-related fields.
Product managers, business analysts, and PMMs who want to query large datasets and make data-driven decisions confidently.

Learn Sheets Macros & Apps Script taught by Googler

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Section 1: Google Sheets Interaction & Data Manipulation11 lectures • 1hr 8min

Section 2: Core Programming Logic & Data Structures4 lectures • 28min

Section 3: Advanced Apps Script Features & Practical Applications12 lectures • 1hr 42min

Requirements

Description

Who this course is for: