Implementasi RPA Berbasis Unattended Bot dan ETL untuk Otomatisasi Report Tracking Truck Industri Logistik
DOI:
https://doi.org/10.47065/bulletincsr.v6i6.1410Keywords:
Robotic Process Automation; Unattended Bot; ETL; UiPath; Tracking Truck; Power BI; LogisticsAbstract
The Truck Tracking Report process at PT Linfox Logistics Indonesia combines vehicle, departure-time, route, task-status, and distance-related data from a third-party tracking platform. Automating extraction alone does not resolve data-quality problems because retrieved records may still contain duplicates, empty cells, and inconsistent formats. This study implements an unattended Robotic Process Automation (RPA) workflow integrated with Extract, Transform, Load (ETL): UiPath orchestrates extraction, Python transforms the data, Google Spreadsheets serves as an intermediary store, and Power BI provides visualization. The system is evaluated through functional tests, a preparation-time comparison, and a PIECES questionnaire completed by 20 respondents. The results show that the workflow handles duplicate and empty data, reduces report-preparation time from approximately 60 to 20 minutes, passes ten designed test scenarios, and receives high user ratings. These findings apply to the dataset, test scenarios, and respondents in the organization studied; dashboard updates are scheduled and are not claimed to be real-time.
Downloads
References
J. Ribeiro, R. Lima, T. Eckhardt, and S. Paiva, “Robotic process automation and artificial intelligence in Industry 4.0—A literature review,” Procedia Comput. Sci., vol. 181, pp. 51–58, 2021, doi: 10.1016/j.procs.2021.01.104.
J. Wewerka and M. Reichert, “Robotic process automation—A systematic mapping study and classification framework,” Enterp. Inf. Syst., vol. 17, no. 2, pp. 1–38, 2023, doi: 10.1080/17517575.2021.1986862.
N. N. Widodo, S. Rizal, and I. Mariam, “Penerapan RPA menggunakan UiPath pada pembuatan Delivery Schedule PT Suryaraya Rubberindo Industries,” in Prosiding Seminar Nasional Riset Terapan Administrasi Bisnis & MICE XII, 2023, pp. 120–133. [Online]. Available: https://prosiding.pnj.ac.id/index.php/snrtb/article/download/2031/911
M. A. Farhan, R. S. Sianturi, and N. Santoso, “Implementasi robotic process automation pada proses kompilasi dokumen Nota Pemberitahuan Barang Larangan/Pembatasan (NPBL) di PT Merck Chemicals and Life Sciences,” Jurnal Teknologi Informasi dan Ilmu Komputer, vol. 12, no. 4, pp. 951–964, 2025, [Online]. Available: https://jtiik.ub.ac.id/index.php/jtiik/article/download/9542/1480
D. Susandi, H. Sujadi, and K. Martin, “Pemanfaatan robotic process automation dalam pembuatan laporan penindakan kejadian bencana secara otomatis,” Jurnal Teknik Elektro dan Komputer TRIAC, vol. 11, no. 1, pp. 6–10, 2024, doi: 10.21107/triac.v11i1.24330.
H. Y. Lam, V. Tang, and L. Wong, “Raising logistics performance to new levels through digital transformation,” International Journal of Engineering Business Management, vol. 16, pp. 1–20, 2024, doi: 10.1177/18479790241231730.
S. B. Utomo, A. N. Gusma, and M. T. Radiputro, “Efisiensi pengambilan data penjualan produk pada SAP Hybris melalui implementasi robotic process automation (RPA) di PT PQRS,” Technologic, vol. 15, no. 2, pp. 46–54, 2024, doi: 10.52453/t.v15i2.446.
F. Turrahmi and R. Firdaus, “Penggunaan RPA (Robotic Process Automation) dalam sistem informasi akuntansi: Mempercepat proses dan mengurangi kesalahan,” Jurnal Intelek dan Cendikiawan Nusantara, vol. 1, no. 5, pp. 9030–9037, 2024, [Online]. Available: https://jicnusantara.com/index.php/jicn/article/view/1639
D. Vernanda, S. Apriyani, Haryati, A. Yanuar, and I. Purwa, “The integration of robotic process automation (RPA) in the asset management information system of a defense holding company,” Subang International Journal of Governance and Accountability (SINGA), vol. 2, no. 2, pp. 15–20, 2024, [Online]. Available: https://singa.subang.go.id/singa/issue/view/3
N. M. El-Gharib and D. Amyot, “Robotic process automation using process mining—A systematic literature review,” Data Knowl. Eng., vol. 148, 2023, doi: 10.1016/j.datak.2023.102229.
W. Aulia, R. Gunawan, S. M. Hafiza, and N. B. Tarigan, “Analisis kemungkinan terjadinya risiko pada implementasi robotic process automation (RPA) (studi pada pengiriman dokumen PT Kamadjaja Logistics),” IdeaLogist Journal, vol. 1, no. 1, pp. 286–293, 2024, [Online]. Available: https://idealogist.ulbi.ac.id/index.php/IdeaLogist_Journal/article/view/51
R. S. Hadikusuma, R. S. Bijokangko, and M. D. Ananda, “Analisis perbandingan software UiPath dan OpenRPA pada robotic process automation,” in Prosiding Seminar Nasional Sains dan Teknologi, 2023, pp. 320–325. doi: 10.36499/psnst.v13i1.9531.
M. A. Wijaya, D. Purnomo, and Meinawati, “User satisfaction analysis of website-based graduation information system using the PIECES framework method,” Jurnal Teknologika, vol. 13, no. 2, pp. 273–283, 2023, doi: 10.51132/teknologika.v13i2.309.
M. De Luca, A. R. Fasolino, and P. Tramontana, “Investigating the robustness of locators in template-based Web application testing using a GUI change classification model,” Journal of Systems and Software, vol. 210, 2024, doi: 10.1016/j.jss.2023.111932.
A. Salim, G. I. Sutedjo, and C. N. Siallagan, “Menuju audit ESG berkualitas dan transparan: Optimalisasi implementasi audit ESG dengan robotic process automatization,” Indonesian Journal of Auditing and Accounting, vol. 2, no. 1, pp. 138–153, 2025, doi: 10.71188/ijaa.v2i1.104.
H. Prabowo, M. Hendayun, and A. Zulianto, “Peran penggunaan robotic process automation sebagai solusi mitigasi risiko klaim negatif program BPJS Kesehatan,” Infosecure, vol. 5, no. 2, pp. 24–28, 2024, [Online]. Available: https://jurnal-pasca.unla.ac.id/infosecure/article/view/v5n2_04
D. I. Syahfitri, “Analisis peran RPA (Robotic Process Automation) dalam transformasi proses akuntansi di Indonesia: Meningkatkan efisiensi, mengintegrasikan teknologi, dan mendorong keunggulan kompetitif,” Benefit: Journal of Business, Economics, and Finance, vol. 3, no. 2, pp. 368–382, 2025, doi: 10.70437/benefit.v3i2.1191.
L. Yasmi, G. Firmansyah, B. Tjahjono, and N. S. Fatonah, “Penerapan robotic process automation (RPA) untuk otomasi proses pengunggahan planogram: Studi kasus FamilyMart,” Scientica: Jurnal Ilmiah Sains dan Teknologi, vol. 3, no. 7, pp. 55–61, 2025, [Online]. Available: https://jurnal.kolibi.id/index.php/scientica/issue/view/1
F. N. Sabila and M. Fathurahman, “Penerapan robotic process automation (RPA) untuk otomatisasi reporting traffic,” in Prosiding Seminar Nasional Inovasi Vokasi, 2025, pp. 686–695. [Online]. Available: https://prosiding.pnj.ac.id/index.php/sniv/article/view/3953
K. Safrina and F. Sofiani, “Pemanfaatan aplikasi Google Spreadsheet dalam pengelolaan surat masuk di Kementerian ATR/BPN,” Jurnal Serasi, vol. 22, no. 2, pp. 148–156, 2024, doi: 10.36080/js.v22i2.3593.
S. P. M. Hasibuan, N. A. P. Hadi, and K. E. L. B. Karo, “Perubahan peran akuntan di era artificial intelligence dan robotic process automation: Kajian literatur,” Jurnal Ilmiah Nusantara, vol. 2, no. 6, pp. 1268–1280, 2025, doi: 10.61722/jinu.v2i6.6625.
R. Darmawan and G. Swalaganata, “Analisa komparatif Power BI dan Tableau dalam implementasi business intelligence pada Brazilian e-commerce public dataset by Olist,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 9, no. 5, pp. 8936–8944, 2025, doi: 10.36040/jati.v9i5.15178.
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Implementasi RPA Berbasis Unattended Bot dan ETL untuk Otomatisasi Report Tracking Truck Industri Logistik
ARTICLE HISTORY
How to Cite
Issue
Section
Copyright (c) 2026 Muhamad Ali Mubarok, Wiyanto Wiyanto, Abdillah AG
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).
