Generate bulk certificates from Google Sheets with BulkCertify
Needs changesWhat this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.bulkcertify.app over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Rows from Sheet (Google Sheets): uses Google Sheets
- Post to Batch API (HTTP Request): calls api.bulkcertify.app (POST)
- Wait: waits 15 seconds
- Fetch Batch Status (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- Retrieve Batch Results (HTTP Request): calls an HTTP API
- Split Recipients (Item Lists): reshapes item lists (legacy Item Lists node)
- Download ZIP File (HTTP Request): calls an HTTP API
- Filter: keeps only the items that match a condition
- Fetch Certificate PNG (HTTP Request): calls an HTTP API
Services it uses
HTTP calls to: api.bulkcertify.app
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Split Recipients: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Split Recipients | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Item Lists
n8n-nodes-base.itemLists - Filter
n8n-nodes-base.filter - Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow reads recipient names and emails from Google Sheets, submits them to the BulkCertify.app API to generate a certificate batch, polls until the batch is complete, then downloads the resulting ZIP archive and individual PNG…