Automated template delivery system with Stripe, GPT-4o & Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (14)
- Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Stripe
n8n-nodes-base.stripe - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail
What it does
📊 Description Automate post-purchase workflows by instantly fetching successful Stripe payments, matching them to corresponding automation templates in Google Sheets, and sending customers personalized access emails using AI-generated content. This system ensures each buyer receives their digital template, password, and onboarding details automatically after payment. 💳📩🤖 What This Template Does - Step 1: Triggers daily at 7:00 AM IST to fetch all successful payment charges from Stripe. ⏰ - Step 2: Retrieves payment intent and product details for each successful charge to enrich context. 💰 - Step 3: Validates required fields (order reference, product name, customer name, email). ✅ - Step 4: Matches purchased product with the automation record in Google Sheets via AI lookup. 🔍 - Step 5: Combines Stripe and Sheet data into one record, ensuring accuracy and completeness. 🔄 - Step 6: Filters out already-processed customers to avoid duplicate sends. 🧮 - Step 7: Generates a personalized thank-you email using Azure OpenAI (GPT-4o-mini) including access links, password, and onboarding tips. 💌 - Step 8: Sends the email through Gmail to the customer automatically. 📧 - Step 9: Logs each transaction and email delivery into Google Sheets for tracking and auditing. 📊 Key Benefits ✅ Fully automated Stripe-to-email delivery flow ✅ Zero manual intervention — instant template delivery ✅ AI-personalized HTML emails with customer details ✅ Centralized purchase logging and analytics ✅ Eliminates duplicates and ensures smooth customer experience Features - Scheduled daily trigger (7:00 AM IST) - Stripe API integration for payment and product details - Google Sheets lookup for automation files and passwords - GPT-powered email content generation - Gmail API integration for delivery - Google Sheets logging for audit trail Requirements - Stripe API credentials - Google Sheets OAuth2 credentials - Gmail OAuth2 credentials - Azure OpenAI API credentials Target Audience - SaaS or digital product sellers using Stripe - Automation template marketplaces - Small teams delivering digital assets via email - Businesses seeking instant customer fulfillment