⚙ How It Works & Setup Steps: Automated Birthday Discount How It Works This workflow is a powerful yet simple automation to delight your customers on their birthdays. It runs every day on a schedule you define and automatically pulls data from your customer list on Google Sheets. The workflow then checks to see if any customer has a birthday on the current day. If a match is found, it generates a unique discount code and sends a personalized, celebratory email with the code directly to the customer. This ensures no birthday is ever missed, fostering customer loyalty and driving sales with zero manual effort. Setup Steps Follow these steps to get the workflow running in your n8n instance and start sending automated birthday discounts. 1. Prerequisites You will need a working n8n instance and a few key accounts: Google Sheets:* To store your customer data, including their email address and birthday. The birthday column should be formatted as *MM-dd** (e.g., 08-27). Gmail:** To send the personalized birthday emails to your customers. 2. Workflow Import Import the provided workflow JSON into your n8n canvas. All the necessary nodes will appear on your canvas, ready for configuration.
Tags
Gmail
Google SheetsRelated workflows
See all Gmail→
Manage attendee registrations and send emails
n8nConf Companion workflow for blog post
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