The Scenario
You are a BI team lead. Your company is rolling out Lakeview dashboards to five business units — Sales, Finance, Operations, Marketing, and Customer Success. Each unit needs a starter dashboard tied to their dedicated SQL warehouse.
The dashboard names, display names, and warehouse IDs are already in a Google Sheet that the business unit leads filled in during a planning call. You promised them live dashboard links by end of business today.
The bad version:
- You open the Databricks workspace UI
- You navigate to Dashboards, click "Create," fill in the name, pick the warehouse, save
- You copy the dashboard URL and paste it back into the spreadsheet
- You do this five times
- You realize you named the fourth one wrong and have to delete and recreate it
- It is 5:45 PM and you still need to send five links.
The fast version is one prompt before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that calls the Databricks Lakeview API directly, so you do not have to click through the dashboard creation flow five times.
Open the SheetXAI sidebar and type:
For each row in the DashboardSpec sheet (columns: display_name in column A, warehouse_id in column B), create a new Databricks Lakeview dashboard with a blank starting page. Write the returned dashboard ID into column C and the dashboard URL into column D for each row. Process all rows.
SheetXAI reads the DashboardSpec sheet, calls the Databricks Lakeview API once per row, creates each dashboard, and writes the ID and URL back into the sheet. You send the column D links to the business unit leads. Done before noon.
What You Get
The DashboardSpec sheet, now populated with two new columns:
- Column C — dashboard ID (for the Databricks workspace reference)
- Column D — dashboard URL (the link to send to each business unit lead)
Each dashboard is live and tied to the correct SQL warehouse. The business unit teams can open the URL and start adding their own charts and filters without waiting on BI to do it for them.
What If the Data Is Not Quite Ready
Bulk dashboard creation hits edge cases when the input data is imperfect. SheetXAI handles them in the same prompt.
When some warehouse IDs in the sheet are clearly wrong
A few rows have warehouse IDs that look like placeholder text — "TBD" or "ask-john" — that the business unit leads never replaced.
For each row in the DashboardSpec sheet, check whether column B looks like a valid Databricks warehouse ID (alphanumeric, no spaces). If it does not, skip that row and write "INVALID WAREHOUSE ID" into column D. For valid rows, create the Lakeview dashboard and write the URL into column D.
When the business unit leads want their dashboards immediately published
A newly created Lakeview dashboard is in draft state. They want them published so internal viewers can access them without editor permissions.
For each row in the DashboardSpec sheet, create a new Databricks Lakeview dashboard using the display_name in column A and warehouse_id in column B. After creating each dashboard, immediately publish it so it is accessible to all workspace users. Write the published dashboard URL into column D and the dashboard ID into column C.
When only some rows should be processed this run
Three of the five business units are ready. Two are still waiting on IT to provision their warehouses. Those rows have "PENDING" in column B.
For each row in the DashboardSpec sheet where column B does not say "PENDING," create a new Databricks Lakeview dashboard using the display_name and warehouse_id columns. Write the dashboard URL into column D. For PENDING rows, write "SKIPPED — PENDING" in column D.
When you want the dashboards created and then a notification message drafted for each lead
The business unit leads are in different Slack channels. You want to create the dashboards and then generate a short Slack message for each one to copy-paste.
For each row in the DashboardSpec sheet, create a Databricks Lakeview dashboard using columns A and B. Write the dashboard URL into column D. Then write a one-sentence Slack message into column E for each row using this format: "Hi [name from column A's business unit] — your Lakeview dashboard is ready: [URL from column D]. Let me know if you need any changes."
The pattern: what normally takes a round-trip per dashboard takes one prompt, regardless of how many rows are in the sheet.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of dashboard specs, then ask it to create the Databricks Lakeview dashboards and write the links back. The Databricks integration is included in every plan. For related workflows, see how to run a SQL query and land results in a sheet or the Databricks in Google Sheets overview.