n8n Weekly PowerPoint Reports: Google Sheets → SlideForge + Gmail

Send a polished weekly PowerPoint—automatically

This n8n workflow pulls weekly metrics from Google Sheets, generates an editable .pptx deck via the SlideForge API, downloads the file, and emails it every Monday morning using Gmail.

What this workflow does

• Schedules runs every Monday at 8:00 AM with an n8n scheduled trigger.
• Reads weekly metrics from a Google Sheets metrics sheet containing Metric and Value columns.
• Builds a SlideForge deck payload including:
  • a cover slide
  • a KPI slide showing up to five metrics
  • an additional table slide when there are more than five metrics
• Starts deck generation by sending the payload to the SlideForge render endpoint and using the returned job ID.
• Downloads the generated .pptx from SlideForge.
• Emails the .pptx attachment via Gmail to the configured recipient.

Use cases

• Weekly SaaS reporting: automatically deliver KPIs to leadership without manual deck creation.
• Operations updates: send a consistent SlideForge-based report every Monday morning from a shared metrics sheet.
• Automation engineers: standardize reporting outputs with an n8n + SlideForge workflow and repeatable formatting.

Technical details

• Schedule Trigger: runs every Monday at 8:00 AM.
• Google Sheets: reads all rows from the metrics sheet (expects Metric and Value columns).
• HTTP Request (SlideForge): uses Bearer auth (Authorization: Bearer <your_api_key>) to start rendering and retrieve the generated .pptx.
• Gmail: sends the PowerPoint as an attachment to the specified email recipient.
• n8n nodes used: code, gmail, sticky note, http request, google sheets, schedule trigger.

Setup checklist

• Configure Google Sheets credentials and select the spreadsheet/sheet.
• Create a SlideForge HTTP header auth credential (Bearer token) and select it in both SlideForge HTTP Request steps.
• Configure Gmail credentials and set the recipient email (and optional message text) in the Gmail step.