ℹ️ Available on all plans.
Connect Google Sheets to Perdoo to update your goals from your spreadsheets. Link a KPI, Key Result, or Initiative to a cell, and Perdoo uses its value to update the goal. Because you can pull data from many apps into Google Sheets, this also works for tools without their own Perdoo integration.
Once connected, Perdoo updates the goal for you as often as its sync frequency says. For more about progress drivers, see Progress drivers.
Connect Google Sheets
Find Google Sheets and click Enable (1).
Click Connect and allow access.
Click Finish.
Superadmins can also connect Google Sheets in Configure > Integrations. After you connect it, click Settings to choose whether your connection is private or shared with everyone.
Update a goal with Google Sheets
Open the KPI, Key Result, or Initiative. To set it up while you add a goal, open Advanced options.
In the Details panel, click Progress driver.
Select Integration and choose Google Sheets.
Select a Spreadsheet, a Sheet, and a Cell.
Check the preview.
Click Save & Sync now.
Good to know
How often does Perdoo fetch the latest value?
As often as the goal's sync frequency says, for example daily or weekly. Every sync adds a progress update, even if the value hasn't changed. To update sooner, click Update on the goal.
What happens if the connection stops working?
You get an email, and the goal shows a red connection error. Reconnect Google Sheets in Personal settings > Integrations.
Can others update a goal that uses my private connection?
Yes. Anyone who can update the goal can fetch the latest value, but only you can change the connection's settings.
Who can use my Google Sheets connection?
Only you. Your files stay private to your connection.
What's the difference with the Google Sheets Add-on?
With the integration, you link a goal to a cell from within Perdoo. With the Google Sheets Add-on, you work from a spreadsheet, for example to update many goals or import users at once.
Need help?
Start a live chat with our Support team by clicking the question mark at the left or right bottom of your screen.


