How to Integrate the score From the Google sheet to PMS System in Employee Portal

Steps:

1. Log in as an Employee using valid credentials.

2. Expand the Goal Category and click on More Actions for the respective KRA.

3. Click on Google Sheet.

4. Click on the Authorize button and select your account to integrate the score from the Google Sheet. 

5. Once authorized, you will see a Sign Out option. 

6. After authorization, fill in all required fields with proper data such as Google Sheet URL, Sheet Name, and Range.

7. Once all the data is entered in the specified fields, click on the Verify button to check if the data is present. 

8. If data is present in the specified range, the tool will fetch and display the data in the UI, allowing you to save the changes. 

Note: 

1. If the Google Sheet is restricted, the tool will not fetch any data and no pop-up will be shown.

2. However, if the sheet is accessible but no data is present in the specified range, a pop-up will appear indicating that data is not present in the specified range.

9. Once you save the data, a Manual Sync button will appear for the integrated KRA. Clicking this button will synchronize the score for that particular KRA.

10. After syncing, the logs and updated score will be recorded in the Last Check-in and CFR sections. 

11. If the employee wants to sync all data at once, they can click the Sync All button at the top. This will sync the data for all Integrated KRAs in one go.