Monitor competitor pages and email AI-ranked digests with Sheets, Gemini, Gmail

by Lhoussaine Ait Aissa ✓ · 3 views · created 2026-09-05 · Market Research, AI Summarization

What this workflow does

This AI workflow has 17 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets, Gmail and Google Gemini.

How it runs

Trigger: On a schedule (every day at 08:00).

1. Set Monitor Configurations (Edit Fields (Set)): sets 3 fields: digest_recipient, significance_threshold, max_diff_lines
2. Read Tracked Pages from Sheets (Google Sheets): uses Google Sheets
3. Loop Over Tracked Pages (Loop Over Items (Split in Batches)): loops over the items in batches
4. Aggregate: combines items into one
5. Fetch HTML from Page URL (HTTP Request): calls an HTTP API
6. Construct Email Digest (Code): runs custom JavaScript code
7. Extract Comparable Text (Code): runs custom JavaScript code
8. Check for Notable Changes (If): checks a condition and branches into true / false
9. Check Page Change (If): checks a condition and branches into true / false
10. Send Digest via Gmail (Gmail): uses Gmail

…plus 5 more steps. See the full node list below.

Services it uses

Google SheetsGmailGoogle Gemini

Before you upgrade to n8n 3.0

Nodes used (11)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Aggregaten8n-nodes-base.aggregate
• Gmailn8n-nodes-base.gmail
• No Operation, do nothingn8n-nodes-base.noOp
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini

From the author

Quick overview This workflow runs daily to fetch competitor web pages listed in Google Sheets, detects meaningful content changes using a text fingerprint, scores and summarizes changes with Google Gemini, and emails a ranked HTML digest via Gmail only when…

View the original on n8n.io → Check your own copy