Generate bulk Google Slides certificates 📜 as PDFs and email them with Gmail
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive, Google Sheets and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read File (Google Sheets): uses Google Sheets
- Process One at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Copy Slides Template (HTTP Request): calls an HTTP API (POST)
- Replace Template Placeholders (HTTP Request): calls an HTTP API (POST)
- Export to PDF (HTTP Request): calls an HTTP API
- Save PDF to Drive (Google Drive): uses Google Drive
- Send a message (Gmail): uses Gmail
- Mark as Processed (Google Sheets): update
- Merge: merges the data from its input branches
- Delete Temp Slide (HTTP Request): calls an HTTP API (DELETE)
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge - Wait
n8n-nodes-base.wait
From the author
This workflow automates the bulk generation and delivery of personalized certificates using Google Sheets, Google Slides, Google Drive, and Gmail. --- Key Advantages 1. ✅ Full Automation The workflow fully automates the certificate generation and distribution…