{"product_id":"n8n-workflow-auto-generate-certificate-pdfs-from-google-sheets","title":"n8n Workflow: Auto-Generate Certificate PDFs from Google Sheets","description":"\u003ch3\u003eAuto-generate branded certificate PDFs from Google Sheets—and email them instantly\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors a Google Sheet for recipients marked \u003cstrong\u003eready\u003c\/strong\u003e, generates a personalized certificate in \u003cstrong\u003eCanva\u003c\/strong\u003e using your \u003cstrong\u003eCanva brand template\u003c\/strong\u003e (Data Autofill), exports it as a \u003cstrong\u003ePDF\u003c\/strong\u003e, downloads it for sending, emails it via \u003cstrong\u003eGmail\u003c\/strong\u003e, and updates the row with \u003cstrong\u003eSENT\u003c\/strong\u003e or \u003cstrong\u003eERROR\u003c\/strong\u003e status.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on updates\u003c\/strong\u003e when the \u003ccode\u003eready\u003c\/code\u003e column changes in the specified worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters for readiness\u003c\/strong\u003e: it checks whether the updated row has \u003ccode\u003eready = YES\u003c\/code\u003e and ignores all other changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares certificate data\u003c\/strong\u003e by formatting configuration values and normalizing the date (using row fields like \u003ccode\u003efull_name\u003c\/code\u003e and \u003ccode\u003efull_date\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates the certificate in Canva\u003c\/strong\u003e using \u003cstrong\u003eCanva Data Autofill\u003c\/strong\u003e to populate your brand template fields (e.g., course and instructor details).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExports and downloads a PDF\u003c\/strong\u003e from the generated Canva design so the file can be attached to the outgoing email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the certificate by email\u003c\/strong\u003e using \u003cstrong\u003eGmail\u003c\/strong\u003e with recipient email and course details pulled from the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets\u003c\/strong\u003e: on success it marks the row \u003ccode\u003eDONE\u003c\/code\u003e\/\u003ccode\u003eSENT\u003c\/code\u003e and saves the Canva \u003ccode\u003edesign_url\u003c\/code\u003e; on failure it sets \u003ccode\u003eERROR\u003c\/code\u003e with the failure message.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatic certificate delivery after webinar or course completion tracked in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBulk issuance of branded PDFs without manual Canva exports.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility for SaaS teams via sheet-based \u003ccode\u003estatus\u003c\/code\u003e updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, and supporting elements like \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCommunity Canva node: \u003ccode\u003e@canva\/n8n-nodes-canva\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003ePrerequisite: Canva account access to \u003cstrong\u003eData Autofill\u003c\/strong\u003e and a brand template containing dataset fields (e.g., \u003ccode\u003efull_name\u003c\/code\u003e, \u003ccode\u003efull_date\u003c\/code\u003e, \u003ccode\u003ecourse_name\u003c\/code\u003e, \u003ccode\u003einstructor_name\u003c\/code\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812009566387,"sku":"N8N-17967","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PLFFHhRO9XNTCsFh86d36_mQrh38Sq.png?v=1786352893","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-generate-certificate-pdfs-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}