January 22, 2026

Jotform to Google Drive, certificates sent via Gmail

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Certificate workflows break in the most annoying ways. A name gets misspelled, the email bounces, the PDF is saved in the wrong place, and someone ends up asking for a resend right when you’re setting up the room.

This is the kind of mess that hits workshop organizers first, but training teams and event marketers feel it too. With this Jotform certificate automation, you collect a signup once, verify it, generate a real PDF certificate, and send it out without chasing details.

Below you’ll see how the workflow runs, what it eliminates, and what you need to make it work reliably in your own setup.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: Jotform to Google Drive, certificates sent via Gmail

Click to explore

flowchart LR

    subgraph sg0["JotForm Flow"]
        direction LR
        n0@{ icon: "mdi:swap-horizontal", form: "rounded", label: "IF - Email Valid?", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Prepare Certificate Data"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Download PDF File"]
        n3@{ icon: "mdi:message-outline", form: "rounded", label: "Send Confirmation Email", pos: "b", h: 48 }
        n4@{ icon: "mdi:database", form: "rounded", label: "Log to Google Sheets", pos: "b", h: 48 }
        n5@{ icon: "mdi:database", form: "rounded", label: "Log Failed Registrations", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/jotform.dark.svg' width='40' height='40' /></div><br/>JotForm Trigger"]
        n7@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Verifi Email", pos: "b", h: 48 }
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge"]
        n9@{ icon: "mdi:location-exit", form: "rounded", label: "HTML to PDF", pos: "b", h: 48 }
        n10@{ icon: "mdi:cog", form: "rounded", label: "Upload file", pos: "b", h: 48 }
        n8 --> n0
        n9 --> n2
        n10 --> n4
        n7 --> n8
        n6 --> n7
        n6 --> n8
        n2 --> n10
        n0 --> n1
        n0 --> n5
        n4 --> n3
        n1 --> n9
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n6 trigger
    class n0,n7 decision
    class n4,n5 database
    class n2 api
    class n1 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n6,n8 customIcon

The Challenge: Certificates That Turn Into Cleanup Work

Issuing certificates sounds simple until you do it at scale. You export Jotform responses, clean up formatting, copy names into a template, generate PDFs, upload them, then email everyone individually (or try to mail-merge and hope nothing breaks). Meanwhile, fake registrations slip through with disposable emails, so you waste time generating certificates that will never be delivered. And if your files aren’t named consistently, resends turn into a treasure hunt inside Google Drive.

It’s not one big failure. It’s lots of small ones, stacked together.

You end up retyping attendee names, which is where typos and “please fix mine” replies come from.
Unverified emails create bounce-backs, spam flags, and extra follow-up you didn’t plan for.
PDF creation and Drive uploads drift into inconsistent folders and filenames as soon as more than one person helps.
Your tracking lives in three places, so you can’t confidently answer “who’s confirmed and who failed?”

The Fix: Verified Certificates Generated, Filed, and Sent Automatically

This workflow turns each Jotform submission into a clean, verified certificate delivery process. The moment someone registers, their email is checked for deliverability using VerifiEmail, so you don’t issue certificates to obvious spam or disposable addresses. If the email passes, the workflow assembles the attendee and event details, generates a QR-code-enabled certificate as a professional PDF via HTMLCSStoPDF, and then fetches the final PDF file. Next it uploads the document into a dedicated Google Drive folder using searchable, consistent filenames, logs the result in Google Sheets, and sends a polished Gmail confirmation email with an embedded preview and a direct download link. If the email fails validation, the workflow logs the registration separately so you can review or request a corrected address.

The flow starts with a Jotform trigger and an email verification check. Then it builds the certificate data, renders the PDF, uploads it to Drive, and records everything in Sheets. Finally, Gmail sends the confirmation email only after a successful log, which keeps your “sent” list honest.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Manually copying names and event details into a certificate template.
Generating PDFs one-by-one and downloading them locally first.
Uploading certificates to Google Drive and trying to keep naming consistent.
Sending confirmation emails before you’re sure the file exists and is logged.

Most teams get back about 2–4 hours per event once volume picks up.
Fewer bounced emails because verification happens before issuing anything.
Cleaner resends because the Drive file link is stored alongside the attendee record.
Faster check-in because each certificate includes a unique QR code.
One source of truth in Google Sheets for both successful and failed submissions.

Real-World Impact

Say you run a workshop with 120 registrations. Manually, even a “quick” process often takes about 5 minutes per person to format names, generate a PDF, upload it, and send an email, which is roughly 10 hours of busywork. With this workflow, the actual human time is closer to checking the setup once and letting it run; each submission executes in about 15–30 seconds automatically. You still get a full log, but you’re not stuck doing repetitive admin the night before the event.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Jotform for capturing registration submissions
Google Drive + Gmail + Google Sheets to store, send, and track certificates
VerifiEmail API key (get it from your VerifiEmail account dashboard)

Skill level: Intermediate. You’ll connect a few accounts, paste API keys, and adjust field mappings for your form.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

A Jotform submission comes in. The trigger fires as soon as someone registers, so you’re not waiting for exports or end-of-day batches.

Email deliverability is verified. VerifiEmail checks the address and returns a status (deliverable, risky, invalid, disposable). The workflow merges that result with the original form data so decisions are made with full context.

Valid registrations generate a certificate. An “If” check routes good emails into certificate assembly (a small code step that formats fields and builds a unique certificate ID), then HTMLCSStoPDF renders a polished A4 PDF that includes a QR code for check-in.

Files are stored and emails are sent. The PDF is retrieved, uploaded to Google Drive, and recorded in Google Sheets. After the row is written, Gmail sends the attendee a branded HTML email with a preview and the Drive link. Invalid registrations go to a separate Google Sheet so you can follow up without polluting your “sent” list.

You can easily modify the certificate template and email copy to match your branding based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the JotForm Trigger

Set up the workflow to start when a new JotForm submission arrives and establish the initial parallel paths.

Add and configure JotForm Submission Trigger with Form set to YOUR_JOTFORM_FORM_ID.
Credential Required: Connect your jotFormApi credentials in JotForm Submission Trigger.
Confirm the execution flow: JotForm Submission Trigger outputs to both Verify Email Deliverability and Combine Submission Data in parallel.

Step 2: Connect Google Sheets

Prepare your data storage for verified registrations and invalid email logs.

In Record to Google Sheets, set Operation to appendOrUpdate, and choose Document YOUR_GOOGLE_SHEETS_DOCUMENT_ID and Sheet gid=0.
Map columns to expressions like Date {{ $('Assemble Certificate Info').item.json.date }}, Email {{ $('Assemble Certificate Info').item.json.email }}, and PDF Link {{ $json.webViewLink }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Record to Google Sheets.
In Log Invalid Registrations, set Operation to append and reuse the same Document and Sheet.
Map invalid fields like Status to Invalid Email and Timestamp to {{ $now }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Log Invalid Registrations.

Step 3: Verify and Route Email Validation

Validate email deliverability and direct valid vs. invalid submissions.

Configure Verify Email Deliverability with Email set to {{ $json.Email }}.
Credential Required: Connect your verifiEmailApi credentials in Verify Email Deliverability.
Use Combine Submission Data with Mode set to combine and Combine By set to combineByPosition to merge the submission and verification results.
In Validate Email Status, configure the condition Boolean where Value 1 is {{ $json.valid }} and Value 2 is {{ true }}.
Confirm routing: the true path goes to Assemble Certificate Info, and the false path goes to Log Invalid Registrations.

Step 4: Set Up Certificate Data & PDF Rendering

Transform submission data into certificate-ready fields and generate the PDF.

In Assemble Certificate Info, keep the provided JavaScript to build name, date, qrCodeUrl, and certificateId.
Verify that the verification URL uses https://your-domain.com/verify?email=... and update the domain if needed.
In Render Certificate PDF, set HTML Content to the provided template beginning with <div style="font-family: 'Georgia', serif; text-align: center; ...">.
Credential Required: Connect your htmlcsstopdfApi credentials in Render Certificate PDF.
Ensure the flow continues from Render Certificate PDF to Retrieve PDF Document.

Step 5: Upload Certificate & Store Records

Fetch the rendered PDF, upload it to Drive, and log the record in Sheets.

In Retrieve PDF Document, set URL to {{ $json.pdf_url }} and confirm the response is set to file output with Output Property Name pdfData.
In Upload PDF to Drive, set Name to Confirmed_Attendee_{{ $('Assemble Certificate Info').item.json.name }}_{{ $('Assemble Certificate Info').item.json.date }}.pdf.
Set Folder to YOUR_GOOGLE_DRIVE_FOLDER_ID and Input Data Field Name to pdfData.
Credential Required: Connect your googleDriveOAuth2Api credentials in Upload PDF to Drive.
Confirm the flow continues from Upload PDF to Drive to Record to Google Sheets.

Step 6: Send the Confirmation Email

Deliver a branded confirmation message with certificate details and the PDF link.

In Dispatch Confirmation Email, set Send To to {{ $('Assemble Certificate Info').item.json.email }}.
Set Subject to 🎉 Your Workshop Seat is Confirmed - {{ $('Assemble Certificate Info').item.json.event }}.
Use the provided HTML in Message to include QR code, certificate ID, and PDF link placeholders.
Credential Required: Connect your gmailOAuth2 credentials in Dispatch Confirmation Email.

If you customize the email HTML, preserve the dynamic placeholders like {{ $json['PDF Link'] }} and {{ $json['Certificate ID'] }} to avoid broken links.

Step 7: Test & Activate Your Workflow

Run a live submission to verify the parallel flow, PDF creation, Drive upload, Sheets logging, and email delivery.

Click Execute Workflow and submit a test entry through your JotForm.
Confirm that JotForm Submission Trigger runs and that Verify Email Deliverability and Combine Submission Data execute in parallel.
For valid emails, verify Render Certificate PDF → Retrieve PDF Document → Upload PDF to Drive completes, and that a record appears in Record to Google Sheets.
For invalid emails, verify Log Invalid Registrations receives the entry from Validate Email Status.
Confirm the recipient receives the message from Dispatch Confirmation Email with a working PDF link.
Toggle the workflow to Active to start processing real submissions.

⚠️ Common Pitfall: If the PDF is not attaching or the Drive link is missing, re-check that Retrieve PDF Document outputs to pdfData and that Upload PDF to Drive uses pdfData as the input.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

Google (Gmail/Drive/Sheets) credentials can expire or lose permissions after security changes. If things break, check the n8n Credentials screen and the Google OAuth consent permissions first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Common Questions

How quickly can I implement this Jotform certificate automation?

About 20 minutes if your accounts and API keys are ready.

Can non-technical teams implement this certificate automation?

Yes. You won’t write an app or deploy code, but you will map Jotform fields to the certificate template and connect Google credentials.

Is n8n free to use for this Jotform certificate automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in VerifiEmail and HTMLCSStoPDF usage fees, plus any OpenAI usage if you keep the AI Agent enabled.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this Jotform certificate automation solution to my specific challenges?

Start by changing the field mapping in “Combine Submission Data” and the formatting rules in “Assemble Certificate Info” so names, course titles, and dates match your form. If you want different certificate branding, update the HTML that feeds “Render Certificate PDF.” Common tweaks include using a different Drive folder per event, adding extra columns to the Google Sheets log (like ticket type), and changing the Gmail email body to match your tone.

Why is my Google Drive connection failing in this workflow?

Usually it’s an expired Google OAuth connection or missing Drive permissions. Reconnect the Google credential in n8n, then confirm the workflow is uploading into a folder your account can actually access. If it fails only sometimes, check Drive API quota and make sure the filename doesn’t include characters Drive rejects (slashes and a few symbols can do it). Also confirm the “Retrieve PDF Document” step really returned a file before the upload runs.

What’s the capacity of this Jotform certificate automation solution?

For most events, it scales fine out of the box. Each registration runs as its own execution and typically finishes in under a minute, so hundreds of signups in a day is normal. On n8n Cloud, your plan’s monthly execution limit is the main ceiling; on self-hosting, capacity depends on your server and the external services’ rate limits. If you expect big spikes (like ticket drops), throttle PDF rendering and keep an eye on VerifiEmail and Google API limits.

Is this Jotform certificate automation better than using Zapier or Make?

Often, yes, especially when you care about branching logic and end-to-end control. This workflow uses conditional routing (valid vs. invalid emails), merges data sources, generates a PDF, then logs and emails in a strict order. n8n is strong at that kind of “real process” automation, and self-hosting means you’re not paying more as volume climbs. Zapier or Make can still work if you want a quick, lightweight setup and you’re fine with fewer safeguards. If you’re on the fence, Talk to an automation expert and we’ll sanity-check your use case.

Once this is running, certificate delivery stops being a recurring project. You get clean records, verified recipients, and a Drive folder that finally makes sense.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "5e76cd89aab89429225a79b743ddaf7544f1bf8af0405bb76082020770d43b5d",
"templateCredsSetupCompleted": null,
"templateId": ""
},
"name": "Automated Certificate Issuance Flow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-10397",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1055,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "5e7bec79-8951-4388-890c-73e37a6ef8b2",
"name": "Validate Email Status",
"type": "n8n-nodes-base.if",
"position": [
275,
305
],
"parameters": {
"conditions": {
"boolean": [
{
"value1": "={{ $json.valid }}",
"value2": "={{ true }}"
}
]
}
},
"typeVersion": 1
},
{
"id": "1e9a2800-bab2-47f2-8fff-5f52f0d3e903",
"name": "Assemble Certificate Info",
"type": "n8n-nodes-base.code",
"position": [
160,
120
],
"parameters": {
"jsCode": "// Get current item (merged data)\nconst data = $input.first().json;\n\n// Build full name\nconst fullName = `${data[\"Full Name\"].first} ${data[\"Full Name\"].last}`.trim();\n\n// Format date\nconst dateObj = data[\"Select Workshop Date\"];\nconst displayDate = new Date(`${dateObj.year}-${dateObj.month}-${dateObj.day}`).toLocaleDateString('en-US', {\n  year: 'numeric',\n  month: 'long',\n  day: 'numeric'\n});\n\n// QR Code URL\nconst verificationUrl = `https://your-domain.com/verify?email=${encodeURIComponent(data.Email)}&event=${encodeURIComponent(data[\"Select Workshop\"])}`;\n\n// Unique Certificate ID\nconst certificateId = `CERT-${Date.now().toString(36).toUpperCase()}-${Math.random().toString(36).substr(2, 5).toUpperCase()}`;\n\n// Return clean data for HTML\nreturn [\n  {\n    json: {\n      name: fullName,\n      email: data.Email,\n      event: data[\"Select Workshop\"],\n      date: displayDate,\n      qrCodeUrl: `https://api.qrserver.com/v1/create-qr-code/?data=${encodeURIComponent(verificationUrl)}&size=200x200&margin=10`,\n      verificationUrl: verificationUrl,\n      certificateId: certificateId,\n      verifiedAt: new Date().toISOString(),\n      emailProvider: data.details?.mx?.provider || \"Unknown\",\n      isValid: data.valid\n    }\n  }\n];"
},
"typeVersion": 2
},
{
"id": "ff60e9dc-464e-4b54-8bbd-1e90874436d5",
"name": "Retrieve PDF Document",
"type": "n8n-nodes-base.httpRequest",
"position": [
145,
450
],
"parameters": {
"url": "={{ $json.pdf_url }}",
"options": {
"response": {
"response": {
"responseFormat": "file",
"outputPropertyName": "pdfData"
}
}
}
},
"typeVersion": 4.2
},
{
"id": "f8ec0f94-b7c6-43c8-8598-7cb5e324b523",
"name": "Dispatch Confirmation Email",
"type": "n8n-nodes-base.gmail",
"position": [
795,
500
],
"webhookId": "",
"parameters": {
"sendTo": "={{ $('Assemble Certificate Info').item.json.email }}",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n  <meta charset=\"utf-8\">\n  <style>\n    body { font-family: 'Segoe UI', Tahoma, sans-serif; background: #f4f4f9; color: #333; padding: 20px; }\n    .container { max-width: 600px; margin: auto; background: white; border-radius: 12px; overflow: hidden; box-shadow: 0 4px 12px rgba(0,0,0,0.1); }\n    .header { background: #1a5fb4; color: white; padding: 30px; text-align: center; }\n    .header h1 { margin: 0; font-size: 24px; }\n    .body { padding: 30px; line-height: 1.6; }\n    .highlight { background: #e3f2fd; padding: 15px; border-radius: 8px; margin: 20px 0; font-weight: bold; }\n    .qr { text-align: center; margin: 25px 0; }\n    .qr img { width: 140px; height: 140px; border: 1px solid #ddd; padding: 8px; border-radius: 8px; }\n    .footer { background: #f0f0f0; padding: 20px; text-align: center; font-size: 12px; color: #777; }\n    .btn { display: inline-block; background: #1a5fb4; color: white; padding: 12px 24px; text-decoration: none; border-radius: 6px; margin-top: 15px; font-weight: bold; }\n  </style>\n<link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/106731.webp"><link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/106731.webp"></head>
\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1>Workshop Confirmation</h1>\n    </div>\n    <div class=\"body\">\n      <p>Hi <strong>{{ $json['Full Name'] }}</strong>,</p>\n      <p>Congratulations! Your registration for:</p>\n      <div class=\"highlight\">\n        <strong>{{ $json.Workshop }}</strong><br>\n        {{ $json.Date }}\n      </div>\n      <p>has been <strong>verified and confirmed</strong>.</p>\n\n      <div class=\"qr\">\n        <img src=\"{{ $json['QR Code URL'] }}\" alt=\"QR Code\">\n        <p><em>Scan on event day for instant check-in</em></p>\n      </div>\n\n      <p><strong>Certificate ID:</strong> <code>{{ $json['Certificate ID'] }}</code></p>\n      <p><strong>Verified Email:</strong> {{ $json.Email }}</p>\n\n      <p>Your official <strong>pre-issued certificate is attached</strong> as a PDF.</p>\n\n      <a href=\"{{ $json['PDF Link'] }}\" class=\"btn\" target=\"_blank\">\n        View Certificate Online\n      </a>\n    </div>\n    <div class=\"footer\">\n      Issued on {{ new Date().toLocaleDateString() }} \u2022 Powered by <strong>n8n Automation</strong>\n    </div>\n  </div>\n</body>\n</html>",
"options": [],
"subject": "=\ud83c\udf89 Your Workshop Seat is Confirmed - {{ $('Assemble Certificate Info').item.json.event }}"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "96b09356-225b-41dd-8684-b003df5b7f1c",
"name": "Record to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
530,
440
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Assemble Certificate Info').item.json.date }}",
"Email": "={{ $('Assemble Certificate Info').item.json.email }}",
"PDF Link": "={{ $json.webViewLink }}",
"Workshop": "={{ $('Assemble Certificate Info').item.json.event }}",
"Full Name": "={{ $('Assemble Certificate Info').item.json.name }}",
"Timestamp": "={{ new Date().toISOString() }}",
"QR Code URL": "={{ $('Assemble Certificate Info').item.json.qrCodeUrl }}",
"Verified At": "={{ $json.createdTime }}",
"Certificate ID": "={{ $('Assemble Certificate Info').item.json.certificateId }}"
},
"schema": [
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Workshop",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Workshop",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Certificate ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Certificate ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "QR Code URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "QR Code URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PDF Link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PDF Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Verified At",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Verified At",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk",
"cachedResultName": "Workshop Registrations & Certificates"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "4c34e01e-c47f-4879-a79b-f358b4e774e6",
"name": "Log Invalid Registrations",
"type": "n8n-nodes-base.googleSheets",
"position": [
290,
520
],
"parameters": {
"columns": {
"value": {
"Date": "={{ new Date(\n  $json[\"Select Workshop Date\"].year + '-' +\n  String($json[\"Select Workshop Date\"].month).padStart(2, '0') + '-' +\n  String($json[\"Select Workshop Date\"].day).padStart(2, '0')\n).toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' }) }}",
"Email": "={{ $json.Email }}",
"Status": "Invalid Email",
"PDF Link": "Invalid Email",
"Workshop": "={{ $json[\"Select Workshop\"] }}",
"Full Name": "={{ $json['Full Name'].first + ' ' + $json['Full Name'].last }}",
"Timestamp": "={{ $now }}",
"QR Code URL": "Invalid Email",
"Verified At": "Invalid Email",
"Certificate ID": "Invalid Email"
},
"schema": [
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Workshop",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Workshop",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Certificate ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Certificate ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "QR Code URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "QR Code URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PDF Link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PDF Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Verified At",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Verified At",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk",
"cachedResultName": "Workshop Registrations & Certificates"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.4
},
{
"id": "0d26d3cd-509b-4f95-b188-00d41bb17e3c",
"name": "JotForm Submission Trigger",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
955,
135
],
"webhookId": "",
"parameters": {
"form": "YOUR_JOTFORM_FORM_ID"
},
"credentials": {
"jotFormApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "de18b560-5a30-4b26-998f-a701590b4e9d",
"name": "Verify Email Deliverability",
"type": "n8n-nodes-verifiemail.verifiEmail",
"position": [
680,
270
],
"parameters": {
"email": "={{ $json.Email }}"
},
"credentials": {
"verifiEmailApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "1eb2b648-b557-42f1-aed5-d6b3f5b6419e",
"name": "Combine Submission Data",
"type": "n8n-nodes-base.merge",
"position": [
525,
120
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineByPosition"
},
"typeVersion": 3.2
},
{
"id": "5b63e21f-3504-4081-8422-800bda3803b5",
"name": "Render Certificate PDF",
"type": "n8n-nodes-htmlcsstopdf.htmlcsstopdf",
"position": [
0,
295
],
"parameters": {
"html_content": "=<div style=\"font-family: 'Georgia', serif; text-align: center; padding: 40px; border: 8px double #1a5fb4; background: #f9f9fb; max-width: 600px; margin: auto; color: #1a1a1a;\">\n  <h1 style=\"color: #1a5fb4; margin-bottom: 10px;\">Certificate of Confirmation</h1>\n  <p style=\"font-size: 18px; color: #555;\">This certifies that</p>\n  \n  <h2 style=\"font-size: 28px; margin: 15px 0; color: #1a5fb4;\">{{ $json.name }}</h2>\n  \n  <p style=\"font-size: 18px; color: #555;\">has successfully registered for</p>\n  <h3 style=\"font-size: 22px; color: #000;\">{{ $json.event }}</h3>\n  \n  <p style=\"font-size: 16px; margin: 10px 0;\"><strong>Date:</strong> {{ $json.date }}</p>\n  \n  <div style=\"margin: 30px 0;\">\n    <img src=\"{{ $json.qrCodeUrl }}\" alt=\"QR Code\" style=\"width: 150px; height: 150px;\" />\n  </div>\n  \n  <p style=\"font-size: 14px; color: #666;\">\n    <strong>Certificate ID:</strong> {{ $json.certificateId }}<br>\n    <strong>Verified Email:</strong> {{ $json.email }} ({{ $json.emailProvider }})<br>\n    <em>Scan QR code on event day for instant check-in</em>\n  </p>\n  \n  <hr style=\"border: 1px dashed #ccc; margin: 30px 0;\">\n  <p style=\"font-size: 12px; color: #999;\">\n    Issued: {{ new Date().toLocaleDateString() }} \u2022 Powered by n8n Automation\n  </p>\n</div>"
},
"credentials": {
"htmlcsstopdfApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "d7504f9f-ee7e-41b0-8ec3-28acf6b139be",
"name": "Upload PDF to Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
390,
505
],
"parameters": {
"name": "=Confirmed_Attendee_{{ $('Assemble Certificate Info').item.json.name }}_{{ $('Assemble Certificate Info').item.json.date }}.pdf",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive",
"cachedResultUrl": "https://drive.google.com/drive/my-drive",
"cachedResultName": "My Drive"
},
"options": [],
"folderId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_DRIVE_FOLDER_ID",
"cachedResultUrl": "https://drive.google.com/drive/folders/YOUR_GOOGLE_DRIVE_FOLDER_ID",
"cachedResultName": "Attendee Data"
},
"inputDataFieldName": "pdfData"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Combine Submission Data": {
"main": [
[
{
"node": "Validate Email Status",
"type": "main",
"index": 0
}
]
]
},
"Render Certificate PDF": {
"main": [
[
{
"node": "Retrieve PDF Document",
"type": "main",
"index": 0
}
]
]
},
"Upload PDF to Drive": {
"main": [
[
{
"node": "Record to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Verify Email Deliverability": {
"main": [
[
{
"node": "Combine Submission Data",
"type": "main",
"index": 1
}
]
]
},
"JotForm Submission Trigger": {
"main": [
[
{
"node": "Verify Email Deliverability",
"type": "main",
"index": 0
},
{
"node": "Combine Submission Data",
"type": "main",
"index": 0
}
]
]
},
"Retrieve PDF Document": {
"main": [
[
{
"node": "Upload PDF to Drive",
"type": "main",
"index": 0
}
]
]
},
"Validate Email Status": {
"main": [
[
{
"node": "Assemble Certificate Info",
"type": "main",
"index": 0
}
],
[
{
"node": "Log Invalid Registrations",
"type": "main",
"index": 0
}
]
]
},
"Record to Google Sheets": {
"main": [
[
{
"node": "Dispatch Confirmation Email",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Confirmation Email": {
"main": [
[]
]
},
"Assemble Certificate Info": {
"main": [
[
{
"node": "Render Certificate PDF",
"type": "main",
"index": 0
}
]
]
}
}
}