n8n AI Advocacy Email Workflow: OpenAI + Gmail + Sheets

Turn customer health signals into AI-crafted advocacy emails—automatically

This n8n workflow takes customer interaction/health data (via webhook or weekly schedule), scores advocacy potential in Python, uses OpenAI to generate a personalized outreach email, sends it through Gmail, logs activity to Google Sheets, and returns a JSON summary to the caller.

What this workflow does

• Ingests data via a POST webhook or runs every Monday at 8:00 to process incoming items.
• Normalizes customer fields (e.g., NPS, CSAT, tenure, spend, usage, and support signals) into a consistent customer schema.
• Scores advocacy potential and assigns an advocacy tier in Python, determining whether the customer qualifies as an advocacy candidate and selecting a recommended campaign type.
• Filters to qualified candidates, then briefly waits to respect rate limits.
• Generates a structured outreach campaign with OpenAI, including subject line, email body, tone, channel, incentive, and risk flags.
• Sends the email via Gmail and appends results to Google Sheets for tracking.
• Returns a JSON response containing submission ID, score/tier, campaign type, and status via the webhook response.

Use cases

• SaaS teams identifying high-potential advocates from NPS/CSAT and usage signals, then automatically triggering outreach.
• Customer success operations running a weekly advocacy campaign without manual segmentation or drafting.
• Automation engineers building an end-to-end pipeline: webhook → scoring → OpenAI email → Gmail send → Sheets log.

Technical details

• OpenAI (chat model) for structured, personalized email generation
• Gmail OAuth2 for sending from your connected mailbox
• Google Sheets logging via Sheets tracker append
• n8n nodes used: set, code, wait, gmail, filter, webhook

Built for professional n8n automation workflows that combine AI outreach with reliable delivery and audit-friendly tracking.