{"product_id":"generate-bulk-certificates-from-google-sheets-n8n-workflow","title":"Generate Bulk Certificates from Google Sheets (n8n Workflow)","description":"\u003ch3\u003eGenerate Bulk Certificates from Google Sheets using n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads recipient names and emails from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, creates a certificate batch in \u003cstrong\u003eBulkCertify.app\u003c\/strong\u003e, waits for it to finish, then downloads a ZIP of all certificates plus the individual PNG files—ready for sharing, archiving, or emailing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch recipients from Google Sheets:\u003c\/strong\u003e Starts manually, then pulls rows containing \u003cstrong\u003enames\u003c\/strong\u003e and \u003cstrong\u003eemails\u003c\/strong\u003e from your specified spreadsheet and sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreate a BulkCertify batch (HTTP POST):\u003c\/strong\u003e Sends a POST request to the \u003cstrong\u003eBulkCertify.app API\u003c\/strong\u003e using your configured template details and the recipients list from the sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePoll until batch completion:\u003c\/strong\u003e Waits \u003cstrong\u003e15 seconds\u003c\/strong\u003e, then repeatedly checks batch statistics until the status is marked as \u003cstrong\u003ecompleted\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollect results:\u003c\/strong\u003e Retrieves completed batch information, including a \u003cstrong\u003eZIP download link\u003c\/strong\u003e and per-recipient certificate URLs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownload and split certificates:\u003c\/strong\u003e Downloads the ZIP archive and splits the recipients array into individual items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter and download PNG files:\u003c\/strong\u003e Filters out recipients without a valid PNG URL and downloads each certificate PNG from its public link.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate certificates for training completions from a maintained recipient list in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBatch-generate certificates for cohorts, webinars, or certifications without manual uploads.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS operations by producing certificate outputs consistently from one spreadsheet-driven process.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth) and \u003cstrong\u003eBulkCertify.app API\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools used:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003eitem lists\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, and \u003cem\u003eHTTP Request\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired configuration:\u003c\/strong\u003e Replace \u003ccode\u003eBearer YOUR_API_KEY\u003c\/code\u003e with your BulkCertify API key, ensure your sheet has \u003ccode\u003erecipients\u003c\/code\u003e and \u003ccode\u003eemails\u003c\/code\u003e columns, and align request body fields (e.g., \u003ccode\u003etemplate_id\u003c\/code\u003e, title, signatory) to your BulkCertify template.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764318462131,"sku":"N8N-17861","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QcDeLxWXbsAeyaWxvkkBz_pjey7ko2.png?v=1786007163","url":"https:\/\/buyflowscripts.com\/products\/generate-bulk-certificates-from-google-sheets-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}