Generate & email personalized certificates from Google Forms with score threshold
n8n8 modulesv1.0Description This workflow automatically generates personalized certificates in Google Slides and emails them to respondents only if they meet a minimum score threshold, using data submitted via Google Forms (stored in Google Sheets). Ideal for: Online courses Quizzes and workshops Event participation certificates Sheet Requirements Your connected Google Sheet (from the Google Form) must contain: Full Name – The name to appear on the certificate. Email – Recipient’s email address. Score –
At a glance
Generate & email personalized certificates from Google Forms with score threshold is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, Google Drive
- Modules
- 8
- Price
- Free
- Version
- v1.0
About this workflow
Description This workflow automatically generates personalized certificates in Google Slides and emails them to respondents only if they meet a minimum score threshold, using data submitted via Google Forms (stored in Google Sheets). Ideal for: Online courses Quizzes and workshops Event participation certificates Sheet Requirements Your connected Google Sheet (from the Google Form) must contain: Full Name – The name to appear on the certificate. Email – Recipient’s email address. Score – The test/quiz score used for threshold logic. Setup Instructions 1. Connect Google Sheets – Make sure your Form responses are linked to a Sheet with the columns mentioned above. 2. Set Score Threshold – Modify the If node to your desired minimum score (e.g., >= 80). 3. Customize Certificate Template – Use a Google Slides file with text placeholders like {{Full Name}}. 4. Connect Gmail & Google Drive – For sending emails and saving generated certificates. 5. Update File IDs – Replace any placeholder Slide and Drive file IDs with your own. Services Used Google Sheets (Form responses) Google Slides (Certificate template) Google Drive (Storage) Gmail (Email delivery) Troubleshooting Issue: "Cannot read property 'Score'" → Ensure your column names match exactly (Score, Full Name, etc.). Slides not replacing placeholders → Double-check placeholder format ({{Full Name}}) and capitalization. Emails not sending → Verify Gmail authentication and make sure the If node is correctly filtering results.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
⚡ Text → Viral Shorts | AI Video Studio in Telegram /w Setup Video
Send automated emails based on new rows in Google Sheets using ChatGPT for content generation
Create a post in Instagram for new Google sheets rows
Automate Google Ads copy optimization with Channable feed and Relevance AI
Generate chat completions with Perplexity AI, 2 ChatGPT prompts and update Google Sheets rows
Get insights from Facebook Ads and add/update Google Sheets rows automatically
Extract and analyze Google AI overviews with LLM for SEO recommendations
Generate Text-to-Speech Using Elevenlabs via API
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you