강의

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Task Automation

Start automating your tasks with Google Apps Script

Learn how to automate repetitive tasks through six examples using Google Workspace (spreadsheets, forms).

(4.6) 5 reviews

133 learners

  • totuworld
실습 중심
업무자동화
Google Apps Script
Google Sheets
Slack

Reviews from Early Learners

What you will learn!

  • You can learn coding with very easy difficulty.

  • Learn the basics of JavaScript, HTTP API, Webhooks, etc.

  • You'll find areas of your work that can be automated to improve your productivity.

  • You will learn smart ways to solve repetitive tasks.

My work, a little easier and faster!
Leave all the tedious work to Google. 🙋‍♂️

With Google Apps Script
Using Google Workspace features

☑️ I want to improve productivity by automating tedious tasks.

☑️ I'm curious about coding and programming, but I'm tired of repetitive tasks.

☑️ When studying, I get confused by terms I don't know, and I end up just using the functions I need.


repetitive tasks,
Zero burden with automation

💡 Wait! This lecture is

  • It contains sufficient explanations as two colleagues, both of whom are true liberal arts students, have provided feedback together for over two months.
  • After writing the code, it also includes a section where you review what the code does.

This lecture begins with a real-life case. Mr. Raccoon (pseudonym), who has to send monthly statement payments to numerous clients, felt it was inefficient to spend so much time sending emails every month, even though it was important. Is there a way to solve this situation?

  • Mr. Raccoon's problem can be easily solved with Google Apps Script.
  • Anyone new to programming will gain the skills to solve problems around them through this course.

Have you struggled with the settings? Anyone can learn this course with just a web browser and a Google account.

Smart repetitive tasks
You will learn how to solve it.

What parts of your work should you automate?
Find and improve productivity.

Basics of JavaScript and HTTP API,
Learn about webhooks and more.

About programming
You can gain confidence.


Learn this 📚

Send bulk emails

Learn how to send slightly different content to multiple people. Learn how to leverage data entered in Google Sheets.

Sending bulk emails with attachments

Based on the code we wrote earlier, we'll learn how to access a file uploaded to Google Drive and attach it to an email.

Sending bulk emails with a decorated body

Well-structured emails are also more convenient for readers. We'll briefly cover HTML and CSS to learn how to style your emails, and we'll also cover how to insert attached images into the body of your emails.

Process data and send it by email

While previously we sent emails by row, this lecture covers how to process data to create the desired format. This course explores how to process arrays.

Receive new survey notifications

This article covers how to receive notifications for new Google Forms notifications sent to a specific Slack channel using Slack webhooks. It also covers how to register a Slack app to receive notifications.

Create a team schedule notification bot

Learn how to send a notification from a Google Calendar shared with your team to a specific Slack channel at a set time each day. Explore triggers and learn how to customize your messages by exploring the Slack Bot Builder.


Expected Questions Q&A 💬

Q. Do I need to know programming?

Yes. It covers fundamental variables and functions, as well as objects, strings, booleans, and more. Best of all, it's easy to understand because you'll learn the explanations while actually creating code.

Q. Is it possible for liberal arts students to apply?

Yes. This lecture was revised over a two-month period, with feedback from two colleagues who are both serious liberal arts students. Necessary explanations for each step are included, so you can follow along without difficulty.

Q. Is there anything I need to prepare before the lecture?

No, all you need is a web browser and a Google account—no special setup required.

✨ Things to note before taking the class

  • Practice environment
    • Web browser and Google account
  • Learning Materials
    • For each lecture, the PT materials used in the lecture are attached in PDF format.
    • The lectures are approximately 25 minutes long, but they are not continuous and are structured as one lecture.
  • Player Knowledge and Precautions
    • It will be helpful if you know JavaScript, but you can start without it.
    • My colleagues also took the course without any programming experience.

Introducing the Knowledge Sharer ✒️

I work as a front-end programmer at Elegant Brothers. I believe that ordinary people can come together to achieve extraordinary things.

  • Current) Woowa Brothers, Front-end Programmer
  • Former Yanolja, backend programmer
  • youtube

Recommended for
these people

Who is this course right for?

  • Anyone who is curious about coding or programming

  • People who are tired of repetitive tasks

  • Those who only use the features used in Google Workspace

Hello
This is

2,332

Learners

36

Reviews

66

Answers

4.7

Rating

3

Courses

우아한형제들에서 프론트엔드 프로그래머로 일하고 있습니다. 평범한 사람들이 모여서 비범한 일을 할 수 있다고 믿습니다.
- 현) 우아한형제들, 프론트엔드 프로그래머
- 전) 야놀자, 백엔드 프로그래머
- 전) ArasoPandan, 백엔드 프로그래머
- 전) MobiDIX, 모바일 게임 클라이언트 프로그래머

Curriculum

All

11 lectures ∙ (2hr 43min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

4.6

5 reviews

  • 이레님의 프로필 이미지
    이레

    Reviews 3

    Average Rating 5.0

    5

    20% enrolled

    우아하게 일하는 법을 알려주는 강의! 일머리가 없어도 이 강의를 보면 자라날 것 같은 일머리 구글에 이런 기능이 있었다니... 단순 업무에 소요되는 시간을 획기적으로 아껴주네요!

    • 이정환 Winterlood님의 프로필 이미지
      이정환 Winterlood

      Reviews 2

      Average Rating 5.0

      5

      90% enrolled

      정말 재밌게 들었습니다 😃 군더더기 없이 깔끔하게 진행하시고 시각 자료도 정말 좋습니다! 특히 그냥 지나칠 수 있는 사소한 개발 용어들도 하나하나 다 짚어서 어떤 뜻을 가지고 있는지 설명해주시는게 참 좋았습니다.

      • 냔냐님의 프로필 이미지
        냔냐

        Reviews 4

        Average Rating 5.0

        5

        10% enrolled

        인프콘 발표도 너무 흥미롭게 잘 들었어요! 히히 유익한 컨텐츠 만들어주셔서 감사합니다

        • homerun0928님의 프로필 이미지
          homerun0928

          Reviews 4

          Average Rating 4.0

          3

          100% enrolled

          • goflash님의 프로필 이미지
            goflash

            Reviews 3

            Average Rating 5.0

            5

            60% enrolled

            Limited time deal ends in 4 days

            $16,500.00

            25%

            $17.60

            totuworld's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!