Inflearn brand logo image
Inflearn brand logo image
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

  • jirehmuze님의 프로필 이미지
    jirehmuze

    Reviews 3

    Average Rating 5.0

    5

    20% enrolled

    A lecture that teaches you how to work elegantly! Even if you don't have a job, if you watch this lecture, your job will grow I didn't know Google had this feature... It drastically saves time spent on simple tasks!

    • winterlood님의 프로필 이미지
      winterlood

      Reviews 2

      Average Rating 5.0

      5

      90% enrolled

      It was really fun to listen to 😃 You proceeded neatly without any unnecessary details, and the visual aids were really good! I especially liked how you explained each and every minor development term that could have been overlooked, and what they meant.

      • jessicahan96님의 프로필 이미지
        jessicahan96

        Reviews 4

        Average Rating 5.0

        5

        10% enrolled

        I really enjoyed listening to the Infcon presentation! Hehe, thank you for creating useful content.

        • homerun0928님의 프로필 이미지
          homerun0928

          Reviews 4

          Average Rating 4.0

          3

          100% enrolled

          • goflash1394님의 프로필 이미지
            goflash1394

            Reviews 3

            Average Rating 5.0

            5

            60% enrolled

            $17.60

            totuworld's other courses

            Check out other courses by the instructor!