Automated OKRs and bonus system
Track OKRs (objectives and key results) for all your employees and automate bonus payments based on your team’s performance. Get an overview of all employees’ progress in an automated dashboard.
Get automatic progress updates around the clock. See how your team are performing and if they’re on track to reach their targets.
Each department can record and monitor progress, checking if they’re on track to reach their OKRs.
Employees who reach their OKRs get their bonus automatically, so your accounts team can focus on more important tasks.
How to build this workflow
Create a template spreadsheet that contains the same column structure. For instance, employee name (use a data validation dropdown to guarantee reliability), verification date, the metric that you want to track with one column for the input and another with the goal, % of completion, and additional information you think is needed for your evaluation.
Copy the template spreadsheet, making one copy for each department. Inside each department spreadsheet, change the data validation to display a list of employees in that department.
Store all the department spreadsheets in one single Google Drive folder (but don’t include the blank template spreadsheet that you made in Step 1).
Use Sheetgo to create a consolidate connection. Sheetgo will merge all the data from the different files in that folder into a single master spreadsheet.
As a source you can choose the Google Drive folder you made in the previous step. As your destination choose “+ create spreadsheet”. You can name that new spreadsheet “result sheet” as this is where you will create your dashboard.
Use the master sheet to visualize the results. Create a dashboard using charts to display the key information that you want to see, such as Employee of the month.
Use Sheetgo to create another connection from your master sheet to your finance department’s payments spreadsheet to transfer and filter the data of employees who have reached their goals.
Need guidance? Ask our experts
Need assistance setting up your automated OKR and bonus payment system? No time to build it yourself or looking for a more complex solution?
Talk to our business automation experts about custom project design and implementation.
Connect spreadsheets, automate your work.
Don't hesitate to reach us anytime! [email protected]
© 2016-2020 SHEETGO EUROPE SL