Automated stale user re-engagement system with Supabase, Google Sheets & Gmail
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 12 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets, Gmail and Google Vertex Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- AI Agent: runs an AI agent, with model: Google Vertex Chat Model; output parser: Structured Output Parser
- Clear sheet (Google Sheets): uses Google Sheets
- Edit Fields (Edit Fields (Set)): sets or maps fields
- Code: runs custom JavaScript code
- HTTP Request: calls an HTTP API
- Remove Duplicates: removes duplicate items
- Update Google Sheet with Leads (Google Sheets): uses Google Sheets
- Send a message (Gmail): uses Gmail
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 (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Remove Duplicates
n8n-nodes-base.removeDuplicates - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Google Vertex Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleVertex - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
Built this workflow because most of our users signed up, then vanished after ~30 days. It runs daily, grabs those stale users from Supabase, updates a Google Sheet for tracking, and automatically sends each one a personalized HTML email through Gmail to bring…