LINE CHATBOT FOR COSMETIC ADVERTISING INFORMATION USING DIALOGFLOW AND GOOGLE SHEETS

Authors

  • Wanwisa Hadsoong Cosmetics and Hazardous Substances Advertising Group, Cosmetics and Hazardous Substances Control Division, Food and Drug Administration, Nonthaburi
  • Perayot Pamonsinlapatham Department of Biomedical and Health Informatics, Faculty of Pharmacy, Silpakorn University, Sanam Chandra Palace Campus, Nakhon Pathom

DOI:

https://doi.org/10.69598/tbps.20.2.145-159

Keywords:

Line Chatbot, Cosmetics Advertisement, Dialogflow

Abstract

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

29-07-2025

How to Cite

Hadsoong, W. ., & Pamonsinlapatham, P. (2025). LINE CHATBOT FOR COSMETIC ADVERTISING INFORMATION USING DIALOGFLOW AND GOOGLE SHEETS. Thai Bulletin of Pharmaceutical Sciences, 20(2), 145–159. https://doi.org/10.69598/tbps.20.2.145-159

Issue

Section

Original Research Articles