```
Available fonts: **Montserrat, Playfair Display, Great Vibes** (script), **Lora**. All values are HTML-escaped automatically.
### Automate it
Run it from **Make, Zapier, n8n** or the Apify API. For example, when a student finishes a course in your LMS, add a row and generate the certificate automatically. The `pdfUrl` in the output can be emailed directly.
### FAQ
**My Google Sheet link doesn't work.** Set sharing to *Anyone with the link can view*. You can also use *File β Share β Publish to web β CSV*.
**Can I use a different name column?** Yes, set **Name column** (e.g. `full_name`).
**Can each person get a different course or date?** Yes. Add a column and reference it with `{{column}}`.
**Is my data stored?** Only in your own Apify storage for this run, under your account's retention settings.
### n8n template
Send every person their certificate by email straight from a Google Sheet: import [this ready-made n8n workflow](https://github.com/Egrarobo/apify-actors/blob/main/n8n-templates/certificates-from-google-sheets.json) (Workflows β Import from file). It calls this Actor with an HTTP Request node, so no community node is needed.
# Actor input Schema
## `csvUrl` (type: `string`):
Link to a Google Sheet (sharing: 'Anyone with the link can view') or to a CSV file. The first row must contain column names, e.g. name, course, date.
## `csvText` (type: `string`):
Paste rows directly. First row = column names.
## `records` (type: `array`):
Array of objects, e.g. \[{"name": "Anna", "course": "Robotics"}]. Used before CSV if both are given.
## `datasetId` (type: `string`):
Use items from an existing Apify dataset (e.g. output of another Actor).
## `nameField` (type: `string`):
Column that holds the person's name. Rows where it is empty are skipped.
## `template` (type: `string`):
Design.
## `title` (type: `string`):
Supports {{column}} placeholders.
## `subtitle` (type: `string`):
Subtitle.
## `body` (type: `string`):
Use {{column}} to insert any column from your list, e.g. {{course}}, {{hours}}, {{grade}}.
## `date` (type: `string`):
Fixed text or {{date}} to take it from your list.
## `issuer` (type: `string`):
Organization.
## `logoUrl` (type: `string`):
Public link to a PNG/JPG/SVG logo.
## `accentColor` (type: `string`):
Hex color, e.g. #1f4e8c.
## `signature1Name` (type: `string`):
Signature 1 β name.
## `signature1Title` (type: `string`):
Signature 1 β role.
## `signature2Name` (type: `string`):
Signature 2 β name.
## `signature2Title` (type: `string`):
Signature 2 β role.
## `pageSize` (type: `string`):
Paper size.
## `orientation` (type: `string`):
Orientation.
## `addQrCode` (type: `boolean`):
Adds a QR code and certificate ID in the corner.
## `verifyUrlTemplate` (type: `string`):
Where the QR code points, e.g. https://yourschool.com/verify?id={{certificateId}}
## `certificateIdPrefix` (type: `string`):
IDs become PREFIX0001, PREFIX0002β¦ A 'certificateId' column in your list overrides this.
## `fileNameTemplate` (type: `string`):
Supports {{column}} placeholders.
## `outputZip` (type: `boolean`):
Create ZIP of all PDFs.
## `mergeIntoOnePdf` (type: `boolean`):
Also create one merged PDF (for printing).
## `maxDocuments` (type: `integer`):
Max documents.
## `customHtml` (type: `string`):
Your own page HTML with {{column}} placeholders. {{qrDataUrl}} gives the QR image. Wrap content in
β¦
.
## `customCss` (type: `string`):
Extra CSS. Fonts available: Montserrat, Playfair Display, Great Vibes, Lora.
## Actor input object example
```json
{
"csvText": "name,course,date\nMaria Popescu,Intro to Python,September 20 2026\nJohn Smith,Intro to Python,September 20 2026",
"nameField": "name",
"template": "certificate-classic",
"title": "Certificate",
"subtitle": "of completion",
"body": "This certificate is awarded for successfully completing {{course}}.",
"accentColor": "#1f4e8c",
"pageSize": "A4",
"orientation": "landscape",
"addQrCode": false,
"fileNameTemplate": "{{name}}",
"outputZip": true,
"mergeIntoOnePdf": false,
"maxDocuments": 1000
}
```
# Actor output Schema
## `results` (type: `string`):
All result items of this run.
## `summary` (type: `string`):
Summary of the run with counts and download links.
# API
You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.
## JavaScript example
```javascript
import { ApifyClient } from 'apify-client';
// Initialize the ApifyClient with your Apify API token
// Replace the '' with your token
const client = new ApifyClient({
token: '',
});
// Prepare Actor input
const input = {
"csvText": `name,course,date
Maria Popescu,Intro to Python,September 20 2026
John Smith,Intro to Python,September 20 2026`
};
// Run the Actor and wait for it to finish
const run = await client.actor("egra_van/bulk-certificate-pdf-generator").call(input);
// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`πΎ Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
console.dir(item);
});
// π Want to learn more π? Go to β https://docs.apify.com/api/client/js/docs
```
## Python example
```python
from apify_client import ApifyClient
# Initialize the ApifyClient with your Apify API token
# Replace '' with your token.
client = ApifyClient("")
# Prepare the Actor input
run_input = { "csvText": """name,course,date
Maria Popescu,Intro to Python,September 20 2026
John Smith,Intro to Python,September 20 2026""" }
# Run the Actor and wait for it to finish
run = client.actor("egra_van/bulk-certificate-pdf-generator").call(run_input=run_input)
# Fetch and print Actor results from the run's dataset (if there are any)
print(f"πΎ Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
print(item)
# π Want to learn more π? Go to β https://docs.apify.com/api/client/python/docs/quick-start
```
## CLI example
```bash
echo '{
"csvText": "name,course,date\\nMaria Popescu,Intro to Python,September 20 2026\\nJohn Smith,Intro to Python,September 20 2026"
}' |
apify call egra_van/bulk-certificate-pdf-generator --silent --output-dataset
```
## MCP server setup
```json
{
"mcpServers": {
"apify": {
"type": "http",
"url": "https://mcp.apify.com/?tools=fetch-actor-details,egra_van/bulk-certificate-pdf-generator"
}
}
}
```
The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer ` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).
## OpenAPI specification
Download the OpenAPI definition: https://api.apify.com/v2/actors/VMoTwh3GddX2SHsuf/builds/cVZlwMe1Ku1ImMR0c/openapi.json