n8n Workflow: Auto-Generate Certificate PDFs from Google Sheets

Auto-generate branded certificate PDFs from Google Sheets—and email them instantly

This n8n workflow monitors a Google Sheet for recipients marked ready, generates a personalized certificate in Canva using your Canva brand template (Data Autofill), exports it as a PDF, downloads it for sending, emails it via Gmail, and updates the row with SENT or ERROR status.

What this workflow does

• Triggers on updates when the ready column changes in the specified worksheet.
• Filters for readiness: it checks whether the updated row has ready = YES and ignores all other changes.
• Prepares certificate data by formatting configuration values and normalizing the date (using row fields like full_name and full_date).
• Creates the certificate in Canva using Canva Data Autofill to populate your brand template fields (e.g., course and instructor details).
• Exports and downloads a PDF from the generated Canva design so the file can be attached to the outgoing email.
• Sends the certificate by email using Gmail with recipient email and course details pulled from the sheet.
• Writes results back to Google Sheets: on success it marks the row DONE/SENT and saves the Canva design_url; on failure it sets ERROR with the failure message.

Use cases

• Automatic certificate delivery after webinar or course completion tracked in Google Sheets.
• Bulk issuance of branded PDFs without manual Canva exports.
• Operational visibility for SaaS teams via sheet-based status updates.

Technical details

• n8n nodes/logic: if, set, gmail, http request, google sheets, and supporting elements like sticky note.
• Community Canva node: @canva/n8n-nodes-canva.
• Prerequisite: Canva account access to Data Autofill and a brand template containing dataset fields (e.g., full_name, full_date, course_name, instructor_name).