LINE CHATBOT FOR COSMETIC ADVERTISING INFORMATION USING DIALOGFLOW AND GOOGLE SHEETS
DOI:
https://doi.org/10.69598/tbps.20.2.145-159Keywords:
Line Chatbot, Cosmetics Advertisement, DialogflowAbstract
After the COVID-19 outbreak, economic growth, especially in Thailand’s cosmetics and beauty market, has led to rapid market expansion with significant increases in cosmetic registrations and requests for consultation on advertising cosmetic products. Currently, the Cosmetic and Hazardous Substances Advertising Group, Food and Drug Administration services has insufficient staff to provide information and to reply to repetitive inquiries. The objectives of this research are: 1) developing a LINE chatbot to provide information on cosmetic advertising for entrepreneurs; 2) evaluating its accuracy; and 3) assessing LINE chatbot user satisfaction. This study follows a research and development methodology, comprising the process of designing and developing a LINE chatbot using Dialogflow, working with the Line Messaging API and Google sheets. Results showed that the developed LINE chatbot is effective, as assessed by Confusion Matrix, with an accuracy value of 0.820 (82.0%), precision value of 0.8193 (81.93%), recall value of 0.8200 (82.0%), and a balance value (F-Measure) of 0.8155 (81.55%). The satisfaction assessment from 30 users showed an average score in the "good level" (4.20 ± 0.83). The LINE chatbot developed in this research effectively provides cosmetic advertising information with good accuracy and user satisfaction. It can be improved for greater accuracy and used to provide reliable information to entrepreneurs seeking guidance on cosmetic advertising.
References
Thai Cosmetic Manufacturers Association. Megatrends transforming the cosmetics market: Creating opportunities for Thai players to capture a share of the 300 billion market [Internet]. 2023 [cited 2025 Mar 1]. Available from: https://www.thaicosmetic.org/index.php/tcmanews/news-from-media/89-3-32 (in Thai)
Trade Policy and Strategy Office, Ministry of Commerce. Thailand economic figures January 2024 [Internet]. 2024 [cited 2025 Mar 1]. Available from: https://cdn.me-qr.com/pdf/5d2d7ded-a6f1-48ab-af65-9d5059cdd89d.pdf (in Thai)
Food and Drug Administration, Thailand. Roles and responsibilities [internet]. 2020 [cited 2025 Mar 10]. Available from: https://www.fda.moph.go.th/organization/category/mission-and-responsibilities (in Thai)
Suriyaamporn P, Sila-on W, Kansom T, Opanasopit P. The application of artificial intelligence in pharmaceutical technology and advancements in the pharmaceutical industry 4.0. Thai Bull Pharm Sci. 2025;20(1):17-36. (in Thai)
Google Company. Dialogflow ES basics [Internet]. 2018 [cited 2025 March 10]. Available from: https://cloud.google.com/dialogflow/es/docs/basics
LY Corporation. Messaging API reference [Internet]. 2024 [cited 2025 Mar 10]. Available from: https://developers.line.biz/en/docs/messaging-api/overview
Digital Marketing for Asia. LINE in Thailand: A marketer’s paradise [Internet]. 2024 [cited 2025 Mar 10]. Available from: https://www.digitalmarketingforasia.com/line-in-thailand/
Adamopoulou E, Moussiades L. An overview of chatbot technology. In: Maglogiannis I, Iliadis L, Pimenidis E, editors. Artificial intelligence applications and innovations. AIAI 2020; 2020 Jun 5–7; Neos Marmaras, Greece. Cham: Springer; 2020. p. 373–83.
Adamopoulou E, Moussiades L. Chatbots: History, technology, and applications. Mach Learn Appl. 2020; 2:100006.
Jenneboer L, Herrando C, Constantinides E. The impact of chatbots on customer loyalty: A systematic literature review. J Theor Appl Electron Commer Res. 2022;17(1):212-29.
Praracha P, Thavornwattanayong W. New strategy for medication adherence enhancement in tuberculosis patients. Thai Bull Pharm Sci. 2019;14(1):111-25. (in Thai)
Seema S, Kute S, Surabhi D, Thorat A. A review on various software development life cycle (SDLC) models. IJRCCT. 2014;3(7):776–81.
Google Cloud. Testing a Dialogflow agent [Internet]. 2023 [cited 2025 Mar 10]. Available from: https://developers.google.com/assistant/df-asdk/dialogflow/testing-best-practices
Jagadeesan U. Don’t be a confused bot: Understanding the confusion matrix in machine learning [internet]. 2024 [cited 2025 Jan 23]. Available from: https://medium.com/@uva/dont-be-a-confused-bot-understanding-the-confusion-matrix-in-machine-learning-34633cb4e2db
Joshi A, Kale S, Chandel S, Pal DK. Likert scale: Explored and explained. Br J Appl Sci Technol. 2015;7(4):396-403.
Kunlerd A. Developing an innovative health information service system: The potential of chatbot technology. J Suan Sunandha Sci Technol. 2024;11(2):61-9.
Chandel G, Anand K, Goyal K, Choudhary VK, Choudhary M, Saini SK. Healthcare chatbot for personal healthcare assistance. Proceeding of 2024 International Conference on Emerging Innovations and Advanced Computing (INNOCOMP); 2024 May 25–26; Sonipat, India. Institute of Electrical and Electronics Engineers (IEEE); 2024. p.264-69.
Kuljitjuerwong S. LINE - Communicating format on the creativity of smartphone: Benefits and limits of application. J Exec. 2013;33(4):42-54. (in Thai)
Tavichaiyuth N, Rattagan E. Developing chatbots in higher education: A case study of academic program chatbot in Thailand. [Dissertation]. Bangkok: National Institute of Development Administration; 2021. (in Thai)
Singh B, Olds T, Brinsley J, Dumuid D, Virgara R, Matricciani L, et al. Systematic review and meta-analysis of the effectiveness of chatbots on lifestyle behaviours. NPJ Digit. Med. 2023;6(1):118.
Saelim, W. Development of an automated chatbot in LINE application for trouble shooting computer related problems at Faculty of Engineering Prince of Songkla University. J CUAST. 2021;10(2):56–65. (in Thai)
Anantachai J. The development of chatbot “Nong Sabai LINE BOT” for reference service. PULINET J. 2024;11(1):93-108. (in Thai)
Downloads
Published
How to Cite
Issue
Section
License
All articles published and information contained in this journal such as text, graphics, logos and images is copyrighted by and proprietary to the Thai Bulletin of Pharmaceutical Sciences, and may not be reproduced in whole or in part by persons, organizations, or corporations other than the Thai Bulletin of Pharmaceutical Sciences and the authors without prior written permission.