Google Slides + Google Sheets
Turn Google Sheets Data Into Google Slides Presentations Automatically
Stop copying and pasting — let tray.ai sync your spreadsheet data directly into your slide decks in real time.
Why integrate Google Slides and Google Sheets?
Google Sheets and Google Slides are two of the most widely used tools in Google Workspace, yet most teams still move data between them by hand. Whether you're building weekly business reviews, executive dashboards, or client reports, tray.ai pulls live Sheets data into Slides presentations without manual effort. Connect the two, and your presentations stay accurate every time they're opened.
Automate & integrate Google Slides & Google Sheets
Use case
Automated Weekly Business Review Decks
Most ops and finance teams build the same slide deck every week, swapping in new KPIs and metrics from a shared Google Sheet. With tray.ai, you can trigger a workflow each Monday that pulls the latest figures from your Sheets dashboard and populates a templated Google Slides presentation automatically. The deck arrives in stakeholders' inboxes fully updated before the meeting starts.
Use case
Dynamic Sales Pipeline Reports
Sales leaders need up-to-the-minute visibility into pipeline health, but building slides from CRM exports in Sheets is tedious. Tray.ai can watch for Sheets updates containing deal stages, revenue forecasts, or rep performance and automatically refresh a linked Google Slides sales report. Your sales deck becomes a living document that reflects the current state of the pipeline.
Use case
Client Reporting and Agency Deliverables
Agencies and consultancies often deliver recurring performance reports to clients in presentation format. By storing client data — ad spend, traffic, conversions — in Google Sheets and connecting it to a branded Google Slides template via tray.ai, teams can auto-generate polished, client-ready decks at scale. Each client gets their own tailored report without any manual slide building.
Use case
Real-Time Financial Dashboard Presentations
Finance teams maintaining budget trackers and P&L statements in Google Sheets can use tray.ai to push summary data into a Google Slides executive presentation on a defined schedule or on demand. CFOs and finance directors always have a presentation-ready snapshot without waiting for manual slide refreshes.
Use case
Project Status and Milestone Tracking Slides
Project managers often track milestones, blockers, and completion percentages in Google Sheets, then rebuild status slides for stakeholder meetings from scratch. Tray.ai maps project data fields from Sheets directly into pre-built slide templates, auto-generating status decks for every active project or program. Teams spend less time making slides and more time moving work forward.
Use case
Marketing Campaign Performance Recaps
Marketing teams tracking campaign metrics across channels in Google Sheets can automate the creation of post-campaign recap decks in Google Slides. When a campaign period closes and the final data is logged in Sheets, tray.ai triggers a workflow that builds the recap slide deck automatically, complete with channel breakdowns, cost data, and conversion summaries.
Use case
Training and Onboarding Material Updates
Teams that maintain dynamic onboarding decks or training materials — where product names, pricing, org charts, or process steps live in a master Google Sheet — can use tray.ai to automatically update the corresponding Google Slides presentation whenever the source data changes. New hires always get training materials that reflect how the business actually works today.
Get started with Google Slides & Google Sheets integration today
Google Slides & Google Sheets Challenges
What challenges are there when working with Google Slides & Google Sheets and how will using Tray.ai help?
Challenge
Keeping Presentations in Sync With Frequently Changing Data
Google Sheets data changes constantly — sales figures update hourly, project statuses shift daily — but Google Slides has no native way to pull in those changes automatically. Teams either work with stale decks or spend significant time manually refreshing slide content before every meeting.
How Tray.ai Can Help:
Tray.ai lets you define scheduled or event-driven workflows that detect changes in Google Sheets and automatically push updated values into the correct text boxes, tables, and charts in your Google Slides presentation. Your deck stays current without anyone touching it.
Challenge
Scaling Personalized Presentations Across Multiple Clients or Projects
When the same slide template needs to be populated with different data for dozens of clients, regions, or projects, doing it manually becomes impossibly time-consuming. A single template may need to be duplicated and customized tens or hundreds of times per reporting cycle.
How Tray.ai Can Help:
Tray.ai workflows can loop through all rows in a Google Sheet, dynamically create a copy of a master Slides template for each record, and populate each copy with that row's unique data — generating dozens of personalized presentations in the time it would take to build one manually.
Challenge
Maintaining Consistent Formatting and Branding Across Decks
When multiple team members manually update slides from spreadsheet data, formatting inconsistencies creep in — wrong fonts, misaligned tables, off-brand colors. This is especially problematic in client-facing or executive presentations where polish matters.
How Tray.ai Can Help:
By using a locked Google Slides master template and letting tray.ai handle all data population programmatically, teams ensure every generated presentation uses exactly the right layout, typography, and structure — no more formatting fixes before the big meeting.
Challenge
Complex Data Transformation Before Populating Slides
Raw data in Google Sheets often isn't presentation-ready — it may need to be aggregated, rounded, formatted as currency, or filtered before it belongs on a slide. Without a middleware layer, teams have to manually clean and transform data before copying it across.
How Tray.ai Can Help:
Tray.ai's built-in data mapping and transformation tools let you clean, format, aggregate, and conditionally filter Google Sheets data mid-workflow before it ever reaches Google Slides. Your presentations always display correctly formatted numbers and labels, with no manual cleanup step.
Challenge
Triggering Presentation Updates Without Manual Oversight
Many teams want presentations to update automatically when specific business events happen — a deal closes, a milestone is hit, a report is approved — but Google Sheets and Slides have no native way to connect those event-driven triggers to presentation updates without manual checking.
How Tray.ai Can Help:
Tray.ai supports a wide range of triggers including row additions, cell value changes, form submissions, and webhooks from other apps. You define exactly what business event should kick off a Slides update, and tray.ai handles the rest — no manual checking required.
Start using our pre-built Google Slides & Google Sheets templates today
Start from scratch or use one of our pre-built Google Slides & Google Sheets templates to quickly solve your most common use cases.
Google Slides & Google Sheets Templates
Find pre-built Google Slides & Google Sheets solutions for common use cases
Template
Weekly Metrics Digest: Sheets to Slides
On a weekly schedule, this template reads a defined range of KPI data from a Google Sheet and populates a templated Google Slides presentation, replacing placeholder text and chart data with the latest values before sharing the deck via email or Slack.
Steps:
- Trigger the workflow on a weekly schedule (e.g., every Monday at 7 AM)
- Read specified cell ranges or named data from the target Google Sheet
- Update text placeholders and linked chart data in the Google Slides template
Connectors Used: Google Sheets, Google Slides
Template
New Sheet Row → Append Slide to Presentation
When a new row is added to a Google Sheet — such as a new client, project, or product — this template automatically generates and appends a new corresponding slide to a master Google Slides deck using that row's data to populate the slide layout.
Steps:
- Trigger when a new row is detected in the specified Google Sheet
- Extract field values from the new row (name, description, metrics, etc.)
- Create and append a new slide to the target presentation using the extracted data
Connectors Used: Google Sheets, Google Slides
Template
On-Demand Client Report Generator
When triggered manually or via a form submission, this template pulls client-specific data from a Google Sheet, copies a master slides template, and populates it with that client's metrics to produce a ready-to-share presentation.
Steps:
- Trigger the workflow via webhook, form submission, or manual trigger
- Look up the client's data row in the Google Sheet using a client ID or name
- Copy the master Slides template and replace all placeholders with the client's data
Connectors Used: Google Sheets, Google Slides
Template
Monthly Financial Summary Slide Refresh
At month-end close, this template reads summary financial figures from a Google Sheet and updates a pre-built executive Google Slides presentation, refreshing all data fields and charts so the deck is board-ready without any manual editing.
Steps:
- Trigger on a monthly schedule tied to financial close (e.g., 1st of each month)
- Read revenue, cost, margin, and variance data from the finance Google Sheet
- Update all corresponding text fields and embedded chart data in the Slides presentation
Connectors Used: Google Sheets, Google Slides
Template
Project Status Deck Auto-Builder
This template scans a project tracker Google Sheet for all active projects and generates or updates individual status slides in a master Google Slides deck, mapping project name, owner, status, and completion percentage from Sheets into a standardized slide layout.
Steps:
- Trigger on a schedule or when the project Sheets tracker is updated
- Loop through all active project rows and extract status fields
- Create or update the corresponding slide in the master Google Slides deck for each project
Connectors Used: Google Sheets, Google Slides
Template
Campaign Recap Deck Generator
When a campaign is marked as complete in a Google Sheet (e.g., a status column is set to 'Done'), this template automatically builds a campaign recap Google Slides presentation using the campaign's performance data, ready to share with stakeholders or clients.
Steps:
- Trigger when a row in the campaigns Google Sheet has its status column set to 'Done'
- Read all performance data fields for that campaign row from the Sheet
- Generate a new Google Slides recap deck from the campaign template and populate it with the data
Connectors Used: Google Sheets, Google Slides