Automation Case Study: Automate Google Forms and Just Check the Results
If your business involves receiving many customer applications, you've probably experienced something like this.
New application forms keep being created, and customer applications come in irregularly.
But the real problem comes after that. You know the drill — opening each application one by one, organizing them, and transferring the data to Google Sheets.
When you repeat this every day, the work you should be focusing on gets pushed aside, and a single mistake can waste hours.
This might be fine for a day or two, but before you know it, you have dozens of application forms, and checking and managing each one becomes overwhelming.
Customer responses get delayed regularly.
Company C came to us with this request.
"New application forms keep getting created, and the number of forms keeps growing along with the existing ones. It's become too difficult to check and manage each one individually."
Company C had a business structure that required creating new application forms regularly.
The various forms created in different formats were management points in themselves, but the real problem came after applications were submitted.
Each application had to be manually checked, and responses had to be handled manually as well.
Late responses sometimes led to customer churn, and since sheet organization was entirely manual, human errors like omissions and incorrect entries occurred frequently.
Many people take this kind of repetitive work for granted, but at IMPAKERS, we think differently.
This is exactly the kind of work that should be the starting point for automation.
How Did We Automate Google Forms?
Company C was managing Google Forms inside folders on Google Drive.
We designed the automation while keeping this environment intact.
Let's look at the specific process through the Make scenario below!
Viewing the Full Process via Make Scenario
1. Automatically check all Google Forms in a specific folder on Google Drive
② Module that fetches response content when an application is submitted via Google Forms
2. When a customer completes an application, an automatic notification is sent via Telegram
3. Save submitted responses to a sheet in real-time & configure automatic sheet creation whenever a new form is created
⑤ Module that creates the corresponding sheet if no insertion target sheet exists
⑥ Module where application data is ultimately inserted
With 6 steps in a single scenario, you can implement Google Forms response notifications and sheet storage.
Pretty Simple, Right?
- Upload the Google Form to receive applications on Google Drive
- When responses come in, notifications are sent automatically and application data is inserted into sheets
- Open the Google Sheet file and check application information by form
Just put the Google Forms in Google Drive and check the results — that's it!
Google Forms Automation: So What's the Benefit?
Now at Company C, no matter how many application forms are created or what format they come in, everything is automatically organized in sheets.
Whether it's the CEO or a staff member, there's no need to open forms or copy-paste anymore.
Just receive a Telegram notification and the application check is done. Subsequent procedures flow naturally through the automated sheet and customer management system.
Let's estimate that checking an application, sending a message, and transferring data to a sheet takes at least 30 minutes per case.
By that calculation, even with just 2-3 cases per day, that's 5 hours per week, 260 hours wasted per year.
Converting this to minimum wage, that's a whopping 2,607,800 KRW.
You could view this as money wasted on busywork.
With this automation, MAKE costs about $108 per year, approximately 153,587 KRW at today's exchange rate.
In other words, busywork costs were reduced by approximately 94%.
What we should really focus our energy on is
deepening relationships with customers
and creating better products and services, isn't it?
IMPAKERS Blog | More document automation cases here! Read more