Back to Portfolio
automation production

Weekly Sales Slides Automation

Automated weekly presentation system that transforms raw data into polished sales decks

1,624
Lines of code
300+
Hours saved/year
4
Technologies

Tech Stack

Google Apps ScriptGoogle SlidesGoogle SheetsData Visualization

The Problem

Every Monday morning, the sales team needed updated regional performance decks. Before automation, this meant:

  • Manually pulling data from multiple sources
  • Copying and pasting into template slides
  • Formatting charts and tables by hand
  • Repeating for each region

Four hours of grunt work. Every single week.

The Solution

A complete automation pipeline that runs on schedule:

  1. Data Collection - Scripts pull from various source sheets
  2. Transformation - Numbers crunched into presentation-ready formats
  3. Slide Generation - Clean decks created from templates
  4. Distribution - Automatically shared with regional managers

The Impact

  • 300+ hours saved annually
  • Zero manual intervention after initial setup
  • Consistent formatting across all regions
  • Monday mornings reclaimed for actual sales work

Technical Details

Built with Google Apps Script, leveraging Slides API for dynamic content insertion. Custom charting logic handles edge cases the native tools can’t.

The system includes error handling, logging, and Slack notifications for any issues.

Need something similar for your team?

Let's Talk