This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "days",
"interval": 1
}
]
}
},
"name": "Daily Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
100,
300
]
},
{
"parameters": {
"model": "sonar-reasoning",
"prompt": "Find recent surplus funds lists or tax deed auction results for high-value Florida counties. Focus on properties with surplus amounts over $50,000. List the property address, sale date, and estimated surplus amount."
},
"name": "Find High-Value Leads (Perplexity)",
"type": "n8n-nodes-langchain.perplexity",
"typeVersion": 1,
"position": [
300,
300
]
},
{
"parameters": {
"model": "deepseek/deepseek-r1",
"prompt": "Extract the property details, sale dates, and surplus amounts from the following text into a structured JSON list: {{ $json.message.content }}. Only include leads with surplus > $50k."
},
"name": "Parse Leads (DeepSeek)",
"type": "n8n-nodes-langchain.lmChatOpenRouter",
"typeVersion": 1,
"position": [
500,
300
]
},
{
"parameters": {
"fieldToSplitOut": "leads",
"options": {}
},
"name": "Split Leads",
"type": "n8n-nodes-base.splitOut",
"typeVersion": 1,
"position": [
700,
300
]
},
{
"parameters": {
"model": "sonar-reasoning",
"prompt": "Conduct a deep search for the previous owner of {{ $json.address }}. Find current contact information (phone, email, current mailing address) and check for any secondary liens or bankruptcy filings that might complicate the claim."
},
"name": "Deep Verification (Perplexity)",
"type": "n8n-nodes-langchain.perplexity",
"typeVersion": 1,
"position": [
900,
200
]
},
{
"parameters": {
"model": "deepseek/deepseek-chat",
"prompt": "Analyze the verification data: {{ $json.message.content }}. Create a 'Claim Probability Score' (0-100). If score > 80, generate a high-urgency personalized outreach sequence including a custom SMS, a formal Email, and a script for a follow-up phone call. Mention the specific surplus of ${{ $node[\"Split Leads\"].json.amount }}."
},
"name": "Dynamic Outreach Gen (DeepSeek)",
"type": "n8n-nodes-langchain.lmChatOpenRouter",
"typeVersion": 1,
"position": [
1100,
200
]
},
{
"parameters": {
"resource": "message",
"from": "YOUR_TWILIO_NUMBER",
"to": "={{ $json.phone_number }}",
"message": "={{ $json.sms_body }}"
},
"name": "Send Urgent SMS (Twilio)",
"type": "n8n-nodes-base.twilio",
"typeVersion": 1,
"position": [
1300,
100
]
},
{
"parameters": {
"resource": "message",
"subject": "URGENT: Recovery of Your Unclaimed Funds for {{ $node[\"Split Leads\"].json.address }}",
"email": "={{ $json.email_address }}",
"message": "={{ $json.email_body }}"
},
"name": "Send Priority Email (Gmail)",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
1300,
300
]
},
{
"parameters": {
"operation": "append",
"documentId": "YOUR_GOOGLE_SHEET_ID",
"sheetName": "Active Claims",
"values": {
"Address": "={{ $node[\"Split Leads\"].json.address }}",
"Amount": "={{ $node[\"Split Leads\"].json.amount }}",
"Status": "Outreach Sent",
"Score": "={{ $json.probability_score }}"
}
},
"name": "Log to CRM (Google Sheets)",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1500,
200
]
}
],
"connections": {
"Daily Trigger": {
"main": [
[
{
"node": "Find High-Value Leads (Perplexity)",
"type": "main",
"index": 0
}
]
]
},
"Find High-Value Leads (Perplexity)": {
"main": [
[
{
"node": "Parse Leads (DeepSeek)",
"type": "main",
"index": 0
}
]
]
},
"Parse Leads (DeepSeek)": {
"main": [
[
{
"node": "Split Leads",
"type": "main",
"index": 0
}
]
]
},
"Split Leads": {
"main": [
[
{
"node": "Deep Verification (Perplexity)",
"type": "main",
"index": 0
}
]
]
},
"Deep Verification (Perplexity)": {
"main": [
[
{
"node": "Dynamic Outreach Gen (DeepSeek)",
"type": "main",
"index": 0
}
]
]
},
"Dynamic Outreach Gen (DeepSeek)": {
"main": [
[
{
"node": "Send Urgent SMS (Twilio)",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Priority Email (Gmail)",
"type": "main",
"index": 0
}
],
[
{
"node": "Log to CRM (Google Sheets)",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Surplus Funds Recovery Enhanced. Uses n8n-nodes-langchain, twilio, gmail, googleSheets. Scheduled trigger; 9 nodes.
Source: https://github.com/EdgeAgent/n8n-automations/blob/main/surplus_funds_recovery/surplus_funds_recovery_enhanced.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Surplus Funds Recovery. Uses n8n-nodes-langchain, twilio, gmail. Scheduled trigger; 9 nodes.
This workflow is a complete outbound automation system that discovers local businesses, extracts contact emails, generates personalized cold emails using AI, and runs a multi-step follow-up sequence —
Personalized Outreach & Follow-Up - Phase 2. Uses googleSheets, openAi, gmail, gmailTrigger. Scheduled trigger; 59 nodes.
This advanced workflow automates brand monitoring and media coverage tracking for musicians, bands, and music labels. The system uses multiple search queries (dorky) to discover mentions across the we
Stop wasting billable hours on manual time-tracking. AutoTimesheet Pro uses AI to collect emails, meetings, and GitHub work, then writes a clean timesheet straight into Google Sheets. Perfect for deve