Skip to main content

Google Sheets Add-on

Update many goals from a spreadsheet, and import users, teams, and progress history.

ℹ️ Available on all plans.

With the Perdoo Google Sheets Add-on, you work with Perdoo from a spreadsheet. You can:

  • Update the progress of many KPIs, Key Results, and Initiatives from one spreadsheet, with data from any spreadsheet or app.

  • Import users and teams.

  • Import the progress history of a goal.

The add-on syncs both ways, so you can also build your own integrations. For example, base one KPI on the sum or average of several others.

ℹ️ Only want to link a goal to a cell? Use the Google Sheets integration instead.


Install the add-on

  1. Open the Perdoo add-on in the Google Workspace Marketplace and click Install.

  2. If you're a Google Workspace admin, choose Admin install to make the add-on available to your teams or company, or Individual install for just yourself.

  3. Click Continue and Allow.

The add-on is now available in all your spreadsheets. Unless you did an Admin install, everyone else needs to install it too.


Connect a spreadsheet to Perdoo

  1. In Perdoo, go to Personal settings > API tokens. Enter a token name, for example Google Sheets, click Generate, and copy the token.

  2. In your spreadsheet, go to Extensions > Perdoo - OKR & Strategy Execution Software > Open.

  3. Click Authorize, paste your API token, and click Save token.

You can connect as many spreadsheets as you like.


Update goals from a spreadsheet

  1. In the add-on, click Import goals from Perdoo.

  2. Search for the goals you want, for example by title, goal type, team, Lead, or timeframe. Select them and click Import goals. You may need to scroll down in the add-on to see the button.

  3. In the Perdoo Goals tab, choose the Sync direction for each goal: Update the goal in Perdoo with the Goal Progress value, or update the Goal Progress value with the progress in Perdoo.

  4. Optionally, add a Date to log the update for a day in the past, and a Comment to add context. Both are cleared after the next sync.

  5. Link the Goal Progress cells to the data you want to use.

Important

  • Don't format the Goal Progress value as a percentage. For example, 1 formatted as 1% becomes 0.01 in Perdoo.


Get data from other apps

To fill your spreadsheet automatically, you can:

  • Pull data from another spreadsheet with IMPORTRANGE.

  • Use an app's own add-on, such as the ones for Salesforce, Zendesk, or Google Analytics. See Integrations.

  • Use an add-on that connects to many apps, such as Supermetrics.

  • Pull data from an app's API, for example with SyncWith or Apps Script.


Sync automatically

  1. In the add-on, select Auto-sync and click Setup Auto-sync.

  2. Choose the Frequency, Execution Time, and other settings.

  3. Click Save settings.


Import users and teams

  1. In the add-on, click Users & Teams under Import data.

  2. Fill in the sheets. The add-on and the notes in the column headers explain what to enter.

  3. Import the data.


Import a goal's progress history

  1. In the add-on, click Progress History under Import data.

  2. Open the goal in Perdoo and copy its ID from your browser's address bar.

  3. Paste the ID in the sheet and choose the Goal type.

  4. Add the progress history for each goal.

  5. Click Import progress history.


Good to know

Why can't I find my goals in the add-on?

The add-on only shows active, public goals. Draft and private goals aren't available.

Can I update a goal's status with the add-on?

No. You can only update progress.

Does the add-on stop updating a goal when I close it?

No. It keeps updating the goal until you remove it from the spreadsheet.

Why isn't my Goal Progress value updating?

Go to File > Settings > Calculation in Google Sheets, and set Recalculation to On change and every minute.

Why does an automated goal show Update due?

Perdoo still asks the Lead to review progress and add context now and then. To see it less often, choose a longer frequency for the goal. See Targets.


Need help?

Start a live chat with our Support team by clicking the question mark at the left or right bottom of your screen.

Did this answer your question?