{"product_id":"run-synthetic-focus-groups-claude-n8n-google-sheets","title":"Run Synthetic Focus Groups: Claude + n8n + Google Sheets","description":"\u003ch3\u003eRun Synthetic Focus Groups with Claude—Auto-score your marketing copy in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow simulates weighted ICP-based focus groups using \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e, calculates an \u003cstrong\u003eexplainable 0–100 appeal score\u003c\/strong\u003e, generates a \u003cstrong\u003elaunch recommendation\u003c\/strong\u003e, logs every run to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails the right team via \u003cstrong\u003eSendGrid\u003c\/strong\u003e—all triggered by a webhook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives campaign copy\u003c\/strong\u003e via a webhook POST (copy, channel, CTA, offer, brand voice, budget) plus a JSON list of ICP segments and their weights.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a normalized persona panel\u003c\/strong\u003e so the ICP weights sum to 1.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRole-plays reactions with Claude\u003c\/strong\u003e for each persona, returning structured scores and a \u003cstrong\u003econfidence rating\u003c\/strong\u003e that the copy is usable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQuality gate:\u003c\/strong\u003e if confidence is too low, it responds with an \u003cem\u003e“input insufficient”\u003c\/em\u003e message instead of scoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates results\u003c\/strong\u003e into weighted metrics and computes a deterministic \u003cstrong\u003e0–100 composite appeal score\u003c\/strong\u003e with a readiness tier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarizes insights\u003c\/strong\u003e using Claude again: overall recommendation, risks, strengths, and suggested copy changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks and notifies:\u003c\/strong\u003e appends a summary row to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, sends a \u003cstrong\u003eSendGrid\u003c\/strong\u003e email to the growth or creative team, and returns the full report JSON to the webhook.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eValidate new landing page or ad copy before launch using ICP segment weights.\u003c\/li\u003e\n  \u003cli\u003eCompare multiple message variants and keep an auditable history in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eRoute recommendations to the correct team automatically (growth vs. creative) with SendGrid.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger:\u003c\/strong\u003e Webhook POST with campaign details and ICP JSON segments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic \u0026amp; flow:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e, and \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM:\u003c\/strong\u003e \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e (Anthropic credentials used for both Claude chat steps).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData + delivery:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2) for result logging and \u003cstrong\u003eSendGrid\u003c\/strong\u003e for team notifications.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45732211556531,"sku":"N8N-17504","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/P4joxUKnlI0gnMe7kSRII_djrqXacO.png?v=1785143051","url":"https:\/\/buyflowscripts.com\/products\/run-synthetic-focus-groups-claude-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}