Automated employee location registration system




Google Apps Script, API, Telegram bot, Google Sheets


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.


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.