Introducing a way to automate inquiry response work by using an item that automates the addition of rows to a Google Spreadsheet. After responding to an inquiry, the date of receipt and category of the inquiry will be automatically added to the spreadsheet. Pivot tables can be used in the spreadsheet for real-time aggregation.
By visualising the flow of enquiries across multiple organisations, we were able to improve operational efficiency. In addition, the system enables efficient history management and responses to requests for improvement which were required before the system was put into operation.
The company has digitized the handling of inquiries in the publishing industry. Automation including integration with Google Sheets, significantly helps the company reduce the workload and helps the smooth transition to telecommuting due to the pandemic.
Some of the inquiries contain «unnecessary information». In a workflow diagram, I’ll introduce a way how «unnecessary information» is handled by setting multiple end icons.
Implementación en un periodo corto de tiempo para control interno. Implementación propia de cooperación automática con Chatwork y determinación automática de rutas de aprobación.
Flujo de trabajo en la nube con Questetra y G Suite (antes Google Apps). Y habilitación de la comunicación interdepartamental.
Migración de negocios complejos previamente procesados en Notes a la nube. Aproximadamente 800 empleados utilizan el sistema para sus operaciones diarias.