weekly-ai-adoption-digest

Weekly AI Adoption Digest

Auto-generate a weekly summary of AI usage trends, new skill adoptions, and productivity wins for leadership.

Integrations: Slack, Google Sheets

When to Use

• The user wants to set up recurring AI adoption reports
• Leadership asks for regular updates on AI tool usage
• The user mentions "weekly digest", "adoption report", "AI summary", or "leadership update"
• Teams need to communicate AI adoption progress consistently

Steps

Step 1: Define Digest Content

Help the user choose which sections to include:

Step 2: Set Up Data Collection

For each section, configure the data source:

Automated Data (Google Sheets):

• Create a "Weekly Metrics" sheet with columns for each tracked metric
• Add formulas to calculate week-over-week changes
• Set up data validation for manual entries

Manual Submissions:

• Create a Slack workflow or Google Form for "Productivity Win" submissions
• Template: "What tool did you use? What did you accomplish? How much time did you save?"

Skills Tracking:

• Run npx skills list across projects to inventory installed skills
• Compare against previous week to identify new installations

Step 3: Design the Digest Template

Create a consistent format:

AI Adoption Weekly Digest — Week of [DATE]

USAGE SNAPSHOT
  Active Users: XXX (+X% from last week)
  Total Sessions: X,XXX
  Trending: [up/down/stable]

NEW ADOPTIONS THIS WEEK
  - [Name] ([Team]) started using [Tool]
  - [Name] ([Team]) installed [Skill]
  - X new users total

TOP WORKFLOWS
  1. [Workflow] — used X times
  2. [Workflow] — used X times
  3. [Workflow] — used X times

PRODUCTIVITY WIN OF THE WEEK
  "[Quote from team member about their AI success story]"
  — [Name], [Team]
  Impact: Saved X hours on [task]

COST UPDATE
  This Week: $X,XXX
  Month to Date: $XX,XXX
  Budget Remaining: $XX,XXX (XX%)

CHAMPION SPOTLIGHT
  [Name] from [Team] helped X team members get started
  with [Tool] this week. Their team's adoption rate is now XX%.

TIP OF THE WEEK
  [Practical tip for using AI tools more effectively]

COMING UP
  - [Date]: [Event/Training]
  - [Date]: [New tool rollout]

Step 4: Configure Slack Delivery

Set up automated Slack posting:

• Channel: #ai-adoption or #engineering-leadership
• Schedule: Every Monday at 9:00 AM (configurable)
• Format: Rich Slack message with sections, emoji indicators, and expandable details
• Thread: Auto-thread detailed data below the summary

Provide a Slack message template with Block Kit formatting.

Step 5: Create the Google Sheets Backend

Build a spreadsheet with:

• Sheet 1: Current Week — This week's data entry (manual + automated)
• Sheet 2: Historical Data — Rolling 52-week history for trend analysis
• Sheet 3: Charts — Auto-generated charts (adoption curve, cost trend, top workflows)
• Sheet 4: Digest Generator — Formulas that compose the digest text from current week data
• Sheet 5: Configuration — Editable settings (team names, tool list, Slack channel, schedule)

Step 6: Establish the Process

Define who does what each week:

Output

Deliver:

• Slack message template (Block Kit JSON)
• Google Sheets backend with formulas and charts
• Data collection form/workflow
• Process runbook for weekly maintenance
• Sample digest with realistic example data