Automate Slide Creation with the Gamma API (Spreadsheet → Presentation)

About this video

Kevin, teaming up with Gamma, automates his weekly Kevin Cookie Company sales report using the new Gamma 3.0 API with Zapier, noting Make or n8n can also work. Each row in his Google Sheet is one week, tracking sales across four cookie types plus other management metrics; instead of manually copying charts into PowerPoint, a new row will trigger a deck. He describes the automation to Zapier Copilot in plain English — ‘When a new row is added in my Google Sheet, generate a slide deck in Gamma with a weekly sales summary’ — and Zapier proposes a trigger (new/updated spreadsheet row) and an action (send data to Gamma’s API). He connects the KCC sales data spreadsheet and its sales data worksheet, tests the trigger, then connects Gamma: an API key, created under Settings and Members > API key and named ‘Zapier’, requires at least the Pro plan. In the action he writes an input-text prompt requesting an overview slide, per-cookie performance, ROI trend, and insights and next steps, then maps spreadsheet columns into the prompt with the forward-slash key so revenue, profit and ROI flow in automatically each week. He sets format to presentation (documents or social posts are also options) and number of cards to four, tests the step, and finds a finished deck under Gamma’s API generated section. After naming the Zap ‘Weekly Metrics to Gamma presentation’ and publishing it, adding a new row for the week ending October 13 generates a new presentation automatically. Finally he uses Gamma 3.0’s Agent to add a one-slide executive summary as slide two and switch to a dark theme, then notes decks can be presented from Gamma, shared by link, exported as PDF or PowerPoint, or emailed automatically via Zapier.

Key takeaways

• Pattern: spreadsheet row added = trigger, Gamma API generation = action, connected through Zapier (Make or n8n also work)
• Getting a Gamma API key requires at least the Pro plan; create it in Settings and Members > API key and paste it into Zapier
• Map sheet columns into the Gamma prompt with the slash key so numbers update automatically instead of hard-coding values
• Field mapping matters: define requested slides (overview, product performance, ROI trend, insights/next steps), format, and card count in the action
• Gamma’s Agent can post-edit generated decks — e.g. inserting an executive summary slide or switching to a dark theme

Episode details: published October 29, 2025 · 12:17 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: How to Fix Laggy Playback in DaVinci Resolve · Next: Base44 Tutorial for Beginners →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube