# Google Slides + Google Sheets integration > Stop copying and pasting — let tray.ai sync your spreadsheet data directly into your slide decks in real time. **Canonical page:** https://tray.ai/connectors/google-slides-google-sheets-integrations/ **Google Slides connector:** https://tray.ai/connectors/google-slides-integrations/ **Google Slides documentation:** https://tray.ai/documentation/connectors/service/google-slides **Google Sheets connector:** https://tray.ai/connectors/google-sheets-integrations/ **Google Sheets documentation:** https://tray.ai/documentation/connectors/service/google-sheets ## Overview 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. Data-driven presentations are only as good as the data behind them. When your Google Sheets source changes — sales figures update, campaign metrics roll in, project statuses shift — manually refreshing your Slides deck introduces lag, errors, and wasted time. Integrating Google Sheets with Google Slides through tray.ai cuts out that friction. Teams can automatically populate charts, tables, and text placeholders in Slides using live or scheduled data from Sheets, so every stakeholder sees accurate numbers without anyone touching a single cell or slide. This matters most for recurring reports, investor updates, sales decks, and operational reviews where the structure stays fixed but the numbers change constantly. ## Use cases ### 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. - Eliminate 1–3 hours of manual copy-paste work every reporting cycle - Ensure all metrics reflect the most current data from your Sheets source - Standardize presentation format across teams and regions ### 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. - Reduce time spent building manual pipeline presentation updates - Give revenue leaders a reliable, always-current visual summary - Maintain consistent chart and table formatting across every report version ### 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. - Generate client reports in minutes instead of hours - Reduce human error in client-facing metrics and figures - Scale reporting across dozens of clients without adding headcount ### 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. - Keep board-ready financial summaries accurate without manual intervention - Schedule automated refreshes tied to close periods or board meetings - Maintain a single Sheets source of truth that feeds multiple slide audiences ### 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. - Auto-populate RAG status indicators and milestone dates from Sheets - Generate project-specific slides for large portfolios without manual effort - Keep leadership presentations consistently formatted and easy to digest ### 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. - Deliver campaign recap decks faster without manual slide assembly - Ensure consistency in how results are visualized across all campaigns - Free up marketing ops time for analysis rather than formatting ### 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. - Keep training slides in sync with the latest product or process data - Eliminate outdated information in onboarding decks without manual editing - Reduce the maintenance burden on L&D and enablement teams ## Templates ### 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. Connectors used: Google Sheets, Google Slides ### 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. Connectors used: Google Sheets, Google Slides ### 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. Connectors used: Google Sheets, Google Slides ### 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. Connectors used: Google Sheets, Google Slides ### 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. Connectors used: Google Sheets, Google Slides ### 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. Connectors used: Google Sheets, Google Slides ## Challenges Tray.ai solves ### 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 helps:** 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. ### 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 helps:** 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. ### 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 helps:** 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. ### 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 helps:** 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. ### 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 helps:** 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. ## Learn more - Intelligent Integration: https://tray.ai/platform/intelligent-ipaas/ - Merlin Agent Builder: https://tray.ai/platform/merlin-agent-builder/ - Agent Gateway for MCP: https://tray.ai/platform/agent-gateway/ - Book a demo: https://tray.ai/contact/