AutomationMart
Home/Browse/Generate course certificates from Google Sheets with Stencil PDF and Outlook
n8n

Generate course certificates from Google Sheets with Stencil PDF and Outlook

n8nn8n13 modulesv1.0
Google SheetsGoogle DriveOutlook

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
Generate course certificates from Google Sheets with Stencil PDF and Outlook workflow diagram

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 `

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

AI News Scraping System This n8n workflow automates the process of pulling in breaking AI-related headlines from curated RSS feeds, scraping their full content, and saving readable Markdown versions directly to Google Drive. Use cases include: - Creating a personal newsletter curation system - Automating blog post research workflows - Archiving news content for later summarization or AI use --- How it Works 1. Scheduled Triggers The workflow runs every 3–4 hours using multiple Schedule Trigger

Free

Save new Celestory messages to Google Sheets

Every time a new Celestory message is sent, Make will automatically add its content to Google Sheets.

Free

Run an AI SDR sales pipeline with OpenAI, Google Sheets, Gmail and Calendar

This n8n template is a complete, automated sales operating system. It acts as an AI-powered sales development representative (SDR) that moves leads into a CRM, sends highly personalized follow-up sequences, tracks calendar bookings, and automatically handles meeting no-shows. Instead of manually tracking who needs to be emailed next or cross-referencing your calendar with your spreadsheet, this workflow handles the entire outreach lifecycle in the background. How it works This template is divide

Free

Send personalized SaaS welcome emails with Stripe, Pinecone, GPT-4o, and Gmail

Who it's for SaaS founders and developers who want to automate their customer onboarding experience from payment to welcome email, without any manual work. How it works - A Stripe Trigger listens for successful payment events. - The payment amount is converted and used to identify the subscription tier. - Customer details are extracted from the Stripe payload. - The AI Agent queries Pinecone to retrieve the correct plan details and generates a personalised HTML welcome email with the renewal dat

Free

Export all messages from dialogs in Chatforma

Export all messages from all dialogs from Chatforma to the specified Google Sheets spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1mQAdPmQqTNvL8Qp97ZmVm0wbeI17PR0vcU7l33lUtbM/edit?usp=sharing).

Free

Create a Slack alert and append your Google Sheets tracker when a Salesforge sequence contact unsubscribes

This workflow updates a Google sheet and sends a Slack notification to inform your team of contacts that have unsubscribed from your sequence.

Free

Track top meme coin prices with Telegram Bot and CoinGecko API

Platform: n8n (Telegram Bot Integration) Purpose: Let users fetch top meme coin prices in real-time using a simple /memecoin Telegram command How It Works (Logic Breakdown) This flow listens for a Telegram command and fetches data from the CoinGecko API to respond with live memecoin prices. 🔹 1. Telegram Trigger Node Listens for incoming Telegram messages from users. Activated when a message is sent in a Telegram chat connected to the bot. Passes the raw message (e.g., /memecoin) to the next n

Free

Run a multi-session chat agent with OpenAI and data table memory

Quick overview This workflow powers an OpenAI-based chat agent in n8n that persists long-term conversation memory in an n8n Data Table by session ID, optionally recalling past context via name/email lookups while enforcing an identity-verification flow. How it works 1. Receives a chat message via the n8n Chat Trigger and uses the provided sessionId to identify the conversation. 2. Searches the n8n Data Table for an existing row with the same sessionid and either loads the saved fields or

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free