1. Zapier
  2. Apps
  3. Business intelligence
  4. Looker

How to get started with Looker on Zapier

Updated

Looker and Zapier connect to automate your business intelligence workflows. You can run Looks, execute SQL queries, manage users, and create render tasks.

Prerequisites

To use the Looker app on Zapier, you must have:

  • A paid Looker plan.
  • Admin access to generate API credentials (or request credentials from your admin).

For Zapier Team or Enterprise users, you can use a static IP address to connect to Zapier. This is useful if your Looker instance requires IP allowlisting.

Find your Looker credentials

You'll need to create an API Key in your Looker account:

  1. Go to the Admin section in Looker.
  2. Navigate to Users.
  3. Select your user or create API credentials for the user who will connect to Zapier.
  4. Copy the Client ID and Client Secret.

If you're not a Looker admin, contact your admin to create API credentials for you. The API credentials will have the same permissions as the user they are created for.

Connect Looker to Zapier

To create an app connection to Looker on Zapier:

  1. Go to the Apps page.
  2. Click + Add connection.
  3. A new dialog box will appear. Search for and select Looker.
  4. Click Add connection.
  5. A Connect an Account page will open in a browser tab or window.
  6. Complete the following fields: - Looker URL: Enter your Looker instance URL (for example, https://company.looker.com). Include any port numbers if necessary (for example, https://company.looker.com:19999). - Client ID: Enter your Client ID. - Client Secret: Enter your Client Secret.
  7. Click Yes, Continue to Looker.

Your Looker account is now successfully connected to Zapier.

About Looker's app

Triggers, searches, and actions

Triggers
  • New Record Created in Look (Polling) - Triggers when a new record is created in a Look.
  • New User (Polling) - Triggers when a new user is created in Looker.
  • New Record Created in SQL Query (Polling) - Triggers when a new record is created in a Looker SQL Query.
Searches
  • Find User - Finds a user in Looker based on search criteria.
  • Get Render Task Results - Gets the document, image, or PDF produced by a completed render task.
Actions
  • Add User to Group - Adds a user to a group in Looker.
  • Add Role(s) to User - Sets one or more roles for a user in Looker.
  • Create User - Creates a new user in Looker.
  • Create Credentials - Email - Creates email credentials for a user in Looker.
  • Create Render Task - Creates a new task to render a Dashboard, Look, or Query to an image or PDF.
  • Delete User - Deletes a user in Looker.
  • Execute SQL Query - Executes a SQL query in Looker.
  • Run Look - Runs a selected Look.
  • Send Password Reset or Account Setup Email - Sends a password reset email to the user.

Limitations

  • Standard plan: Up to 1,000 query-based API calls per month and up to 1,000 administrative API calls per month.
  • Enterprise plan: Up to 100,000 query-based API calls per month and up to 10,000 administrative API calls per month.
  • Embed plan: Up to 500,000 query-based API calls per month and up to 100,000 administrative API calls per month.

Learn more about Looker's usage limits.

Templates

View all of Looker's templates

Additional Looker resources

Was this article helpful?
0 out of 0 found this helpful

Zapier Early Access

Get access to tomorrow’s no-code automation products and features today. By opting-in to our current and future pre-release products, you’ll work directly with the Zapier product team and join a dedicated community of automation enthusiasts. Learn more about Zapier Early Access