Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Create a Live Dashboard from a Zapier Table using Google Looker

  • April 11, 2026
  • 3 replies
  • 35 views
S

I am wanting to create a live customised dashboard for my customer as follows:

1. The source is a Zapier table that will have various fields updated throughout the day.

2. I need to create a live dashboard that shows a list of critical changes to be actioned.

3. Specific fields need to be colour coded based on their text value

4. I need to be able to launch the dashboard via a desktop shortcut or browser

5. The dashboard must be refreshed regularly..ie every 10 mins during business hours excluding weekends and Public Holidays

6. I cannot identify a native way within Zapier for such a dashboard,  so I am investigating Looker.

7. Questions;

   A) is there integration with Google Looker available now or Planned?

   B) if not, do I have to create a dedicated zap to sync the table with a Google sheet

   C) has anyone successfully created a dashboard as per the above and are there any lessons learnt or tips or examples 

 

Look forward to any reply..   Steve

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • April 11, 2026

Hi ​@SJH747 

Available app integrations can be searched here: https://zapier.com/apps

Each app has a profile page that lists the available triggers/actions and help links.

 

Looker: 

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor
S
  • Stacy S.
  • New
  • April 25, 2026

Hey Steve, good news: you don't need Looker for this and the Zapier-to-Google Sheets path is actually the right call.

To answer your questions directly:

A) No native Looker integration in Zapier right now, and I haven't seen anything on the roadmap.

B) Yes, a dedicated Zap to sync your table to Google Sheets is exactly what you'd build. It's straightforward: trigger on record updated in Zapier Tables, map your fields, write to Sheets. Looker Studio (free, formerly Data Studio) then connects directly to that Sheet as its data source.

C) A few things that'll save you time:

Looker Studio handles your color coding natively through conditional formatting rules on table columns. Set it once, it's persistent.

For the refresh requirement: Looker Studio auto-refreshes on a schedule you control, but the 10-minute interval during business hours only is not something it handles natively. Easiest workaround is to leave the dashboard open in a browser tab and use a free Chrome extension like Tab Reloader to force a refresh on whatever schedule you want. For the public holiday exclusion, that logic lives in your Zap, not your dashboard. Just add a filter step that checks the date before syncing.

For the desktop shortcut: once your Looker Studio report is published, bookmark it and create a browser shortcut on the desktop. Done.

The main lesson from this setup: keep your Google Sheet clean. Looker Studio gets confused fast if your field names or data types are inconsistent. Lock down your schema before you build the dashboard.

S
  • SJH747Beginner
  • Author
  • Beginner
  • April 25, 2026

Hey Stacy,

 

Thanks for the reply. I have now built the dashboard via the ZAP and Google Sheet method, however the Looker Report (dashboard) using the Google Sheet data source is not refreshing every 15mins,  as set. I have triple checked the data source settings and reauthenticated the Google Sheet within Looker, however unless I manually refresh the data within the open Looker Report window,  the dashboard does not refresh. I am unfamiliar with the Chrome extension you reference and how that may assist.   Comments ?

 

Steve

 

 

 

Terms & ConditionsAccessibility statement