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 worksheet 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 worksheet you built already has everything needed to drive this. The problem is that monday.com's UI doesn't read from your workbook.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. 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 worksheet.
Read my Excel 'Widget Plan' table 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
What You Get
- One battery widget created on the dashboard per row in your Widget Plan worksheet.
- Board IDs and column IDs read directly from your worksheet — no re-entry required.
- The returned widget IDs written back to your workbook in column C so you have references for follow-up edits.
- Any row where widget creation fails flagged with the specific error in column D.
What If the Data Is Not Quite Ready
You need to create the dashboard first, then add widgets
The dashboard doesn't exist yet. Start from scratch.
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' worksheet showing item counts by status. Write the dashboard ID into cell E1.
Different boards need different widget types
Your Widget Plan has a 'Type' column in column C specifying chart or battery per row.
For each row in my 'Widget Plan' worksheet, add a widget to monday.com dashboard ID 998877001 using the board ID from column A, column ID from column B, and widget type from column C (chart or battery). Write the widget ID into column D.
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' worksheet — use column B for the status column ID on each board. Write the widget ID into column C.
Full dashboard setup from a config worksheet in one shot
Create a monday.com dashboard called 'Q2 Program Status' in workspace ID 445566778. For each row in 'Dashboard Config' worksheet, 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 worksheet without touching the monday.com UI.
Try It
Get the 7-day free trial of SheetXAI and open your dashboard configuration workbook 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.