Run Synthetic Focus Groups: Claude + n8n + Google Sheets

Run Synthetic Focus Groups with Claude—Auto-score your marketing copy in n8n

This n8n workflow simulates weighted ICP-based focus groups using Anthropic Claude, calculates an explainable 0–100 appeal score, generates a launch recommendation, logs every run to Google Sheets, and emails the right team via SendGrid—all triggered by a webhook.

What this workflow does

• Receives campaign copy via a webhook POST (copy, channel, CTA, offer, brand voice, budget) plus a JSON list of ICP segments and their weights.
• Builds a normalized persona panel so the ICP weights sum to 1.
• Role-plays reactions with Claude for each persona, returning structured scores and a confidence rating that the copy is usable.
• Quality gate: if confidence is too low, it responds with an “input insufficient” message instead of scoring.
• Aggregates results into weighted metrics and computes a deterministic 0–100 composite appeal score with a readiness tier.
• Summarizes insights using Claude again: overall recommendation, risks, strengths, and suggested copy changes.
• Tracks and notifies: appends a summary row to Google Sheets, sends a SendGrid email to the growth or creative team, and returns the full report JSON to the webhook.

Use cases

• Validate new landing page or ad copy before launch using ICP segment weights.
• Compare multiple message variants and keep an auditable history in Google Sheets.
• Route recommendations to the correct team automatically (growth vs. creative) with SendGrid.

Technical details

• n8n trigger: Webhook POST with campaign details and ICP JSON segments.
• Logic & flow: if, set, code, wait, webhook, and sticky note.
• LLM: Anthropic Claude (Anthropic credentials used for both Claude chat steps).
• Data + delivery: Google Sheets (OAuth2) for result logging and SendGrid for team notifications.