Generate course certificates from Google Sheets with Stencil PDF and Outlook
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Drive, Google Sheets and Microsoft Outlook. It also calls app.stencilpdf.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Test Data (Edit Fields (Set)): sets 5 fields: Mail, Participant, Course…
- E-Mail not sent (Filter): keeps only the items that match a condition
- Input (Edit Fields (Set)): sets or maps fields
- Generate report (HTTP Request): calls app.stencilpdf.com (POST)
- Merge: merges the data from its input branches
- Upload file (Google Drive): uses Google Drive
- Update row in sheet (Google Sheets): update
- Send a message (Microsoft Outlook): uses Microsoft Outlook
- Update row in sheet (Google Sheets): update
Services it uses
HTTP calls to: app.stencilpdf.com
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 (10)
- HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Merge
n8n-nodes-base.merge - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - No Operation, do nothing
n8n-nodes-base.noOp - Filter
n8n-nodes-base.filter - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Automatically generate and send course certificates when new participants are added to Google Sheets This workflow creates PDF certificates using Stencil, stores them in Google Drive, and emails them to participants. How it works 1. A new row is added to the…