Generate Bulk Certificates from Google Sheets (n8n Workflow)

Generate Bulk Certificates from Google Sheets using n8n

This n8n workflow automatically reads recipient names and emails from Google Sheets, creates a certificate batch in BulkCertify.app, waits for it to finish, then downloads a ZIP of all certificates plus the individual PNG files—ready for sharing, archiving, or emailing.

What this workflow does

• Fetch recipients from Google Sheets: Starts manually, then pulls rows containing names and emails from your specified spreadsheet and sheet.
• Create a BulkCertify batch (HTTP POST): Sends a POST request to the BulkCertify.app API using your configured template details and the recipients list from the sheet.
• Poll until batch completion: Waits 15 seconds, then repeatedly checks batch statistics until the status is marked as completed.
• Collect results: Retrieves completed batch information, including a ZIP download link and per-recipient certificate URLs.
• Download and split certificates: Downloads the ZIP archive and splits the recipients array into individual items.
• Filter and download PNG files: Filters out recipients without a valid PNG URL and downloads each certificate PNG from its public link.

Use cases

• Automate certificates for training completions from a maintained recipient list in Google Sheets.
• Batch-generate certificates for cohorts, webinars, or certifications without manual uploads.
• Support SaaS operations by producing certificate outputs consistently from one spreadsheet-driven process.

Technical details

• Integrations: Google Sheets (OAuth) and BulkCertify.app API
• n8n nodes/tools used: if, wait, filter, item lists, sticky note, and HTTP Request
• Required configuration: Replace Bearer YOUR_API_KEY with your BulkCertify API key, ensure your sheet has recipients and emails columns, and align request body fields (e.g., template_id, title, signatory) to your BulkCertify template.