Skip to main content

Looker integration

Update your goals automatically with data from a Look in Looker.

ℹ️ Available on Supreme.

Connect Looker to Perdoo to update your goals with your business data. Link a KPI, Key Result, or Initiative to a column in a Look, and Perdoo fetches the latest value for you.

Once connected, Perdoo updates the goal for you as often as its sync frequency says. For more about progress drivers, see Progress drivers.


Before you start

Your Looker admin first needs to register an OAuth app in Looker with these settings:

  • redirect_uri: https://nango.perdoo.com/oauth/callback

  • display_name: Perdoo

  • description: OAuth2 client registration allowing Perdoo to securely authenticate and connect with this Looker instance.

  • enabled: true

  • group_id: Leave this empty.


Connect Looker

  1. Find Looker and click Enable (1).

  2. Enter your Looker UI Hostname and Looker API Hostname.

  3. Click Connect and allow access.

  4. Click Finish.

Superadmins can also connect Looker in Configure > Integrations. After you connect it, click Settings to choose whether your connection is private or shared with everyone.


Update a goal with Looker

  1. Open the KPI, Key Result, or Initiative. To set it up while you add a goal, open Advanced options.

  2. In the Details panel, click Progress driver.

  3. Select Integration and choose Looker.

  4. Select your Connection.

  5. Select a Look and a Column.

  6. Check the preview.

  7. 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 Looker 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.


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?