{"product_id":"google-sheets-trigger-send-pdf-certificates-via-gmail","title":"Google Sheets Trigger: Send PDF Certificates via Gmail","description":"\u003ch3\u003eAutomate PDF certificate delivery: Google Sheets → thirds.ai → Gmail\u003c\/h3\u003e\n\u003cp\u003eWhen a new learner is added to your Google Sheet, this n8n workflow automatically generates a personalized PDF certificate using \u003cstrong\u003ethirds.ai\u003c\/strong\u003e and sends it to the learner via \u003cstrong\u003eGmail\u003c\/strong\u003e—no HTML coding required.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGoogle Sheets trigger\u003c\/strong\u003e workflow streamlines certificate issuance end-to-end:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003e1) Triggers on new rows\u003c\/strong\u003e in your Google Sheets worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e2) Populates the certificate template\u003c\/strong\u003e by sending learner name, course, date, and issuer data to the \u003cstrong\u003ethirds.ai PDF API\u003c\/strong\u003e (using an \u003cem\u003eidempotency key\u003c\/em\u003e based on the sheet row number and email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e3) Waits and polls render status\u003c\/strong\u003e: if the job is queued or running, it waits 3 seconds and checks again until the render succeeds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e4) Downloads the finished PDF\u003c\/strong\u003e from the download URL returned by thirds.ai.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e5) Emails the certificate\u003c\/strong\u003e to the learner using \u003cstrong\u003eGmail\u003c\/strong\u003e, attaching the PDF with a formatted subject and message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e6) Fails safely\u003c\/strong\u003e: if thirds.ai returns a non-success status that isn’t queued\/running, the workflow stops with an error.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIssue certificates immediately when learners enroll or complete training—driven purely by new Google Sheets entries.\u003c\/li\u003e\n  \u003cli\u003eSend branded course completion PDFs to learners for SaaS training, workshops, or internal learning programs.\u003c\/li\u003e\n  \u003cli\u003eRun reliable certificate generation for ongoing cohorts without manual exports or copy\/paste emailing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets Trigger\u003c\/strong\u003e: starts the workflow when a new row is added.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request (thirds.ai)\u003c\/strong\u003e: calls the thirds.ai PDF API and polls render status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWait\u003c\/strong\u003e: pauses 3 seconds between status checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConditional logic\u003c\/strong\u003e (\u003cem\u003eif\u003c\/em\u003e): handles queued\/running vs success vs failure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends the PDF certificate as an attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStop and error\u003c\/strong\u003e: terminates on non-success states.\u003c\/li\u003e\n  \u003cli\u003eTemplate setup: use the \u003cstrong\u003ethirds.ai Portrait course certificate\u003c\/strong\u003e gallery template and paste the \u003cstrong\u003eTemplate ID\u003c\/strong\u003e (tpl_...) into the certificate PDF node.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248899444915,"sku":"N8N-21208","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qiO2eIZsCYcVw1_Ja9gMQ_R9cb4rRj.png?v=1792487328","url":"https:\/\/buyflowscripts.com\/products\/google-sheets-trigger-send-pdf-certificates-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}