Generate and email course certificates from Google Sheets with Canva and Gmail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
@canva/n8n-nodes-canva(Create certificate from brand template, Export certificate as PDF)
Nodes used (7)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - If
n8n-nodes-base.if - Canva
@canva/n8n-nodes-canva.canva - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set
What it does
Quick overview This workflow watches a Google Sheet for rows marked ready, generates a personalized certificate in Canva using a brand template, exports and downloads it as a PDF, then emails it to the recipient via Gmail and updates the sheet with the delivery status. How it works 1. Triggers when the ready column changes in the specified Google Sheets worksheet. 2. Checks whether the updated row has ready set to YES and ignores all other updates. 3. Formats configuration values (including normalizing the date) and uses Canva Data Autofill to create a certificate design from a Canva brand template. 4. Exports the generated Canva design as a PDF and downloads the file so it can be attached to an email. 5. Sends the PDF certificate to the recipient using Gmail, using the email address and course details from the sheet row. 6. Updates the Google Sheets row to DONE/SENT with the Canva design URL on success, or marks it as ERROR with the failure message if any step fails. Setup 1. Install and configure the community node @canva/n8n-nodes-canva, and ensure your Canva account is on Canva Enterprise with access to Data Autofill. 2. Create a Google Sheet with columns such as ready, certificateid, fullname, fulldate, coursename, instructorname, email, designurl, and status, and set the trigger to watch the correct spreadsheet and sheet. 3. Create a Canva brand template that contains dataset fields matching fullname, fulldate, coursename, and instructorname, then paste the template ID into the workflow configuration. 4. Add Google Sheets and Gmail credentials in n8n, and confirm the Gmail node’s sender account is allowed to email your recipients. 5. Ensure certificateid uniquely identifies each row so the workflow can update the correct record when writing back status and links. Requirements - Canva Enterprise account (Data Autofill is Enterprise-only) - The verified community node @canva/n8n-nodes-canva (officially provided by Canva) - Gmail credentials