Analyze competitor marketing emails with Claude and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets, Gmail and Anthropic.
How it runs
Trigger: On a schedule (every day at 09:00).
- Set Analysis Settings (Edit Fields (Set)): sets 3 fields: gmailQuery, maxBodyChars, brandContext
- Get Logged Message IDs (Google Sheets): read
- Collect Logged IDs (Code): runs custom JavaScript code
- Get Competitor Emails (Gmail): get many (message)
- Filter and Prepare New Emails (Code): runs custom JavaScript code
- Analyze Email with Claude (Anthropic): uses Anthropic
- Parse Claude Analysis (Code): runs custom JavaScript code
- Log Insights to Google Sheets (Google Sheets): append
- Mark Email as Read (Gmail): mark as read (message)
- Add Analyzed Label (Gmail): add labels (message)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Anthropic
@n8n/n8n-nodes-langchain.anthropic
From the author
Quick Overview This workflow runs daily, pulls recent competitor newsletter emails from Gmail, analyzes each message with Anthropic Claude, and appends structured insights and response ideas to Google Sheets, then marks processed emails as read and labeled so…