Weekly Google Slides Report

This workflow automates weekly report generation in Google Slides with Slack alerts, replacing manual slide assembly in PowerPoint or Docs that involves pulling metrics from sheets, formatting charts, and emailing—tedious tasks draining 12-18 hours weekly for managers compiling 5-10 slides on KPIs like sales/revenue from disparate sources, often resulting in outdated visuals and delayed reviews. It triggers Mondays at 9 AM, preps data (report ID/title, week dates), creates blank presentations, fetches info, updates title (e.g., 'Weekly Report - October 14, 2025'), adds metrics slide (achievements, KPIs, focus areas with placeholders), shares publicly, notifies Slack (#reports) with editable link/period, and logs outcomes with durations/errors for audits. Key nodes: Cron (0 9 * * 1 UTC), Set for metadata (weekStart/end, currentDate), GoogleSlides create/get/replaceText (title/subtitle, metrics content), GoogleDrive share (reader/anyone), Slack post (text/attachments: title link, metrics summary), multiple IFs (success checks: !error && presentationId), Functions for handlers (errorReport: status/operation/details, cleanup flag), and manual trigger for tests. This aids ops/managers at SMBs (20-100 employees) tracking weekly progress in sales/marketing, ensuring consistent, shareable decks without design tools.\n\nBy streamlining from trigger to share, it saves 15 hours/week on 4 reports, cutting prep time 65% and enabling real-time collaboration via links—ROI 320% in 4 months for remote teams. Fits consultancies reviewing client metrics or e-com tracking orders. Requires Google Workspace Business ($6/user/mo Slides/Drive), Slack Pro ($8.75/user/mo channels), n8n Cloud ($20/mo). Scales to bi-weekly/10 slides but Google API limits 300/min; add Sheets integration for data pulls.\n\nDocker n8n (n8n.io/download: docker run -p 5678:5678 n8nio/n8n) or cloud.n8n.io (5-min). Google: console.cloud.google.com/apis (enable Slides/Drive APIs, service account JSON to GoogleApi creds). Slack: api.slack.com/apps (bot token to SlackApi: botToken). Import JSON, connect creds to nodes, set Cron '0 9 * * 1' (Monday 9AM UTC). Update placeholders in replaceText; test via manual trigger, verify Slides creation/link in Slack.\n\nTest: Execute Cron/manual, input dates; check Slides (title/metrics), Slack post (link/period), console logs. Errors: 403 Auth (re-creds), invalid dates (IF fallback), 429 Rate (add Wait post-create). Activate toggle, monitor dashboard. Maintain: Backup Slides monthly, rotate tokens; optimize with Merge for multi-metrics. Scale: n8n queues; quarterly template audits.", "businessValue": "Saves 15 hours/week on 4 reports, enables 65% faster sharing, boosts review efficiency 40%", "setupTime": "35-50 minutes", "difficulty": "Intermediate", "requirements": ["Google Workspace Business ($6/user/mo for Slides/Drive)", "Slack Pro ($8.75/user/mo for channels)", "n8n Cloud or self-hosted"], "useCase": "Automated weekly KPI slides with Slack delivery for team progress reviews"