Looker API Integrations

Build and run workflows using the Looker API. Use 1000s of source-available triggers and actions across 2,400+ apps. Or write custom code to integrate any app or API in seconds.

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Overview#

The Looker API provides programmatic access to Looker's data exploration functionalities, allowing you to tap into your data analytics and share insights across your organization dynamically. With the Looker API on Pipedream, you can automate reporting, synchronize analytics data with other apps, and trigger data-driven workflows. Whether it's scheduling reports, updating dashboards, or integrating data insights into other systems, the Looker API empowers you to make data-informed decisions efficiently.

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    looker: {
      type: "app",
      app: "looker",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `${this.looker.$auth.looker_base_url}/api/4.0/user`,
      headers: {
        "Authorization": `token ${this.looker.$auth.oauth_access_token}`,
      },
    })
  },
})

Example Use Cases#

Scheduled Report Dispatch: Configure a Pipedream workflow that triggers at regular intervals, fetches the latest reports from Looker, and sends them via email or Slack. This automation ensures stakeholders receive timely analytics updates without manual intervention.
Dashboard Activity Monitoring: Set up a Pipedream workflow that uses the Looker API to monitor changes or views on specific dashboards. Whenever there's a significant change, the workflow could trigger notifications or log the event in a tool like Google Sheets or a project management app like Trello, helping teams stay aligned with the latest data insights.
Data Sync Between Looker and CRM: Create a Pipedream workflow that regularly pulls data from Looker and updates the records in a Customer Relationship Management (CRM) system like Salesforce. This ensures that sales and marketing teams have access to the latest data analytics for better customer engagement and personalized experiences.

Authentication#

Name Slug: looker

Looker uses OAuth authentication. When you connect your Looker account, Pipedream will open a popup window where you can sign into Looker and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Looker API.

Pipedream requests the following authorization scopes when you connect your account:

OAuth Request Configurations:

accessToken
POST{{custom_fields.looker_base_url}}/api/4.0/logincontent-type: application/x-www-form-urlencodedaccept: application/json
client_id={{custom_fields.client_id}}&client_secret={{custom_fields.client_secret}}
refreshToken
POST{{custom_fields.looker_base_url}}/api/4.0/logincontent-type: application/x-www-form-urlencodedaccept: application/json
client_id={{custom_fields.client_id}}&client_secret={{custom_fields.client_secret}}

Start for free — no credit card required

Watch a demo

Looker

Looker API Integrations

Build and run workflows using the Looker API. Use 1000s of source-available triggers and actions across 2,400+ apps. Or write custom code to integrate any app or API in seconds.