Free Employee Productivity Tracker
Free Alternative to TimeDoctor & Traqq
Video Explanation: Loom Video
- Go to this Google Sheet and make a copy (Google Apps Script Included)
- In your Google Sheet, fill in the Employees Database with your employees.
- Deploy the Web App via Google Apps Script and copy your web app URL.
- Make a copy of this Looker dashboard and connect your Google Sheet.
- Ask your hires to download the Employee Productivity Tracker
- Send your hires your web app URL to input into the app.
- Ask your hires to click “Start Tracking” and “Stop Tracking” to see if the connection is set up correctly.
What does this app track?
- Number of mouse clicks.
- Number of keystrokes.
- Active window title.
- Active applications in list.
How does it work?
- Once the user clicks the “Start Monitoring” button, the app tracks data.
- Every 10 minutes, it sends that data to a webhook location that can record the data.
- The Google Apps Script reads the data and sends it to the Google Sheet.
- You connect your Google Sheet to a Looker dashboard to visualize the productivity across days and projects.
- Acrobat (Adobe Acrobat)
- Adobe Reader
- Airtable (Spreadsheet-database hybrid)
- Atom (Text editor)
- AutoCAD (CAD software)
- Brave (Web browser)
- Calendar (Google Calendar)
- Canva (Graphics design)
- Confluence (Documentation)
- Docs (Google Docs)
- Emacs (Text editor)
- FileZilla (FTP client)
- Google Drive
- InDesign (Adobe InDesign)
- IntelliJ IDEA (for Java development)
- Jira (Project management)
- Lightroom (Adobe Lightroom)
- Microsoft Edge
- Microsoft Teams
- MySQL Workbench
- Opera (Web browser)
- Postman (API development and testing tool)
- Premiere Pro (Adobe Premiere Pro)
- Safari (Apple’s web browser)
- Sheets (Google Sheets)
- Spotify (Often used for background music)
- SQL Server (Microsoft SQL Server)
- Sublime Text (Text editor)
- Tableau (Data visualization)
- Thunderbird (Mozilla Thunderbird email client)
- Todoist (Task management)
- Vim (Text editor)
- Visual Studio Code
Disclaimer and License Agreement
By using this script and program (“Software”), you agree to the following terms and conditions:
Use at Your Own Risk:
This Software is provided “as is” without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. The entire risk as to the quality and performance of the Software is with you. Should the Software prove defective, you assume the cost of all necessary servicing, repair, or correction.
Limitation of Liability:
In no event unless required by applicable law will the authors, developers, or any other party who modified and/or distributes the Software be liable to you for damages, including any general, special, incidental, or consequential damages arising out of the use or inability to use the Software, even if such holder or other party has been advised of the possibility of such damages.
Creative Commons License:
This Software is provided under the Creative Commons Attribution 4.0 International License. You are free to share (copy and redistribute the material in any medium or format) and adapt (remix, transform, and build upon the material) for any purpose, even commercially. The licensor cannot revoke these freedoms as long as you follow the license terms. You must provide appropriate attribution, provide a link to the license, and indicate if changes were made.
Use of the Software does not constitute endorsement by the authors, developers, or any affiliated organizations or individuals.
You agree to indemnify and hold harmless the authors, developers, and all other parties involved in the creation, production, and delivery of the Software for any and all claims arising from your use of the Software.
By continuing to use this Software, you acknowledge that you have read, understood, and agreed to be bound by the terms and conditions of this Disclaimer and License Agreement.