🎁 Verified Referral Reward Notification Workflow Overview Transform your referral program into a fully automated, fraud-resistant system that delivers professional rewards to verified referrers. This workflow combines email validation, dynamic coupon generation with visual design, automated email delivery, and comprehensive tracking—all without manual intervention. What This Workflow Does 1. Receives Referral Submissions Accepts form submissions via webhook (compatible with Jotform, Typeform, Google Forms, or any webhook-enabled form) Captures referrer details, email, referred friend, and campaign information 2. Validates Email Addresses Prevents fraud and abuse by verifying email authenticity using VerifiEmail API Checks for disposable emails, invalid formats, and non-existent addresses Ensures high deliverability rates for reward emails 3. Generates Personalized Coupon Cards Creates unique coupon codes with smart formatting (e.g., REF-JOHN1234) Designs beautiful HTML/CSS coupon cards with gradient backgrounds and professional styling Converts HTML to high-quality PNG images using HTMLCSStoImage API 4.
Tags
Gmail
Google SheetsRelated workflows
See all Gmail→WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
WRoute real estate buyer and seller leads with Claude and Google Sheets
Quick Overview This workflow hosts an n8n lead-capture form, uses Anthropic Claude to score and classify real estate inquiries, then routes ready leads to Gmail and Google Sheets while logging early-stage leads to a separate Google Sheets tab. How it works Receives a new submission from an n8n Form trigger with contact details, intent, area, budget, timeline, financing status, and notes. Normalizes the submitted fields (for example trimming strings, lowercasing email, and adding a timestamp) for consistent downstream processing. Sends the normalized lead details to the Anthropic Messages API (Claude) to return a strict JSON classification, summary, timeline band, financing readiness, recommended agent role, and score. Parses the Claude JSON response, clamps the score to a 1–10 range, and calculates whether the lead is “ready” (score 7). If the lead is ready, sends a formatted Gmail alert to the agent and appends the lead to the “Active Leads” tab in Google Sheets. If the lead is not ready, appends the lead to the “Nurture Leads” tab in Google Sheets. Returns a confirmation message to the form submitter after the lead is routed. Setup Create an Anthropic HTTP Header Auth credential
Send weekly overdue invoice reminders with Google Sheets and Gmail
Quick Overview This workflow runs every Monday at 08:00, reads invoices from Google Sheets, filters for unpaid invoices with no prior follow-up and more than 7 days overdue, sends an HTML reminder email via Gmail, and updates the sheet to mark the invoice as followed up. How it works Runs every Monday at 08:00 on a schedule. Reads all invoice rows from a Google Sheets spreadsheet. Keeps only invoices where the status is “Impayé” and the “Date de relance” field is empty, then calculates the number of days overdue from the invoice date. Filters to invoices that are more than 7 days overdue. Sends a formatted HTML payment reminder email via Gmail with the invoice date, amount, and days overdue. Updates the matching Google Sheets row to set the status to “Relancé” and writes today’s follow-up date. Setup Add Google Sheets credentials and ensure the target spreadsheet contains columns like Statut, Date de relance, Date_Facture, Client, and Montant. Add Gmail credentials for the mailbox that sends reminders. Update the Google Sheets document URL/sheet selection and set the recipient address in the Gmail “sendTo” field (and optionally adapt the subject/body text).