Generate course certificates from Google Sheets with Stencil PDF and Outlook
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 Google Sheets document (via form, webhook, or manual entry) 2. The workflow generates a PDF certificate using the Stencil API 3. The PDF is uploaded to a Google Drive folder for archiving 4. The certificate is sent to the participant
At a glance
Generate course certificates from Google Sheets with Stencil PDF and Outlook is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Google Drive, Outlook. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, Google Drive, Outlook
- Modules
- 13
- Price
- Free
- Version
- v1.0

About this workflow
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 Google Sheets document (via form, webhook, or manual entry) 2. The workflow generates a PDF certificate using the Stencil API 3. The PDF is uploaded to a Google Drive folder for archiving 4. The certificate is sent to the participant via Outlook 5. The Google Sheet is updated with the file link and send timestamp Setup steps 1. Create a free account at stencilpdf.com and set up a certificate template 2. Connect your Google account and select the target Sheet and Drive folder 3. Connect your Outlook account for sending emails 4. Configure the Stencil API credentials (Bearer Auth) 5. Adjust the email template text as needed Prerequisites - Free Stencil account with certificate template - Google account (Sheets + Drive) - Outlook/Microsoft 365 account `
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Scrape AI news from multiple sources to Markdown & Google Drive with RSS.app
Save new Celestory messages to Google Sheets
Run an AI SDR sales pipeline with OpenAI, Google Sheets, Gmail and Calendar
Send personalized SaaS welcome emails with Stripe, Pinecone, GPT-4o, and Gmail
Export all messages from dialogs in Chatforma
Create a Slack alert and append your Google Sheets tracker when a Salesforge sequence contact unsubscribes
Track top meme coin prices with Telegram Bot and CoinGecko API
Run a multi-session chat agent with OpenAI and data table memory
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you