강의

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Task Automation

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

(4.9) 29 reviews

184 learners

  • workwithdugi
실습 중심
Google Apps Script
업무자동화
Business Productivity
Google Sheets
spreadsheets
Excel

Reviews from Early Learners

What you will learn!

  • Automation with Google Sheets and Apps Script

  • Automate email delivery of certificates, diplomas, and quotes

  • Google Apps Script Basics

There are many people who repeat the same task over and over again.
Get off work faster with task automation 🔥

Do you want to get off work early?

To: Startup marketers and managers, solopreneurs, small business owners, non-profit managers, and freelancers!

  • Are you responsible for managing multiple tasks, such as membership, financial management, and customer service?
  • Are you staying late at night alone to do your accounting?
  • Are you spending a lot of time sending emails and text messages to each and every customer?

Set up with one click.

💸Without complex development environments or project setup, automate finance, taxation, HR, customer management, and communication with just free tools like Google Sheets and Apps Script ! Learn easily and enjoyably with real-world examples . We'll help you build a solid foundation for automating tasks with Apps Script.


Automations you can create with Google Sheets & Apps Script

You can create this kind of automation with Google Sheets and Apps Script.

Example 1. Sending payslips to all employees in 10 seconds.

Example 2. Complete month-end accounting with a single click.

Example 3. Send text messages directly from Google Sheets without having to visit a cumbersome text messaging site.

Example 4. A Slackbot that automatically monitors exchange rates, stock prices, and financial data.


A 'non-developer' who was directly responsible for various practical tasks
Very easy to learn techniques and 🍯 tips

#1

A practitioner who was tired of multitasking and repetitive tasks in tax, finance, HR, customer management, and customer communication, and created automation himself, will tell you.

#2

We'll share the automation features you've created so your colleagues can use them right away, and we'll also share practical tips to help you use them more conveniently yourself.


What you'll learn 📚

In this class, we will create an example of ' automating customer and employee email communication' .

Part 1. Apps Script Basics
Learn how to integrate AppsScript with Sheets.

Part 2. Sending Bulk Emails
Learn how to send emails with different recipients, subject lines, and content based on data entered in a sheet.

Part 3. Create a personalized PDF and send it via email.
Learn how to create individual PDF files (certificates, completion certificates, and quotations) and send them via email as attachments.


Expected Questions Q&A 💬

Q. When and who would benefit from attending the lecture?

A small business owner who stays alone until late at night every month to close the accounts .
Small startup managers and marketers who have to do all customer management work manually
Non-profit organization operators who must manage members while also performing other tasks.
Freelancers who suffer from the same tax and settlement work every time!

If you feel like you could automate something but can't seem to find a way to get started, I'm confident this course will be helpful. Once you understand a little more about how to do it, you'll discover new ways to do it.

Q. I've never coded before. Will this be okay? What level of instruction will the class be?

Yes, even if you have absolutely no coding experience, it's okay. I'll explain everything step-by-step so even "no coding experience" can take the course. Even though I hadn't studied coding before, I learned only what I needed as I built the automation features I needed.

Q. What can I make by taking the class?

This course is conducted through hands-on exercises. You'll learn how to send personalized emails in bulk and how to send emails with personalized attachments to customers. You can immediately apply these exercises to automate awards, certificates, membership cards, and quotations. Furthermore, you can explore the necessary features yourself and freely develop your own.


Introducing the Knowledge Sharer ✒️

Hello! This is Dougie, the creator of this lecture.
As a non-developer and co-founder, I've handled various tasks (tax, finance, accounting, customer service, customer support, HR, etc.) before I started working on automating my work. I hope this helps more people free themselves from repetitive tasks!

  • More than 5 years of experience in business automation development
  • <Business Automation> lecture in progress
  • Workshop on "Automating Google Sheets with AppScript"

Recommended for
these people

Who is this course right for?

  • Freelancer, small business owner: One person covers a wide range of tasks

  • Startup Manager: Finance, Tax, HR

  • Marketer, Account Manager: Communications, CS

  • Nonprofit Organization Worker: Membership Management, Business Operations

Hello
This is

184

Learners

29

Reviews

2

Answers

4.9

Rating

1

Course

안녕하세요 더기입니다

프리랜서, 1인 대표, 스타트업 매니저, 운영자님들을 위한 업무 자동화 / 구글 시트 / 앱스 스크립트 강의를 진행합니다.
운영,재무,세무,CS 등 멀티 플레이어로 일했던 지난 경험, 노하우를 꼭꼭 담아 쉽고 재미있게 알려드릴게요😇


질문, 강의, 컨설팅 문의 : workwithdugi@gmail.com

Curriculum

All

16 lectures ∙ (1hr 33min)

Published: 
Last updated: 

Reviews

All

29 reviews

4.9

29 reviews

  • triplesala003099님의 프로필 이미지
    triplesala003099

    Reviews 1

    Average Rating 5.0

    5

    75% enrolled

    I really understand each line well. I sincerely recommend it to those who have no knowledge of coding and want to try automating work vaguely. The advantages are 1. It explains things in a way that is easy for beginners to understand. 2. The examples in the class are easy to understand and apply to work. It is easy to apply to work such as e-books, membership emails, and CS emails sent to unspecified numbers of people. 3. There are no unnecessarily difficult expressions or methods. This is the part that I am most satisfied with personally. We are not going to become Super Coding Saiyans, right? We want to quickly complete the work that is difficult through automation, and for this purpose, it explains things in a way that is easy for those who applied. This is the most satisfying of the Inflearn lectures. I hope the next lecture will have these things. 1. Sending emails only to newly registered columns in a specific sheet such as 'Today', and sending only newly entered data instead of past data 2. Sending text messages, as mentioned in the last video

    • amydaeunbin2410님의 프로필 이미지
      amydaeunbin2410

      Reviews 1

      Average Rating 5.0

      5

      31% enrolled

      I'm still taking the class, but the instructor kindly explains it step by step, so I'm getting a lot of help! At first, even though I wasn't familiar with languages like var and function, I started to understand it more intuitively as I kept listening. I want to apply it to my work soon.

      • workwithdugi
        Instructor

        Hello! Warm Sea Elephant:) I tried to explain it as easily as possible so that even those without coding experience can apply it right away. Instead of learning all the theories first, if you learn the necessary coding little by little as you go, you will remember it better and be able to use it usefully later. If you have any questions during the lecture, please leave a question at any time :) Thank you

    • gp0818120134님의 프로필 이미지
      gp0818120134

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      It was great to be able to learn about Google AppScript in a short time. I felt that it was explained really easily so that beginners could understand it (I know how to handle Python, so I felt that it was explained from a beginner's perspective, such as arrays and dictionaries) It's a shame that the lecture is short, but I look forward to the intermediate lecture.

      • corporatelicense0770님의 프로필 이미지
        corporatelicense0770

        Reviews 2

        Average Rating 5.0

        5

        81% enrolled

        The content is really rich and good! I think I can apply it to my work right away. Thank you for the great lecture, and I will definitely take the intermediate lecture!

        • workwithdugi
          Instructor

          I'm glad it was helpful. Please apply it to your actual work and if you have any questions, please feel free to ask :)

      • zpdltis1232562님의 프로필 이미지
        zpdltis1232562

        Reviews 2

        Average Rating 5.0

        5

        100% enrolled

        I really enjoyed it! There are many work automation lectures, but I think this is the most practical and outstanding. I'm surprised that you managed to cover so much content in 90 minutes. Also, for the LMS function you showed at the end, does it use an external API? Even if it's not an LMS, it would be helpful if you could show us the work you do by bringing in an external API. Thank you.

        • workwithdugi
          Instructor

          Functions outside of Google, such as external LMS, require the use of external APIs. In the next lecture, I will prepare to include the use of external APIs :)

      $15.40

      Similar courses

      Explore other courses in the same field!