cotera

Auto-Generate Weekly Report Deck

Duplicate your report template and fill it with this week's numbers. Stop rebuilding the same slides every Monday morning.

Weekly reportingTeam updatesKPI trackingTemplate automation

The Challenge

Every week, you duplicate last week's slide deck, delete the old numbers, type in the new ones, update the date, and fix the formatting you accidentally broke. It is the same 10 slides with different numbers, but it still takes 30-60 minutes because you are doing it all by hand.

What This Prompt Does

Read Template

Inspects your template deck to understand its structure and placeholders

Duplicate Slides

Creates a fresh copy of the template for this week

Fill in Metrics

Replaces all placeholder text with your actual numbers

Report Summary

Confirms every placeholder was replaced with the correct value

The Prompt

The Prompt

Task

Take a Google Slides template presentation, duplicate it to create this week's report, and replace placeholder text with the latest metrics and updates provided by the user.

Input

The user will provide:

  1. The template presentation ID
  2. This week's metrics and updates (numbers, highlights, blockers)

Example: "Create this week's report from template 1abc2def. Revenue: $125K, New signups: 340, Churn: 2.1%, Top win: Closed Acme deal for $50K"

Context

Strategy

  1. Use @Google Slides/Get PresentationName it "Google Slides/Get Presentation" and call it with @Google Slides/Get Presentation to read the template and understand its structure
  2. Use @Google Slides/List SlidesName it "Google Slides/List Slides" and call it with @Google Slides/List Slides to identify all slides and their object IDs
  3. Use @Google Slides/Duplicate ObjectName it "Google Slides/Duplicate Object" and call it with @Google Slides/Duplicate Object to create a copy of the template presentation (duplicate slide by slide into a new presentation, or the user can manually duplicate the file first)
  4. Use @Google Slides/Replace TextName it "Google Slides/Replace Text" and call it with @Google Slides/Replace Text to swap out placeholder values with this week's data

Placeholder Convention

The template should use placeholders in the format {{PLACEHOLDER_NAME}}. Common placeholders:

  • {{WEEK_OF}} - The date range for this report
  • {{REVENUE}} - Revenue figure
  • {{SIGNUPS}} - New signups count
  • {{CHURN_RATE}} - Churn percentage
  • {{TOP_WIN}} - Biggest win of the week
  • {{BLOCKERS}} - Current blockers or risks
  • {{NEXT_WEEK}} - Goals for next week

Tips

  • If the template does not use placeholders, list what text appears on each slide so the user can confirm what to replace
  • Always update the title slide with the current week's date
  • Use matchCase: false for placeholder replacement to handle inconsistencies

Output

A link to the completed weekly report presentation with:

  • All placeholders replaced with current data
  • A summary of which slides were updated and what was changed

Example Usage

Try asking:

  • →"Create this week's report using template 1abc2def. Revenue: $125K, signups: 340, churn: 2.1%"
  • →"Generate the weekly ops deck. MRR is $450K, support tickets: 89, NPS: 72"
  • →"Fill in Monday's team update from template xyz. Sprint velocity: 42 points, bugs fixed: 15, features shipped: 3"