Generate course certificates from Google Sheets with Stencil PDF and Outlook

Go to Workflow
6 views
Built by Leon Kirschner Leon Kirschner
Created on June 06, 2026

Description

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

A new row is added to the Google Sheets document (via form, webhook, or manual entry)
The workflow generates a PDF certificate using the Stencil API
The PDF is uploaded to a Google Drive folder for archiving
The certificate is sent to the participant via Outlook
The Google Sheet is updated with the file link and send timestamp

Setup steps

Create a free account at stencilpdf.com and set up a certificate template
Connect your Google account and select the target Sheet and Drive folder
Connect your Outlook account for sending emails
Configure the Stencil API credentials (Bearer Auth)
Adjust the email template text as needed

Prerequisites

Free Stencil account with certificate template
Google account (Sheets + Drive)
Outlook/Microsoft 365 account
`

Nodes Used (4)

Google Drive
n8n-nodes-base.googleDrive
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
Microsoft Outlook
n8n-nodes-base.microsoftOutlook