강의

멘토링

커뮤니티

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

189 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

189

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

  • koo님의 프로필 이미지
    koo

    Reviews 1

    Average Rating 5.0

    5

    75% enrolled

    한줄 한줄 이해가 정말 잘 됩니다. 코딩에 대한 지식 없고, 막연히 업무 자동화에 도전해보고 싶다는 분들에게 진심으로 추천드립니다. 장점은 1. 초심자의 눈높이에 맞춰서 쉽게 설명해주십니다 2. 수업에 나오는 예제가 이해하기 쉽고, 업무에 적용하기도 쉽습니다. 전자책, 회원가입 이메일, cs 이메일 등 불특정 다수에게 보내는 업무 등에 적용하기 쉽습니다. 3. 불필요하게 어려운 표현이나 방법이 없습니다. 개인적으로 가장 만족한 부분입니다. 저희가 슈퍼코딩사이어인이 될 게 아니겠죠? 자동화를 통해 짜치는 업무를 빠르게 해내고자 하는데, 이를 위해 신청한 사람들의 눈높이에 맞게 편하게 설명해주십니다. 인프런 강의 중에 가장 만족합니다. 다음 강의에는 이런 게 있으면 좋겠습니다. 1. 특정 시트에서 '오늘' 새롭게 등록된 열에게만 메일 보내기 등 과거 데이터 말고 새로 입력된 데이터만 보내기 2. 마지막 영상에서 말씀주신 문자보내기 등도요.

    • 따뜻한 바다코끼리님의 프로필 이미지
      따뜻한 바다코끼리

      Reviews 1

      Average Rating 5.0

      5

      31% enrolled

      아직 수강 중이지만, 강사님이 친절하게 하나씩 설명해주셔서 도움 많이 받고 있습니다! 처음에 var, function 같은 언어가 익숙하지 않더라도, 계속 듣다보니 좀 더 직관적으로 이해가 되더라고요 ㅎㅎ 얼른 실무에 적용해보고 싶습니다

      • 더기
        Instructor

        안녕하세요! 따뜻한 바다코끼리님:) 코딩 경험이 없더라도 바로 적용해보실 수 있게 최대한 쉽게 설명하려 노력했습니다. 먼저 이론을 다 배우는 것이 아닌 필요한 코딩을 그때그때 조금씩 습득하면서 만들면 좀 더 기억에 잘남고 이후에도 유용하게 사용할 수 있더라구요. 강의 진행하다가 궁금한 점이 생기시면 언제든 질문을 남겨주세요 :) 감사합니다

    • Maitri_7님의 프로필 이미지
      Maitri_7

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      빠른 시간에 구글 앱스크립트에 대해 알 수 있어서 좋았습니다. 초심자가 이해할 수 있게 정말 쉽게 설명해주시는 게 느껴졌습니다(저는 파이썬을 다룰 줄 알다보니 배열 및 딕셔너리 등을 가능한 초심자 입장에서 설명해주는 게 느껴졌습니다) 강의가 짧아 아쉽지만 중급강의 기대하겠습니다.

      • ab180님의 프로필 이미지
        ab180

        Reviews 2

        Average Rating 5.0

        5

        81% enrolled

        내용이 정말 알차고 좋습니다! 바로 실무에 활용할 수 있을것 같아요. 좋은 강의 감사드리고, 중급 강의도 꼭 수강하겠습니다!

        • 더기
          Instructor

          도움이 되었다니 기쁩니다. 실제 업무에 적용하시고 궁금하신 점이 생기시면 언제든 질문 남겨주세요 :)

      • ben y님의 프로필 이미지
        ben y

        Reviews 2

        Average Rating 5.0

        5

        100% enrolled

        정말 재미있게 잘 봤습니다! 많은 업무 자동화 강의들 있지만 그 중에서도 가장 실용적이고 발군이라고 생각합니다. 90분 안에 이렇게 많은 내용을 담아내시다니 놀랍네요. 아울러 끝에서 보여주신 LMS 기능의 경우 외부 API를 사용하는 것일까요? 꼭 LMS가 아니더라도, 외부 API를 끌고 와서 하는 작업들을 보여주시면 큰 도움이 될 것 같습니다. 감사합니다.

        • 더기
          Instructor

          외부 LMS 처럼 구글 외부에 있는 기능들은 외부 API를 사용해야합니다. 다음 강의에서는 외부 API를 활용하는 내용도 포함하도록 준비해볼게요 :)

      $15.40

      Similar courses

      Explore other courses in the same field!