📱 Generate personalized promo cards with email verification, Gmail & Google Sheets

⚡ 51 views · 📱 Social Media & Email Marketing

Description

Personalized Promo Code Cards for Verified Users

Overview

This workflow automatically generates beautiful, personalized promotional cards with QR codes and sends them via email to verified users. Perfect for e-commerce stores, marketing campaigns, and customer engagement initiatives.

Key Features

Workflow Process

  1. Webhook Trigger: Receives user data (name, email, promo_code, discount_value, discount_type)
  2. Data Processing: Formats and validates incoming data with default values
  3. Email Verification: Checks email validity using Verifi Email API
  4. Validation Gateway: Routes valid emails to generation or invalid to error path
  5. Card Generation: Creates personalized promo card image using HTML/CSS to Image API
  6. Email Delivery: Sends beautifully designed email with promo card via Gmail
  7. Logging: Records successful distributions in Google Sheets
  8. Error Notification: Sends admin alerts for failed attempts

What’s Included

Beautiful Promo Card Design

Professional Email Template

Required Integrations & APIs

1. Verifi Email API

2. HTML/CSS to Image API

3. Gmail API (OAuth2)

4. Google Sheets API

Quick Start Guide

Step 1: Import the Workflow

  1. Copy the workflow JSON
  2. Go to n8n dashboard
  3. Click “Import from File” or “Import from URL”
  4. Paste the workflow

Step 2: Configure Credentials

Set up the following credentials in n8n:

Step 3: Create Google Sheet

  1. Create a new Google Sheet
  2. Add headers: Timestamp, Name, Email, Promo Code, Discount Value, Status
  3. Share with your service account (if using service account auth)
  4. Copy the Sheet ID and update in the workflow

Step 4: Customize Settings

Step 5: Test the Workflow

  1. Activate the workflow
  2. Copy the webhook URL
  3. Send a POST request with test data:
{
  "name": "John Doe",
  "email": "john@example.com",
  "promo_code": "SAVE20",
  "discount_value": "20%",
  "discount_type": "percentage"
}

Input Parameters

Send a POST request to the webhook with the following JSON body:

{
  "name": "Customer Name",           // Optional: defaults to "Valued Customer"
  "email": "customer@example.com",   // Required: customer email address
  "promo_code": "SUMMER25",          // Optional: defaults to "WELCOME10"
  "discount_value": "25%",           // Optional: defaults to "10%"
  "discount_type": "percentage"      // Optional: defaults to "percentage"
}

Use Cases

E-commerce

Marketing Campaigns

Customer Engagement

Customization Options

Promo Card Design

Email Template

Business Logic

Monitoring & Analytics

The workflow automatically logs:

Use this data to:

Troubleshooting

Common Issues

Email not sending:

Image not generating:

Email validation failing:

Google Sheets not updating:

Pro Tips

  1. Test with Invalid Emails: Try sending to invalid emails to verify error handling works
  2. Monitor API Limits: Keep track of API usage to avoid hitting rate limits
  3. A/B Test Designs: Create multiple card variations to see which performs better
  4. Personalize Further: Add more custom fields like user tier, purchase history, etc.
  5. Schedule Reports: Create a companion workflow to send daily/weekly promo distribution reports

Performance Metrics

Security & Privacy

Best Practices

  1. Email Deliverability: Always validate emails before sending
  2. Rate Limiting: Implement delays for bulk sends to avoid spam filters
  3. Personalization: Use customer names and relevant discount amounts
  4. Clear CTAs: Make it easy for customers to redeem their codes
  5. Tracking: Monitor distribution and redemption metrics
  6. Testing: Always test with real emails before launching campaigns

📄 License

This workflow template is provided as-is for use in your n8n instance. Feel free to customize and adapt to your specific needs.

Why Use This Workflow?

✅ Saves Time: Automates entire promo distribution process
✅ Reduces Errors: Email validation prevents bounce rates
✅ Professional Output: Beautiful, branded promo cards
✅ Easy Tracking: Real-time logging in Google Sheets
✅ Scalable: Handles high volume campaigns
✅ Customizable: Easy to adapt to your brand
✅ Cost-Effective: Uses affordable or free tier APIs

Perfect for marketers, e-commerce managers, and anyone looking to automate personalized promotional campaigns!

🔗 Nodes Used

Google Sheets, Webhook, Gmail

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup