Just like our Open API, our Google Sheets integration enables you to automatically update progress on your KPIs, Key Results, and Initiatives. Please note that this integration does not require you to have your own Google account.
The Google Sheets integration can connect to 65+ business apps and you don’t need a technical background to build most of these connections.
Get started in two steps.
- Send our Support team a quick message so that we can activate the integration for you. Contact us at firstname.lastname@example.org or via the in-app chat at the bottom-right of your screen.
- Once, activated, follow these steps to update any KPI, Key Result, or Initiative automatically:
- In Perdoo, click on the goal (KPI, Key result or Initiative) you wish to integrate.
- From the URL, copy the ID located after /kpi/, /kr/ (see images below).
- Open your Google Sheet.
- Copy the ID to the ID column.
- In the Type column, add which type of goal it is ('kpi', 'keyresult', or 'initiative')
Key Result or Initiative
Once a day (between 2-3 am CET), Perdoo will check these sheets and automatically update progress on the corresponding goals in Perdoo, based on the value that Perdoo finds in the Value column.
You can automatically update the value (i.e. progress) for your goals by connecting other apps. Here's how:
Connecting other apps
A lot of tools—like Salesforce, Chartmogul, and Quickbooks—enable you to send your data directly from their apps to a Google Sheet. Most Google products, like Google Forms and Google Analytics, also allow you to send data directly to a GSheet. These add-ons are free and very easy to use. They enable you to automatically update the value (i.e. progress) for a goal.
Where a native add-on isn't available, Middleware add-ons can be very useful. The most well-known add-ons is Supermetrics. It allows you to integrate 40+ apps to your Google Sheets, so you can automatically update progress in Perdoo with data from apps like Hubspot, Shopify, Facebook Ads, Semrush, Stripe, and more.
Want to know all the apps we can integrate with?
Here's a full list of apps that Perdoo integrates with. Contact our Support team (email@example.com, or via the in-app chat) to see how we can help you automate updates to KPIs, Key Results, and Initiatives.