Audit forgotten online accounts from Gmail with OpenAI 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 workflow has 25 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Gmail and Google Sheets. It also calls openrouter.ai over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Set Discovery Mode (Edit Fields (Set)): sets 1 field: executionMode
- Set Digest Mode (Edit Fields (Set)): sets 1 field: executionMode
- Set Template Fields (Edit Fields (Set)): sets 13 fields: gmailDiscoveryQuery, gmailTestQuery, processedGmailLabel…
- Is Weekly Digest Run (If): checks a condition and branches into true / false
- Read Account Register (Google Sheets): uses Google Sheets
- Search Gmail Account Signals (Gmail): get many (message)
- Prepare Privacy Digest (Code): runs custom JavaScript code
- Fetch Full Account Emails (Gmail): get (message)
- Send Weekly Privacy Digest (Gmail): uses Gmail
- Prepare Candidate Account Emails (Code): runs custom JavaScript code
…plus 12 more steps. See the full node list below.
Services it uses
HTTP calls to: openrouter.ai
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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow audits your Gmail for account-related emails, uses an AI model via OpenRouter to extract service details and risk signals, and maintains a deduplicated account register in Google Sheets, with optional review alerts and a weekly…