Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Add Apps Script to your Skillset. Automate your business tasks → LIKE A PRO!
Too much of your time is spent in spreadsheet hell. Learning, researching, functions and formulas can feel like a lonely job.
Build magical & effective sheets by learning how to automate with Apps Script -- saving you thousands of dollars, hours, and therapy sessions.
Key outcomes
Learn to automate Google Sheets, so your sheets perform like web apps
Learn to automate almost anything, from data analysis to email notification. You can make Google Sheets do your bidding, even while you sleep. I call this Advanced Sorcery.
You'll learn how to write, read, and use Google Apps Script, faster.
You'll learn how to write actual code in Google Apps Script. Also learn how to read code and do more, faster. We use practical, every day uses of code to learn how it can be used most effectively. I've used code for more than 8 years.
Automate anything, so that your sheets work while you sleep.
I'll show you all the triggers possible for your Apps Script. Trigger scripts to run while you sleep. Trigger email sequences. Trigger reports. Trigger nearly anything.
Learn what Google Sheets can't do, so you don't waste time!
I've lived to tell the tale. I've broken Google Sheets and run up against its limits. Find out what's actually impossible to do in Google Sheets. You can learn to overcome some of these limits.
Course Content
- 17 section(s)
- 104 lecture(s)
- Section 1 Get Started Automating
- Section 2 Google Apps Script Fundementals
- Section 3 Get Data From a Google Spreadsheet: GetValue
- Section 4 Get More than a Single Piece of Data From a Google Spreadsheet: GetValues
- Section 5 Send Email From Google Sheets
- Section 6 Access APIs
- Section 7 Create Your Own Custom Functions in Google Sheets
- Section 8 Optional: Additional API Examples
- Section 9 Simple Automations in Google Sheets
- Section 10 Automation Examples
- Section 11 Optional: Advanced Uses of Google Sheets
- Section 12 Use Google Sheets as a REST API
- Section 13 Import to Google Sheets and Export Data From Google Sheets
- Section 14 Overcome Apps Script Errors
- Section 15 Integrate AI into Google Sheets
- Section 16 Optional: See AI In Action
- Section 17 Live Consulting Sessions
What You’ll Learn
- Save thousands of dollars by automating tasks instead of hiring someone
- Break free from endless manual tasks in spreadsheets.
- Automate your business. Your sheets can work while you sleep
- Automate email notifications for timely communication
- Unlock the Full Potential of Google Sheets with Triggers
- Learn what Google Sheets can't do, so you don't waste time!
- Automate data cleaning processes for accurate records
- Generate instant reports without manual intervention
- Minimize human errors in data entry and calculations
- How to write, read, and use Google Apps Script, faster
- Build sheets that behave like interactive web apps
- Focus on important tasks while routine operations run automatically
- Ensure data is accurate and consistent throughout your sheets
- Automate data analysis processes for faster insights
- Tailor Apps Script to create personalized, effective solutions
- Automate complex workflows for seamless operations of your business
- Develop coding skills in Google Apps Script
- Apply coding practically for everyday tasks
- Understand various Google Apps Script triggers for precise automation
- Implement error handling techniques for robust scripts
- Schedule tasks for specific dates and times automatically
Skills covered in this course
Reviews
-
NNeel Vithlani
Amazing course
-
JJason Lunde
I love how passionate and excited he is about automation and the endless possibilities
-
MMagesh Ramalingam
Good starter
-
JJomar Capongga
interesting so far