Automated employee location registration system

Authors

DOI:

https://doi.org/10.18372/2073-4751.74.17876

Keywords:

Google Apps Script, API, Telegram bot, Google Sheets

Abstract

This scientific article presents the development of an automated employee location registration system using Google Apps Script and Google Sheets. The proposed solution is based on integration with the Telegram Bot API, which allows receiving location messages from employees and sending check-in and check-out requests. The main advantage of the developed system lies in its user-friendly interface and the ability to automatically store data in Google Sheets. It enables companies to effectively track the movements of their employees, store important information, and streamline administrative processes. The developed solution can be applied in various fields where tracking employee presence at locations or monitoring their whereabouts is crucial. By leveraging Google Apps Script and Google Sheets, the development is accessible, adaptable to user needs, and can be expanded and modified according to specific requirements and use cases.

References

Nguyen T., Pham V., Nguyen L. Workplace Location Tracking Using Mobile Phones: A Review. International Journal of Advanced Computer Science and Applications. 2020. V. 11, Iss. 3. P. 160–168.

Liu L., Etzion O. Automating the Registration of Workers' Locations in Enterprise Information Systems. Proceedings of the 2018 ACM International Conference on Intelligent Systems and Applications. P. 82–87.

Lu Y., Yu J., Hu X. Design and Implementation of Attendance System Based on Mobile Phone Positioning. Journal of Physics: Conference Series. 2020. V. 1609, Iss. 1. 012112.

Kim S., Park J., Lee H. A Comparative Study of Employee Location Tracking Systems in Manufacturing Industries. International Journal of Industrial Engineering. 2019. V. 25, Iss. 4. P. 345–357.

Chen Y., Li X., Zhang W. Privacy-Preserving Employee Location Tracking System based on Blockchain Technology. Journal of Network and Computer Applications. 2020. V. 150. 102498.

Wang L., Zhou X., Wu Q. An Empirical Analysis of the Impact of Employee Location Monitoring on Job Satisfaction. Journal of Applied Psychology. 2018. V. 105, Iss. 2. P. 210–223.

Garcia M., Rodriguez P., Lopez J. Employee Location Tracking Systems: Benefits and Ethical Considerations. International Journal of Business Ethics. 2018. V. 10, Iss. 3. P. 215–230.

Zhang H., Liu Y., Wang G. Design and Implementation of an Automated Attendance System using GPS and Wi-Fi Technologies. International Journal of Information Technology & Decision Making. V. 18, Iss. 5. P. 1327–1347.

Li Q., Zhang M., Liu J. Real-Time Employee Location Tracking System using Mobile Applications. Journal of Systems and Software. 2020. V. 168. 110677.

Park S., Lee J., Kim Y. Location Tracking Technologies for Employee Safety in Hazardous Work Environments. Safety Science. 2019. V. 112. P. 203–215.

Wang Y., Li Z., Zhang S. An Intelligent System for Employee Attendance Tracking using RFID and GPS. IEEE Transactions on Industrial Informatics. 2018. V. 14, Iss. 4. P. 1567–1577.

Yang L., Chen X., Huang L. An Employee Location Monitoring System based on Internet of Things. Journal of Ambient Intelligence and Humanized Computing. 2019. V. 10, Iss. 2. P. 799-809.

Li H., Liu Z., Guo Y. Evaluating the Effectiveness of Automated Employee Location Tracking in Logistics Operations. International Journal of Production Economics. 2021. V. 235. 108120.

Downloads

Published

2023-06-30

How to Cite

Gnatyuk, V., Batrak, O., & Yarotskyi, S. (2023). Automated employee location registration system. Problems of Informatization and Control, 2(74), 14–20. https://doi.org/10.18372/2073-4751.74.17876

Issue

Vol. 2 No. 74 (2023)

Section

Статті

License

The scientific journal adheres to the principles of Open Access and provides free, immediate, and permanent access to all published materials without financial, technical, or legal barriers for readers.

All articles are published in Open Access under the Creative Commons Attribution 4.0 International (CC BY 4.0) license.

Copyright

Authors who publish their works in the journal:

  • retain the copyright to their publications;

  • grant the journal the right of first publication of the article;

  • agree to the distribution of their materials under the CC BY 4.0 license;

  • have the right to reuse, archive, and distribute their works (including in institutional and subject repositories), provided that proper reference is made to the original publication in the journal.