Providing assistance in the digital transformation (DX) of business enterprises and the nurturing of the employees’ coding skills

Castalia has launched the distribution of “CODEPOWER RPA”, a service to promote the DX of business enterprises that used to be offered to a limited extent.  The service is made for business enterprises; by utilizing Google Apps Script, it makes use of the RPA (robotic process automation) for the improvement of internal operations.  At the same time, the service allows the employees to understand JavaScript notations, cultivate coding skills, as well as the skill to construct workflows through finding solutions to agendas.

CODEPOWER RPA was developed in June 2019.  Since then, it has been offered to a limited extent such as for the training of freshmen at a major accounting firm, the training of female workers in rural areas, the feasibility study targeting students at a university, and the training at a major manufacturing firm.  The service is now available to the public.

On CODEPOWER RPA, various Google services are linked together and automated by way of Google Apps Script for the users to learn coding and RPA.  There is a total of 10 stages, at each of which the users create one project. One stage consists of a five-section learning steps; through the small-step style of project creation, they learn the basics of Google Apps Script and coding.

Users will:

  • Learn the basics of Google Apps Script, implement RPA by themselves, and drastically shorten the hours of operation.
  • Understand the notations of JavaScripts and nurture coding skills.
  • By linking to the external APIs, gather information through a crawler and nurture the skills to utilize the collected data.
  • By finding solutions to agendas, nurture skills to construct workflows.

 Note: Each blue oval represents a “project”.

CODEPOWER RPA simulates a total of 50-60 learning hours, which accounts for 10 stages, each of which takes about 5-6 hours.  The end of Stage 5 comes with a mid-term test and the end of Stage 10 a final test, each simulated to take an hour.

Stages 1 thru 5 make full use of Google App functions.  Users will learn about automation by a relatively easy coding:

[Stage 1] Understanding the concept of automated process function that leads to work reduction (Creating a Bot)

[Stage 2] Customizing the automated process function that leads to work reduction (Add functions to the Bot and change the output)

  • Making quotable quotes to be entered in a form and added to a spreadsheet, which registers the quotes to the Bot and send notifications.

[Stage 3] Reducing working time in communication (automatic distribution of e-mail newsletters)

  • Automatically sending an e-mail newsletter by time trigger, using the e-mail content and addresses saved on a spreadsheet

[Stage 4] Reducing working hours in business operation (meeting room reservation)

  • Automatically entering the meeting room reservation details inputted in a form by the meeting host, and automatically sending the e-mail to the attendees.

[Stage 5] Automation of complicated work in business operation

  • Automatically entering the meeting room reservation details inputted in a form by the meeting host, using the information such as the vacancy of meeting rooms and open schedules of the meeting attendees, and automatically sending the e-mail to the attendees.

[Mid-term test] Before heading to the “application” segments, i.e., Stages 6 thru 10, the test confirms the users’ level of understanding of the “basic” segments, i.e., Stages 1 thru 5.  The test consists of 20 questions to be answered in one hour.

Stages 6 thru 9 allow the user to learn coding that enables automated process.  In Stage 10, they will construct a comprehensive web app by making use of every acquired skill.  

[Stage 6] Automated processing by linking to an external API (the use of API that searches for the optimal route)

  • Solving the “traveling salesman problem” with GAS.
  • Making Google Map show the shortest traveling route generated from the addresses written on the spreadsheet.

[Stage 7] Automated processing of information gathering (Creating a Bot that delivers scraped information)

  • Sending notices on commuter train service information every morning and evening, using HangoutChat (e-mail). 

[Stage 8] Automated processing of information gathering and multi-functionalization (linking of scraping and services)

  • Gathering product information from shopping websites and save them on a spreadsheet.
  • Adding a function to translate the collected information to multiple languages.

[Stage 9] Turning of automated processing into a Web app (Web app)

  • Creating a system where the information saved on a spreadsheet will be shown with the activation of the script when accessing the URL.
  • Creating an e-mail newsletter distribution system with a registration function.

[Stage 10] Construction of a Web app of automated processing (a Web app that handles background processing)

  • Creating a service that sends an email of gourmet information at a set time of the day.
  • Creating a system to vote to the registered quotable quotes by selecting the URLs shown on the Web browser.

[Final test] Confirms the users’ level of understanding of Stages 6 thru 10.  The test consists of 20 questions to be answered in one hour.

Product name: CODEPOWER RPA
Price: Online course – JPY 50,000 (+ tax) per person / Options of real-time training etc. available
Requirement: Minimum of 10 users if using the real-time training option
Estimated duration of course: 10 days – 10 weeks (depending on condition)
Language: Japanese
For more information, please refer to:

CODEPOWER is a series of online code education service provided by Castalia Co., Ltd.  The series consists of CODEPOWER KIDS for code education through the use of robots, CODEPOWER RPA for practical coding education with Google Apps Script, and CODEPOWER PYTHON (working name) to learn how to code with Python coding language.