Send certificate PDFs from Google Forms with Google Sheets, Orshot, and Gmail
UnknownWhat this workflow does
This workflow has 4 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Gmail and Orshot (community).
How it runs
Trigger: On Google Sheets events (row added).
- Configure (Edit Fields (Set)): sets 6 fields: recipient_name, recipient_email, course_name…
- Render certificate PDF with Orshot (Orshot): https://api.orshot.com/v1/studio/render
- Email certificate with Gmail (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @thelifeofrishi/n8n-nodes-orshot is verified or supports 3.0 (used in Render certificate PDF with Orshot).
Nodes used (4)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Orshot
@thelifeofrishi/n8n-nodes-orshot.orshot - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow watches a Google Sheets response spreadsheet for new Google Forms submissions, renders a personalized certificate PDF with Orshot, and emails the certificate to the respondent via Gmail. How it works 1. Triggers when a new…