The Scenario
Every Monday morning you run the same ops meeting. You pull up a Google Sheet with 10 rows — one per department — and go through the KPIs column by column. It works, but your VP asked last week if you could send the deck in advance so people come prepared. Now you need a proper Google Slides presentation out of the same data you've been managing in a sheet for two years.
The bad version:
- Open Google Slides, create a new presentation, add a title slide
- Go back to the sheet, read row 1 (Department: Engineering, KPI 1: 94% uptime, KPI 2: 12 open tickets, KPI 3: 3 deploys this week), go back to slides, add a slide, type "Engineering" in the title box, add three bullets
- Repeat for all 10 departments
- Realize the slide you made for Finance uses a different font than the one for Marketing because you formatted them at different times
- Spend 20 minutes standardizing the formatting before you can send it to anyone
You've done this sheet-to-deck migration three times in the past year. Each time you told yourself you'd automate it. Each time, the meeting was in two hours and there wasn't time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your metrics table and, through its Google Slides integration, builds the status deck for you — one slide per department row, titles and KPI bullets pulled straight from your columns.
Read my Google Sheet and create a Google Slides presentation where each row becomes one slide — use the department name from column A as the slide title and the KPIs from columns B, C, and D as bullet points
What You Get
- A new Google Slides deck with 10 slides, one per department
- Each slide title populated from column A
- Each slide body showing the three KPI values from columns B, C, and D as formatted bullets
- Uniform slide structure across all departments without a manual formatting pass
What If the Data Is Not Quite Ready
Some KPI cells have notes mixed in with the numbers
A few cells in columns B through D contain values like "94% (down from 97% last week)" — the parenthetical will show up in the bullet if you don't clean it first.
Before building the slides, strip any text in parentheses from columns B, C, and D, then create the deck with the cleaned KPI values as bullet points
Two departments are missing data for this week
Rows 4 and 7 have empty cells in column C because those teams didn't submit their numbers.
Create the slide deck from my sheet. For any department where a KPI cell is empty, add a "Data pending" bullet in that position rather than leaving it blank
The VP wants a summary slide at the front before the department slides
One overview slide listing all departments and their primary KPI from column B.
Create a Google Slides presentation with a summary slide first that lists each department from column A and its primary KPI from column B in a single-column table, then add one detailed slide per department using columns A through D
Kill chain: audit the data, clean it, build the deck, and write back the link
Check columns A through D for missing values and note any gaps in column E. Clean any KPI cells that contain parenthetical notes by stripping the parenthetical text. Then build a Google Slides deck — one slide per department, column A as title, columns B through D as bullets — and write the presentation URL to cell F1 so I can share it from the sheet.
The whole Monday prep cycle collapses into one prompt.
Try It
Open your ops metrics sheet and get the 7-day free trial of SheetXAI, then ask it to generate this week's status deck in one request. You can also explore bulk-updating existing slide decks from a sheet or return to the Google Slides overview.