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.
Implementation in a short period of time aiming at internal control. Ingenuity like automatic cooperation with Chatwork and automatic determination of approval route.
The cloud workflows in Questetra and G Suite. Also communication beyond the boundaries of the section!
Moving Complex Business that had been processed by Notes to the cloud workflow. Approximately 800 employees are utilizing for day-to-day operations.