{"product_id":"n8n-workflow-google-sheets-pdf-certificates-via-apify-gmail","title":"n8n Workflow: Google Sheets → PDF Certificates via Apify \u0026 Gmail","description":"\u003ch3\u003eAutomate personalized PDF certificates from Google Sheets—and email them automatically via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes participant data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates one personalized \u003cstrong\u003ePDF certificate per participant\u003c\/strong\u003e using \u003cstrong\u003eApify Bulk Certificate \u0026amp; Diploma PDF Generator\u003c\/strong\u003e, downloads each PDF, and sends it to the matching recipient via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e to start the certificate generation process.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads participant rows\u003c\/strong\u003e from a selected Google Sheets sheet and merges them with your certificate design and text settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates PDFs through Apify\u003c\/strong\u003e by sending prepared records to Apify’s \u003cstrong\u003eBulk Certificate \u0026amp; Diploma PDF Generator\u003c\/strong\u003e (one PDF per participant).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches certificates back to recipients\u003c\/strong\u003e using the generated \u003cem\u003ecertificate ID\u003c\/em\u003e mapped to each participant’s \u003cstrong\u003eemail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads each certificate PDF\u003c\/strong\u003e from the provided Apify URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an email via Gmail\u003c\/strong\u003e to each participant with their certificate attached.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTraining providers issuing certificates after workshops, bootcamps, or webinars.\u003c\/li\u003e\n  \u003cli\u003eSaaS operations teams generating certificates for users completing certifications or onboarding milestones.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable “Sheets → certificates → email delivery” process without manual PDF handling.\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\u003c\/strong\u003e (OAuth): select the spreadsheet and sheet to read participant data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify HTTP requests\u003c\/strong\u003e: create an n8n HTTP Header Auth credential named \u003cstrong\u003e“Apify API token”\u003c\/strong\u003e with header name \u003ccode\u003eAuthorization\u003c\/code\u003e and value \u003ccode\u003eBearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth): emails certificates with the recipient matching the \u003ccode\u003eemail\u003c\/code\u003e column.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e include \u003ccode\u003eHTTP Request\u003c\/code\u003e, \u003ccode\u003eGoogle Sheets\u003c\/code\u003e, \u003ccode\u003eGmail\u003c\/code\u003e, \u003ccode\u003eCode\u003c\/code\u003e, and helper elements (e.g., \u003ccode\u003eSticky Note\u003c\/code\u003e and \u003ccode\u003eSet\u003c\/code\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cp\u003eYour Google Sheet should include at least \u003cstrong\u003ename\u003c\/strong\u003e and \u003cstrong\u003eemail\u003c\/strong\u003e columns (optional fields like \u003cstrong\u003ecourse\u003c\/strong\u003e and \u003cstrong\u003edate\u003c\/strong\u003e can be referenced). Then customize certificate design\/text and the Gmail email subject\/sender name in the workflow’s \u003cstrong\u003eSettings\u003c\/strong\u003e step.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132928872627,"sku":"N8N-20144","price":68.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Cjfr2W2Uem5hAk4DqPrvp_eAATjzQb.png?v=1790760201","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-pdf-certificates-via-apify-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}