Send regulatory update digest emails with Google Sheets, Excel, OpenAI and Perplexity
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 24 nodes and runs on a schedule (cron 0 0 13 */3 * *) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Microsoft Excel 365, Google Sheets and Perplexity.
How it runs
Trigger: On a schedule (cron 0 0 13 */3 * *) (plus 1 other trigger).
- Read the website list (Google Sheets): uses Google Sheets
- Said not interested? (If): checks a condition and branches into true / false
- Loop over websites (Loop Over Items (Split in Batches)): loops over the items in batches
- Mark as unsubscribed (Microsoft Excel 365): update (worksheet)
- Find updates with AI (AI Agent): runs an AI agent, with model: Chat model; 2 tools (Web scraper tool, Perplexity search tool); output parser: Output Parser - Update fields
- Keep only recent updates (Code): runs custom JavaScript code
- Any updates found? (If): checks a condition and branches into true / false
- One row per update (Split Out): splits a list into separate items
- Save updates to sheet (Google Sheets): append or update
- Group the updates (Aggregate): combines items into one
…plus 8 more steps. See the full node list below.
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 (17)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Email Trigger (IMAP)
n8n-nodes-base.emailReadImap - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Perplexity Tool
n8n-nodes-base.perplexityTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend - Wait
n8n-nodes-base.wait - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow
From the author
Quick overview This workflow runs every three days to scan a Google Sheets list of authority websites, uses OpenAI with a web-scraper sub-workflow and Perplexity search to extract recent regulatory notices, logs them to Google Sheets, and emails an HTML…