{"product_id":"competitor-email-analysis-workflow-n8n-claude-to-google-sheets","title":"Competitor Email Analysis Workflow: n8n + Claude to Google Sheets","description":"\u003ch3\u003eTurn Competitor Newsletters into Actionable Responses—Automatically (n8n + Claude → Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls recent competitor newsletter emails from Gmail every day, analyzes each message with \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e, and appends structured competitor insights and response ideas into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—then marks emails as read and applies an “Analyzed” label so they aren’t processed twice.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a daily schedule\u003c\/strong\u003e (every day at \u003cstrong\u003e9:00 AM\u003c\/strong\u003e) to load your Gmail query, maximum email body length, and your brand context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks what’s already been analyzed\u003c\/strong\u003e by reading your Google Sheets log and collecting previously stored \u003cem\u003eMessage IDs\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches matching Gmail emails\u003c\/strong\u003e, skips any Message IDs already in the log, and cleans\/truncates the email body for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes each email with Claude\u003c\/strong\u003e to generate \u003cstrong\u003estructured competitor analysis\u003c\/strong\u003e and a \u003cstrong\u003econcrete response idea\u003c\/strong\u003e grounded in your brand context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses JSON output\u003c\/strong\u003e from Claude and formats \u003cstrong\u003eone row per successfully analyzed email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e, then \u003cstrong\u003emarks processed Gmail messages as read\u003c\/strong\u003e and applies an \u003cstrong\u003e“Analyzed”\u003c\/strong\u003e label.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators monitoring competitor messaging trends and positioning changes from newsletters.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable pipeline for \u003cstrong\u003ecompetitor email analysis\u003c\/strong\u003e and knowledge capture.\u003c\/li\u003e\n  \u003cli\u003eTeams who want a daily sheet of competitor insights plus ready-to-use response angles.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs daily at 9:00 AM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: fetches competitor newsletter emails, then marks them as read and applies an \u003cstrong\u003eAnalyzed\u003c\/strong\u003e label.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: logs Message IDs and appends Claude-derived analysis fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e: generates structured competitor analysis and response ideas (via JSON parsing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e used include: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, and supporting notes via \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e create Gmail labels (e.g., “Competitors” and “Analyzed”), set a filter for competitor newsletters, and configure credentials for Gmail, Google Sheets, and Claude in n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190244921523,"sku":"N8N-20616","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7TEVCrUA93N5Pzdz9PDGG_3h3KKrl6.png?v=1791451174","url":"https:\/\/buyflowscripts.com\/products\/competitor-email-analysis-workflow-n8n-claude-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}