Google Apps Script Uncharted - Learn Google Spreadsheets Office Automation

With online-based Google Spreadsheets
Build an office automation system all in one go! ➰

Now programming
When it starts! 💻

Have you ever wondered how our company, with its rapid growth over the past six years as KuO RocketOO, manages 5,400 products, an average of 50 purchase orders per week, and over 20 warehouses? From collecting purchase orders to sorting, inventory checks, and receiving, all tasks are automated. On the ordering and receiving confirmation dates , tasks are completed with just a few clicks. Even with 100 purchase orders registered, the actual processing time is just one second. This process is achieved through automated Google Spreadsheets .

Tired of repetitive tasks involving handling countless files and cells? Connect to Google Sheets and experience freedom from the constraints of location, as long as you have an internet connection.

This course covers concepts essential for beginners in programming, including variables, loops, and control statements. It also covers practical examples of inventory management, and even predicting next quarter's sales using AI machine learning. After my class, you'll create your own work, including scraping and copying data from the web, finding and sorting sheets, and even sending them via email. Now, let's build automation through programming to create your own system!

Course Target Audience/Course Purpose 🔑

Available for work
Bringing you inspiration 😎

Programming to manipulate spreadsheets? I was surprised, too. I used to do repetitive work in Excel every day at work, but it became incredibly convenient to use programming to automate office tasks like copying cells and sorting, deleting, and formatting data. The concepts of C and C++ enabled automation, automatically handling tasks that would normally be done by humans.

By applying GAS in practice, we've achieved significant time savings and work efficiency. It's fascinating to see how data is read and entered as programmed, integrity checked, blank spaces removed, columns sorted, and even report mailings completed with a single click.

Introducing the Knowledge Sharer ✒️

Hello, I'm Hanc, and I'm the instructor for this course. I've incorporated the fundamentals of office automation that I've learned from my own work. This course focuses on how to access data, how to handle it, how to program it, and more, focusing on Google Apps Script to complete office automation.

The course is broadly divided into three parts: programming fundamentals, practical examples, and skill enhancement. The basics section can be tedious if you delve into it deeply, so the course progresses to a level where you can apply the material immediately. The practical examples cover sheets and cells in depth, and the skill enhancement section focuses on application and skills. I hope your journey with me will bear fruitful fruit.