Auto-Generate Weekly Report Deck

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