[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.
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
194
Learners
31
Reviews
2
Answers
4.7
Rating
1
Course
안녕하세요 더기입니다
프리랜서, 1인 대표, 스타트업 매니저, 운영자님들을 위한 업무 자동화 / 구글 시트 / 앱스 스크립트 강의를 진행합니다. 운영,재무,세무,CS 등 멀티 플레이어로 일했던 지난 경험, 노하우를 꼭꼭 담아 쉽고 재미있게 알려드릴게요😇
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
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.
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
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.
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!
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.
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 :)