Google sheets are by far the most used tool for tracking success metrics and we know how useful it will be for the teams to sync metrics data with the accompanying Key Results.
So, we have built an exclusive add-on for google sheet to give you the functionality of updating your success metrics without having to leave the sheet. You can also automate check-ins for a particular OKR on 10xGoals with a cell in sheets using this add on.
Advantages of 10xGoals add-on:
Easy access to your OKR within the sheet itself - under one roof
Update your metric progress on the sheet and it will automatically update on 10xGoals
No tab switching required from your google sheet reports to 10xGoals for updating your OKRs
Open a sheet on google drive and click on Add-ons >> Get add-ons >> search for 10xGoals and install the add on.
Alternatively, you can go to your Account settings on 10xGoals, click on "Integrations" section and proceed with "Manage Gsheet Add-on"
After allowing, you can reload the sheet and click on Add-ons>> hover on 10xGoals, and click on ‘open’ to get a list of your OKRs to integrate with.
The 10xGoals add-on opens on the right-hand side of your sheet. Click on connect account and sign in using your 10xGoals credentials. This will enable the add on to show you a list of all the eligible OKRs.
Click on the relevant OKR you want to provide a check-in for. Enter the metric value, update the status and provide contextual check-in. Click on "Submit Check-in" button to manually provide the check-in.
Click on the relevant OKRs you want to integrate for auto check in. Click on the cell location that we should pick up the data from, fill in the schedule details and Click on Automate. After this integration, you will start seeing updates on success metrics on your linked OKRs automatically.
You can also set up a weekly/monthly schedule for your OKRs to be auto-updated. Here is how it works:
After you've automated your check-ins by linking a cell, you will be able to see the list of OKRs on 10xGoals that are being checked-in automatically by the sheet.
You can do that in either of these two ways:
Within the add-on, click on an automated objective and find the three-dot menu on the top right hand side. You will see the option to "Remove Automation" and clicking on it should do the job.
2. Within 10xGoals, you can click on the objective that is automated with Google Sheets, find the three dot menu on the top right hand side, and click on "Remove Gsheets Automation".
You can link only one OKR to a cell in a sheet, the same OKR can not be linked with multiple cells.
You can access 10xGoals Add-on from any/multiple Google Sheets.
If a sheet is deleted, the automation will be paused after attempting for a check-in. The detail page of the OKR on 10xGoals will show you an error about the same.
If the due date is passed and the quarter has also ended, then the automation will get automatically removed.
In case you have any queries or facing any issues with your add-on, please feel free to contact us by clicking the three dot menu on the top left hand side.