Automatically update progress for your KPIs, Key Results, and Initiatives in Perdoo in 3 simple steps: (1) Install our GSheets Add-on , (2) Connect a GSheet to your Perdoo account, (3) Automatically pull data from any spreadsheet and 200+ apps.
Since this Add-on offers a two-way sync, it can also be used to build internal integrations for your goals in Perdoo. For example, you can use this Add-on to base one KPI’s progress on the sum or average of several other KPIs in your Perdoo account.
ℹ️ This is a Premium feature.
In this article:
How to install our GSheets Add-on
The following steps only have to be done once.
Open our Add-on in Google's Workspace Marketplace and click Install.
If you are a GSuite Administrator, you may see two options: Admin install and Individual install. If you select Individual install, the Add-on will only be available to you. Select Admin install if you want to make the Add-on available to specific groups or your entire organization.
Click Continue and then click Allow to give Perdoo the right permissions.
If the Add-on is installed successfully, you'll see a message that says "Perdoo OKR & KPI Sync has been installed". The Add-on is now available in every Google Sheet.
The GSheets integration is now ready for use!
Only if you performed an Admin install, will the integration now be available for everyone. Otherwise, other users must follow the same steps above to make the integration available for themselves.
Connect any GSheet to your Perdoo account
Open the Google Sheet that you wish to integrate with Perdoo.
You can connect multiple Google Sheets to your Perdoo account.
Select Extensions > Perdoo OKR & KPI Sync > Open.
Click Setup to authorize the Add-on to access your Perdoo data by entering your Perdoo API token.
Use an existing API token or create a new one:
Give your token a name (eg, Google Sheets).
Copy the generated API token into the Add-on and click Save token.
Go back to the main menu and click Import goals.
The Add-on will now load all your Perdoo goals.
For each goal, we display Goal type (KPI, Key Result, or Initiative), Owner, and Lead.
You can search goals by Goal title (eg, Improve ...), Goal type (eg, Key Result), Owner (eg, Marketing), Lead (eg, Nick), and Timeframe (eg, Q2).
Select the goals that you wish to integrate and click Import goals.
If you don't see the Import goals button, you'll need to scroll down in the Add-on (we're working to improve this).
The selected goals will be imported to the Perdoo Goals tab. If this tab didn't exist, a new one will be created.
For each goal, you can choose the Sync direction.
Should the Goal Progress value in your GSheet update (and overwrite) progress for that goal in Perdoo?
Or should Perdoo update the Goal Progress value in your GSheet?
This two-sync option gives you lots of opportunities, such as the ability to build internal integrations!
The Progress update comment is optional. The information that you here will be added to the progress update for context — the same way as if you were adding a comment when updating progress directly in Perdoo. If Auto-sync is enabled, the progress update comment field will automatically be wiped after each successful sync.
That's it! You are now ready to connect other apps and data sources (eg, Hubspot, Salesforce, Zendesk, and many more) to your GSheet to let them automatically update Goal Progress — and you no longer have to update progress manually!
Do not format the value as a percentage in GSheets. For example, if you format '1' as a percentage in GSheets, it changes the value to 0.01 in Perdoo. If you see '1' in GSheets (without the %), it will show as '1%' in Perdoo.
Connecting other apps to auto-update Goal Progress
You can automatically update Goal Progress by connecting other apps and data sources. Your GSheet can connect to hundreds of business apps and you don’t need a technical background to build most of these connections!
NOTE: Formatting your progress value as a % in GSheets may alter the underlying value. Try to avoid this and format the number directly in Perdoo.
Easily pull data from any other spreadsheet using the IMPORTRANGE function.
Most Add-ons are free and easy to use. Check out Google's Marketplace for all available Add-ons: https://workspace.google.com/marketplace/category/works-with-spreadsheet
These Add-ons allow you to easily pull data from these tools into your GSheet — which you can use to update Goal Progress.
Where a native add-on isn't available, middleware Add-ons can be useful. The most well-known are Sheet Director and Supermetrics. They allow you to pull data from hundreds of apps to your Google Sheets — which you can use to update Goal Progress.
These Add-ons usually have a free plan but require a paid subscription for more advanced functions.
Using your tool's API
Most tools have an open API that you can use to pull data to your GSheet. You can let them send data directly to Perdoo's API, or pull data from them using Google's built-in Apps Script using Add-ons like SyncWith.
Each tool should have their own support article explaining how their API works. While API usage is often free of charge, it does require technical knowhow to use them successfully.
Once you have successfully connected other apps so that Goal Progress is automatically updated, it's time to enable Auto-sync.
Go to the main menu and select Auto-sync.
Click Setup Auto-sync.
Choose Frequency and Execution Time and Other Settings.
Click Save settings.
Important: After each successful sync, information in the Progress update comment column (if any) will automatically be wiped.
Are my private OKRs and KPIs accessible via this Add-on?
Note that Private OKRs and KPIs are a Supreme feature.
Can you update the Status for the KR or Initiative via this integration?
Status is not yet included in the Google Sheet integration. Would you like us to add this? Let us know via the live chat bottom-right!
If I close a Key Result will the GSheets integration stop updating it automatically?
No, it will not stop updating automatically. It will keep updating until it's removed from the sheet.
Can I calculate the figure that then goes in the Goal Progress cell elsewhere in the Google Sheet?
As long as the cell from the original worksheet has a value in it, you can do the calculation inside the same doc and just equal the 2 cells across sheets.
What can I do if my Goal Progress values aren't updating automatically?
Make sure you have the hourly recalculation setting (Recalculation on change and every hour) in your GSheet's settings:
Click the File option.
In the drop-down, click on 'Spreadsheet settings'
In the 'Settings for this spreadsheet' box, click on the 'Calculation' tab.
Click on the Recalculation drop-down.
Select On change and every minute.
Click on Save settings.
I have a Result that is automated with the GSheets integration, why is it appearing in the Check-in if it is supposed to be automatically updated?
A goal that is integrated via GSheets will still appear in the lead’s Check-in. While progress is automatically updated, you still want the lead to review progress at regular intervals — and provide context in the form of a comment when necessary. You may want to change the update frequency for that goal (eg, set it quarterly) so that it doesn’t appear in the lead’s Check-in too often.
P.S. We’re working on an update that adds a GSheets icon to goals that are automatically updated via GSheets, like we have for Jira and Asana.
Can I continue to use the existing Google Sheets integration?
If you're already using our existing Google Sheets integration, you can continue to use it alongside this new one until further notice.
I'm using the existing Google Sheets integration. How can I transition to the new one?
We recommend that you just move over one of your goals from the existing integration to the new one, let it run for a day or week to get a feel for how it works and then move everything over when you're ready.
Missing an integration?
Let us know which integration you're missing via the live chat. Click on the chat icon bottom-right!
Contact our friendly Support team via the live chat at the bottom-right of your screen, or email email@example.com.