Data & Analytics

Dashboard Generator

Auto-build Looker Studio or Google Sheets dashboards from connected data sources.

Automation overview

What this automation does

This automation starts when weekly schedule or Slack `/dashboard` with metric domain. It google sheets process via google sheets, openai process via openai, x (twitter) process via x (twitter), and notion creates, then creates Looker Studio report from template clone, shares view link Slack #data, and logs dashboard catalog Notion with refresh schedule and owner.

Trigger

Weekly schedule or Slack `/dashboard` with metric domain

Main actions

Google Sheets process via Google Sheets → OpenAI process via OpenAI …

Final outcome

creates Looker Studio report from template clone, shares view link Slack #data, …

Execution time

30–90 seconds

Apps used

5 integrations

AI-powered

Difficulty

Beginner

Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger

Slack

Scheduled run

Step 1

Google Sheets

Process via Google Sheets

OpenAI

Process via OpenAI

Step 3

X (Twitter)

Process via X (Twitter)

Step 4

Notion

Creates

Result

Notion

Workflow complete

Step-by-step

How each step runs

1
SlackTrigger
Scheduled run
Weekly schedule or Slack `/dashboard` with metric domain
2
Google Sheets
Process via Google Sheets
Weekly trigger or Slack `/dashboard sales` reads BigQuery or Sheets data source config, GPT suggests chart types per metric
3
OpenAI
Process via OpenAI
Weekly trigger or Slack `/dashboard sales` reads BigQuery or Sheets data source config, GPT suggests chart types per metric
4
X (Twitter)
Process via X (Twitter)
line for revenue trend, bar for SKU mix
5
Notion
Creates
creates Looker Studio report from template clone, shares view link Slack #data, and logs dashboard catalog Notion with refresh schedule and owner.
6
Notion
Workflow complete
creates Looker Studio report from template clone, shares view link Slack #data, and logs dashboard catalog Notion with refresh schedule and owner.

Apps used

Connected applications

Slack

Process via Slack

Google Sheets

Process via Google Sheets

OpenAI

Process via OpenAI

X (Twitter)

Process via X (Twitter)

Notion

Creates

Summary

Automation summary

Trigger: Weekly schedule or Slack `/dashboard` with metric domain
Inputs: Weekly schedule or Slack `/dashboard` with metric domain, Business Name, Notification Email, Timezone
Outputs: creates Looker Studio report from template clone, shares view link Slack #data, and logs dashboard catalog Notion with refresh schedule and owner., X (Twitter) process via X (Twitter), Notion creates
Business goal: Automate dashboard generator end-to-end with accurate app routing.
Execution frequency: Weekly
Estimated runtime: 30–90 seconds
Error handling: Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies: Slack, Google Sheets, OpenAI

Benefits

Why use this automation?

Save ~11 hours/week

Remove repetitive steps from Dashboard Generator so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Faster response times

Events trigger immediate actions instead of waiting for someone to check a queue.

Requirements

What you need to get started

Required apps

Slack
Google Sheets
OpenAI

Required accounts

Active Slack workspace with API access
Active Google Sheets workspace with API access
Active OpenAI workspace with API access
Shata Automation workspace (free tier supported)

Required API keys

OAuth tokens for each connected integration

Permissions

Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
Write access on destination apps (email, chat, CRM, or storage)

Estimated setup time

45 min including app authorization and test run
Difficulty: Beginner

Optional apps

X (Twitter) (optional)
Notion (optional)

Automation runtime

Activate this template

PartialSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft

Activation readiness

Est. setup time: ~11 min

Required connections

Slack(required)
⚠ Missing
Google Sheets(required)
⚠ Missing
OpenAI(required)
⚠ Missing
x(required)
Previewx: workflow actions run in preview
⚠ Missing

• Missing connection: Slack
• Missing connection: Google Sheets
• Missing connection: OpenAI
• Missing connection: x

Manage all connections →View all installations →

Workflow summary

Trigger: Weekly schedule or Slack `/dashboard` with metric domain
Steps: 6 nodes
Required apps: 4
Optional apps: 1

Trigger

Schedule trigger

Activate this workflow to provision the trigger endpoint.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

FeaturedFreeBeginnerPartial45 min setup★3.83.5k installs · 206 reviews

Customize for My Business

Analytics

Template performance

31.6k

Views

3.5k

Installs

289

Favorites

3.8

Avg rating

11.1%

Conversion

45 min

Setup time

97%

Success rate

105

Trending score

Most used integrations

SlackGoogle SheetsOpenAI

Weekly trigger or Slack `/dashboard sales` reads BigQuery or Sheets data source config, GPT suggests chart types per metric—line for revenue trend, bar for SKU mix—creates Looker Studio report from template clone, shares view link Slack #data, and logs dashboard catalog Notion with refresh schedule and owner.

Some steps run in preview until their integrations go live.

Required apps

SlackLiveGoogle SheetsLiveOpenAILiveX (Twitter)Preview

Optional apps

NotionPreview

All integrations

SlackGoogle SheetsOpenAIX (Twitter)Notion

Workflow preview

How Dashboard Generator runs

Trigger

Define metric domains

→

Process

Rule engine

→

Action

slack

→

Notify

Alert & log

SlackGoogle SheetsOpenaiXNotion

Setup steps

Get started in 5 steps

1
Connect data sources
BigQuery, Google Sheets, Looker Studio API, Notion catalog, Slack.
2
Define metric domains
Sales, marketing, ops templates with standard chart sets.
3
Clone report template
Master template duplicated; data source swapped per request.
4
Configure refresh
Daily BigQuery scheduled query feeds dashboard data.
5
Validate chart accuracy
Spot-check totals against source SQL before share.

Variables

Configurable settings

Variable	Type	Default	Required
Business Name	text	Your Business	Yes
Notification Email	email	—	Yes
Timezone	select	—	Yes
Slack Channel	text	#general	No
Google Sheet ID	text		No
Sheet Range	text	Sheet1!A:Z	No

FAQ

Frequently asked questions

Tableau instead?

Export CSV snapshot branch for Tableau upload manual.

Row-level security?

Looker Studio viewer filters by team email domain.

Custom metrics?

Sheets config row adds calculated field formula to template.

Mobile layout?

Template includes mobile-optimized chart arrangement.

Reviews

4.7

★4.7

206 total reviews

Emily Davis

Customer Success · SupportPro

★★★★★

6/29/2026

Dashboard Generator replaced a manual process that took 2 hours daily. ROI was clear within the first month.

+ Support team helped customize quickly · Setup was straightforward

Omar Khalil

E-commerce Manager · Noon Seller

★★★★★Verified install

6/12/2026

We deployed this across three locations and saw immediate time savings. The Dashboard Generator workflow handles edge cases we didn't expect it to.

+ Scales well as we grow · Integrations worked on first try

Sarah Mitchell

Marketing Director · Bloom Agency

★★★★Verified install

5/26/2026

Solid template. We duplicated and tweaked variables for our brand. Would recommend for teams starting automation.

+ Saved our team 10+ hours weekly · Reliable triggers every time

− Took longer than estimated for advanced config

Documentation

Template documentation

Overview

Requirements

Active slack account with API access
Active google-sheets account with API access
Active openai account with API access
Active x account with API access
No AI provider required
Shata Automation workspace (free tier supported)

Supported apps

slackLivegoogle sheetsLiveopenaiLivexPreviewnotionPreview

Triggers

Weekly schedule or Slack `/dashboard` with metric domain

Actions

Define metric domains
Clone report template
Configure refresh
Validate chart accuracy

Examples

Quick start

Activate Dashboard Generator with default variables and run a sandbox test.

Scenario: New user installs template and validates output in under 15 minutes.

Production rollout

Connect live apps, map business rules, enable monitoring alerts.

Scenario: Team deploys to workspace after QA sign-off on test runs.

Troubleshooting

Workflow fails on first run: Verify OAuth scopes for all required integrations and re-authorize if expired.
Variables not applying: Check required fields in the Configure Variables step; empty required values block activation.
Notifications not received: Confirm notification email and Slack channel IDs match your workspace settings.

Release notes

Version 1.2.0 — Improved reliability and Slack notifications for Dashboard Generator.

Versioning

Version history

Current version: 1.2.0

v1.2.0Current

1/7/2026

improvementImproved error handling and retry logic for failed runs.
featureAdded optional Slack notification on workflow completion.

v1.1.0

11/8/2025

featureNew variable: brand voice selector for AI-powered steps.
fixFixed timezone handling for scheduled triggers.

v1.0.0

9/9/2025

featureInitial marketplace release.

Recommendations

Free

CSV Upload Dashboard Update

CSV Upload Dashboard Update — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.

BeginnerPreview5 min

★4.75.7k installs

Free

KPI Alerts

Monitor KPI thresholds and alert Slack or PagerDuty when metrics breach targets.

AdvancedLive5 min

★4.38.7k installs

Free

KPI Threshold Alert

KPI Threshold Alert — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.

IntermediatePartial45 min

★4.58.9k installs

Free

Executive Metrics Monday Brief

Executive Metrics Monday Brief — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.

IntermediatePartial15 min

★4.59.9k installs

Recommendations

Customize Dashboard Generator for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.

Request custom automation →Talk to an expert

Dashboard Generator

What this automation does

End-to-end scenario flow

How each step runs

Connected applications

Automation summary

Why use this automation?

What you need to get started

Required apps

Required accounts

Required API keys

Permissions

Estimated setup time

Optional apps

Activate this template

Required connections

Workflow summary

Trigger

Run history

Template performance

How Dashboard Generator runs

Get started in 5 steps

Configurable settings

Frequently asked questions

Template documentation

Overview

Requirements

Supported apps

Triggers

Actions

Examples

Troubleshooting

Release notes

Version history

Related templates

CSV Upload Dashboard Update

KPI Alerts

KPI Threshold Alert

Executive Metrics Monday Brief

Customers also installed

Executive Metrics Monday Brief

KPI Threshold Alert

KPI Alerts

HubSpot Pipeline Snapshot

Trending this week

Canva Asset Approval Flow

To-do Manager

Pull Request Review Summary

Inbox Priority Briefing

Customize Dashboard Generator for your business

Template documentation

Overview

Requirements

Supported apps

Triggers

Actions

Examples

Troubleshooting

Release notes

Version history

Related templates

CSV Upload Dashboard Update

KPI Alerts

KPI Threshold Alert

Executive Metrics Monday Brief

Customers also installed

Executive Metrics Monday Brief

KPI Threshold Alert

KPI Alerts

HubSpot Pipeline Snapshot

Trending this week

Canva Asset Approval Flow

To-do Manager

Pull Request Review Summary

Inbox Priority Briefing