The Scenario
You're the project lead for a six-board program — each board tracks a different workstream — and your director just asked for a monday.com status dashboard that shows item counts by status for every board, with one widget per board. You have the board IDs in a configuration sheet you've been maintaining since the program kicked off. What you don't have is a dashboard, or the patience to create eight widgets by hand through the UI.
The bad version:
- Open monday.com, navigate to Dashboards, create a new dashboard, click Add Widget for board 1, pick Chart, configure the grouping to show items by status, save, repeat for board 2.
- Board 4's chart widget requires a different column mapping because that board uses a different status column name — stop, go back, figure out the correct column ID, re-configure.
- Finish all eight widgets an hour later. The director asks if you can add a battery widget for each board too. Start over.
The configuration sheet you built already has everything needed to drive this. The problem is that monday.com's UI doesn't read from your sheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your configuration table and, through its monday.com integration, creates the dashboard and adds the widgets — using the board IDs and column mappings you've already defined in the sheet.
Create a monday.com dashboard called 'Program Overview' in workspace ID 445566778 and add a chart widget for each board ID in column A of my 'Dashboard Config' sheet showing item counts by status
What You Get
- A new monday.com dashboard named 'Program Overview' in the specified workspace.
- One chart widget per board ID in your config sheet, each showing item counts by status.
- The returned dashboard ID written back to your sheet so you have the reference for follow-up widget additions.
- Any board where widget creation fails — wrong column type, insufficient permissions — flagged with the specific error so you know what to fix before sharing the dashboard.
What If the Data Is Not Quite Ready
The config sheet also has the specific column IDs for each board
Different boards use different column names for status. Your config sheet has the right column ID per board in column B.
Create a monday.com dashboard called 'Program Overview' in workspace ID 445566778. For each row in my 'Dashboard Config' sheet, add a chart widget for the board ID in column A using the column ID in column B to group by status.
You need battery widgets, not chart widgets
The director changed the ask. Battery widgets show completion percentage more clearly.
Read my 'Widget Plan' sheet and create one battery widget per row on monday.com dashboard ID 998877001 — use the board ID from column A and the column ID from column B for each widget.
The dashboard already exists and you need to add widgets to it
You created the dashboard manually earlier. Now you just need the widgets added from the config.
Add a chart widget to monday.com dashboard ID 667788990 for each board ID in column A of my 'Dashboard Config' sheet — use column B for the status column ID on each board. Write the widget ID into column C.
Full dashboard setup from a config sheet in one shot
Create a monday.com dashboard called 'Q2 Program Status' in workspace ID 445566778. For each row in 'Dashboard Config' sheet, add a chart widget for the board ID in column A using the column ID in column B. Also add a battery widget for each row using the same board and column IDs. Write dashboard ID into cell E1 and each widget's ID into column D.
One pass that builds the full dashboard from the config sheet without touching the monday.com UI.
Try It
Get the 7-day free trial of SheetXAI and open your dashboard configuration sheet with board IDs and column mappings, then ask it to generate the monday.com dashboard before your next program review. Also worth exploring: building a full account inventory or generating a cross-board status snapshot.