Loading video player...
In this video, I'm breaking down a full n8n automation project built around a real client problem ā a course creator who was doing everything manually: entering purchase data in Excel, writing welcome emails one by one, tracking 30-day deadlines, grading exams by hand, and generating certificates individually. I took that problem and built a 12-level automation that handles all of it automatically. You'll see me build the entire workflow live ā starting from a simple purchase-to-Google-Sheet trigger, then adding Gmail, Slack, wait nodes, exam delivery, AI-based grading with ChatGPT and Claude, and finally auto-generating personalised certificates using Canva and Google Docs. This breakdown will show you what real client-level n8n thinking looks like ā shifting your mindset from "I know n8n" to "I can actually solve a client's business problems end to end." š Resources & Useful Links - n8n (main automation tool): https://n8n.io - n8n Date Format Documentation: https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.datetime/ š Timestamps 00:00:00 ā Introduction & Full Workflow Demo Preview 00:03:47 ā Understanding the Client's Problem (12 Pain Points) 00:06:30 ā Mapping the 12-Level Automation Plan 00:08:13 ā Opening n8n and Creating the First Workflow 00:08:55 ā Level 1: Building the Purchase Data Form 00:09:37 ā Level 2: Saving Student Data to Google Sheets 00:15:08 ā Level 3: Organizing Data with the Set Node 00:18:00 ā Configuring Date Format and Timezone (Asia/Kolkata) 00:21:24 ā Level 4: Sending the Automated Welcome Email via Gmail 00:26:43 ā Level 5: Drafting HTML Emails Using Claude 00:33:35 ā Fixing Gmail Rendering and Beautifying the Email 00:38:35 ā Level 6: Setting Up Slack Admin Notifications 00:39:21 ā Level 7: Adding the 30-Day Wait Timer Node 00:43:49 ā Level 8: Sending the 25-Day Exam Reminder Email 00:56:47 ā Level 9: Building the Exam Paper with Google Forms 01:07:52 ā Sending the Final Exam Link Email to Students 01:11:00 ā Level 10: Capturing Responses and Validating Eligibility 01:27:46 ā Level 11: AI Marks Evaluator Agent (ChatGPT + Claude) 01:33:47 ā Writing the System Prompt for AI Grading Using Claude 01:45:49 ā Making AI Output Readable with a Code Node 02:07:04 ā Updating Pass/Fail Result on Google Sheets 02:13:41 ā Level 12: Auto-Generating Certificates with Canva + Google Docs 02:35:00 ā Duplicating and Dynamically Updating the Certificate Template 02:47:00 ā Downloading and Emailing the Certificate as a PDF 02:50:40 ā Full Summary: All 12 Levels and Problems Solved 02:54:22 ā Outro / What's Next in the n8n Series š What this video covers Here's what you'll learn in this video: - How to think through a client's problem and break it into automation levels - Capturing purchase data and saving it to Google Sheets via an n8n form - Sending automated welcome emails in HTML format using Gmail and Claude - Notifying your admin team on Slack when a new enrollment happens - Using n8n wait nodes to automate 30-day and 25-day timers - Building a Google Forms exam and delivering the link automatically by email - Validating student eligibility using an If node and a Code node - Setting up an AI agent to auto-grade subjective exam answers using ChatGPT - Generating personalised certificates dynamically with Canva, Google Docs, and Google Drive - Sending the certificate as a PDF attachment via Gmail - Using sub-workflows to keep complex builds clean and modular š Tools & Stack Mentioned Build & Automation: n8n AI Tools: Claude, ChatGPT (GPT-4o mini) Communication: Gmail, Slack Data: Google Sheets, Google Forms Files & Docs: Google Drive, Google Docs Design: Canva šÆ This is perfect for: - Freelancers who know n8n basics but struggle to build production-level client workflows - Course creators or EdTech brands who want to automate their entire student journey - n8n beginners who learn best by watching a real project get built from scratch - Developers and marketers who want to understand how to combine AI agents with workflow automation - Anyone trying to move from "doing tasks manually" to delivering scalable automated systems If you've been studying n8n but still don't know how to think through a client problem ā this is the video that changes that. The gap isn't your tool knowledge. It's your logic. Watch how the thinking develops in real time, level by level, and you'll start seeing client problems differently. š WHO AM I? I'm Vivek Mishra ā a performance marketing expert and trainer. I work with service-based and e-commerce brands and teach practical skills around marketing, AI tools, and digital systems. Everything I teach comes from doing it myself. š© Questions? Drop them in the comments ā I personally reply. šø Instagram: https://www.instagram.com/vivekmishraishere/ #n8n #WorkflowAutomation #AIAutomation #n8nTutorial #CourseAutomation