# 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.

Source: https://cotera.co/solutions/ops/google-slides-weekly-report

---

- **Team:** Operations
- **Tools:** Google Slides
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 1 hr/week

## How it works
1. **Read Template** — Inspects your template deck to understand its structure and placeholders
2. **Duplicate Slides** — Creates a fresh copy of the template for this week
3. **Fill in Metrics** — Replaces all placeholder text with your actual numbers
4. **Report Summary** — Confirms every placeholder was replaced with the correct value

## Example requests
- 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

## Prompt

```markdown
## 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 Presentation to read the template and understand its structure
2. Use @Google Slides/List Slides to identify all slides and their object IDs
3. Use @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 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
```

## Related reading
- [How to Automate Google Slides Presentations with AI](https://cotera.co/articles/automate-google-slides-with-ai.md)