Downloads from 20 locations and a heavy Excel workbook, done by morning.
We asked a customer success specialist at a company with locations across Japan to walk us through one Monday.
Misaki Hayashi (29)
Customer Success Department, A facility maintenance company with 20 locations across Japan
*These interviews are dramatizations. People and companies are fictional, and no result is guaranteed.
Customer inquiries come in through LINE, email, and Chatwork. Each location's inquiry records live in the same admin console, but each of the 20 locations has its own account. For the weekly report, she uses a macro-enabled Excel workbook inherited from her predecessor. The download steps have been made into a skill, already set up to run every Monday morning.
Checking inquiries in the unified inbox
QWhat do you start with in the morning?
I open the unified inbox and look at the inquiries that came in over the weekend. LINE, email, and Chatwork are all one list. If I tag rooms with the customer's name, the By customer tab groups the same customer's rooms together across services.
The rooms for common questions are set to Send automatically, and the bot that writes replies checks our help documents before answering. Anything involving complaints or personal information is never sent automatically. It stops as a draft, and I always read those. The line between what I hand off and what I write myself is clear.
QHow do you collect the inquiry data from each location?
Every Monday morning, a scheduled run has AI open a browser in the cloud, sign in to each location's account in turn, and download a week of inquiries as CSV files. I used to sign in and out 20 times, and that was my whole morning. All I did was record myself doing it for one location, turn that into written steps, and make it a skill. The passwords are stored in browser sign-ins, and neither AI nor the chat can see them.
QWhat do you do when the same question keeps coming in?
I turn it into a manual that same day. I have it read the inquiry threads and create a how-to page. I fix where the screenshots go and the wording, then share it with the team.
From this week's inquiries saying "I can't book an inspection from the member site," create a manual page with steps organized by cause.
AII've read this week's inquiries. They fall into three causes. I created a page with the steps to check for each cause.
After sharing it in the team channel, I also add it to the documents our internal help bot reads. From then on, when a new hire asks the bot, it answers using this page as the source.
A regular meeting with a client, and my own review
QWhat about meetings with customers?
Regular meetings with major customers are held in Samurai App Meetings; I just send them a guest link. The minutes are created automatically, so I can focus on listening. The per-participant assessment in the analysis is shown only to me as the organizer, so I quietly check whether I was really listening.
QAre you still using the Excel workbook you inherited?
I am. It's a macro-enabled workbook my predecessor built up over years. When I used to run it on my Windows PC, I couldn't use the PC until it finished. Now I upload the same .xlsm as is and ask in a conversation. AI imports the CSV files from the 20 locations in the cloud, and once I review and approve the code converted from VBA, it runs inside the workbook. The one macro that uses a UserForm can't be converted, so that one still runs in Excel on Windows.
Combine the CSV files from the 20 locations downloaded this morning into the Import sheet of the weekly report workbook, then run the summary macro.
AII combined the CSV files from all 20 locations into the Import sheet. I ran the summary macro (converted from VBA) and updated the summary sheets by location and by category.
I have it read the summary sheet and make the weekly report slides. If I ask for the same structure as last week, only the charts and numbers change to this week's. I add comments on the locations I'm concerned about and use it as is for my report to the department head. If someone wants PowerPoint, I save it as .pptx and the charts stay editable.
Make this week's inquiry report into slides from the summary sheet. Same structure as last week, with charts by location and by category, and the locations where inquiries went up from last week.
AII've read the summary sheet and made 6 slides with the same structure as last week. The locations that went up from last week are Nagoya and Fukuoka, both for inspection bookings.
QHow do you stay in touch with other teams in the company?
I talk with the dev team that builds the member site in an internal channel. Customer rooms and internal channels sit in the same list, so when I get a bug report I can pass it straight to the dev team.
I check that nothing is left in Needs reply, then close it. Even inquiries that come in at night get answered by the next morning if they're common questions.
QLooking back on the day, what has changed the most?
I got my Monday mornings back. Signing in and downloading over and over, and an Excel workbook that freezes my PC, are no longer my job. Questions I've answered become manuals, and the bot answers the next person. I'm back to working on my customers' success.
Run inquiries and the weekly report from one screen