AutomationFlowsAI & RAG › Reactivate Solar Leads with Ai-powered Sms, Email & Google Sheets Automation

Reactivate Solar Leads with Ai-powered Sms, Email & Google Sheets Automation

ByDavid Olusola @dae221 on n8n.io

This workflow helps solar sales teams reactivate cold leads automatically using value-first SMS follow-ups, AI-powered sentiment detection, real-time alerts, and CRM tracking.

Webhook trigger★★★★☆ complexityAI-powered28 nodesGoogle SheetsTwilioEmail SendOpenAI
AI & RAG Trigger: Webhook Nodes: 28 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #6213 — we link there as the canonical source.

This workflow follows the Emailsend → 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 →

Download .json
{
  "id": "FcYSrOOmvhHNunFy",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Solar Lead Reactivation",
  "tags": [],
  "nodes": [
    {
      "id": "b0c58e82-6c8c-4eb6-b43f-b7e7f8cf4541",
      "name": "\ud83d\udccb Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4020,
        -780
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a1148985-cdc2-4418-ba2f-dd68cdf99513",
      "name": "\ud83d\udcca Google Sheets Guide",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4020,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6c978b0a-a2fd-4055-8a71-dcd10f681d4a",
      "name": "\ud83d\udcc5 Sequence Strategy",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2820,
        60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bdffcefe-1fdb-4e62-87c8-6d7fc5da6789",
      "name": "\ud83e\udd16 AI Response Guide",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2540,
        -860
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "439691b2-5432-4084-9771-002f98ca6e23",
      "name": "\u2699\ufe0f Setup Instructions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3460,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "534718b3-76c2-4ac1-a38a-420d9b23906e",
      "name": "\ud83d\udcc8 Performance Guide",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1380,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "59729b30-c802-459b-ba7f-e93cb89713e6",
      "name": "Filter Ready Leads",
      "type": "n8n-nodes-base.code",
      "position": [
        -3140,
        -200
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "201e24e6-c323-4c0e-9e1d-33b22025bf79",
      "name": "Process One Lead at a Time",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -2920,
        -200
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "1a87c08d-7255-467a-8db3-efe20fabb560",
      "name": "Mark Sequence Active",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2680,
        -180
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "deb0608e-20b1-487d-b1d8-5553a2782b5b",
      "name": "Week 1 SMS",
      "type": "n8n-nodes-base.twilio",
      "position": [
        -2480,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fd8af3c2-def5-4930-9aa9-74ef58e20e73",
      "name": "Wait 1 Week",
      "type": "n8n-nodes-base.wait",
      "position": [
        -2260,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5f82ebd0-3542-4593-abe1-77e1f53541f9",
      "name": "Week 2 SMS",
      "type": "n8n-nodes-base.twilio",
      "position": [
        -2040,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6251747b-d48f-430c-b83b-4e55da14d1e7",
      "name": "Wait 2 Weeks",
      "type": "n8n-nodes-base.wait",
      "position": [
        -1820,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0b30cc3a-1cb0-48a4-a189-4693d16553b1",
      "name": "Week 3 Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -1600,
        -200
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "47feb955-2114-4dca-b8bb-b85772ea6762",
      "name": "Wait 3 Weeks",
      "type": "n8n-nodes-base.wait",
      "position": [
        -1380,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8f1f5bff-9b9e-4719-937e-4ae368835628",
      "name": "Week 4 SMS",
      "type": "n8n-nodes-base.twilio",
      "position": [
        -1160,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9e0efcd8-55bc-436c-8ba8-93b79153d271",
      "name": "Wait 4 Weeks",
      "type": "n8n-nodes-base.wait",
      "position": [
        -940,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b989f278-a414-4c85-b4c2-9889b50e1edd",
      "name": "Final SMS",
      "type": "n8n-nodes-base.twilio",
      "position": [
        -720,
        -200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e0f29e52-59de-412e-82ce-d31c814b1330",
      "name": "Mark Sequence Complete",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -500,
        -200
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "83b2ca04-9208-4cae-a7f5-dff7591d675b",
      "name": "SMS Reply Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -3460,
        -380
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "77dead87-4773-454d-b350-2bc691e558fb",
      "name": "Parse Reply",
      "type": "n8n-nodes-base.code",
      "position": [
        -3240,
        -380
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "42c46794-317f-40bd-b484-6131863807d3",
      "name": "Find Lead Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -3020,
        -380
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "619280ca-c23c-4375-a1db-4aab8eaa4e56",
      "name": "AI Generate Response",
      "type": "n8n-nodes-base.openAi",
      "position": [
        -2800,
        -380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "42bab90b-ca10-460c-ae68-91933166a875",
      "name": "Send AI Reply",
      "type": "n8n-nodes-base.twilio",
      "position": [
        -2580,
        -380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3615cce3-9a70-4a39-ae48-21b007759cd5",
      "name": "Analyze Response Intent",
      "type": "n8n-nodes-base.code",
      "position": [
        -2360,
        -380
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ed6fc588-55f4-418a-aba7-0f3d4a85a92a",
      "name": "Update Response Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2140,
        -380
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "ff293413-c2dc-463b-937e-01212e432ce7",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -3580,
        -200
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "9940fab1-ef0f-4bdf-bd31-5e1c1db32554",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -3360,
        -200
      ],
      "parameters": {},
      "typeVersion": 4.6
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a05dd95b-ec73-4398-8d02-a4e08d8e0b9c",
  "connections": {
    "Final SMS": {
      "main": [
        [
          {
            "node": "Mark Sequence Complete",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Week 1 SMS": {
      "main": [
        [
          {
            "node": "Wait 1 Week",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Week 2 SMS": {
      "main": [
        [
          {
            "node": "Wait 2 Weeks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Week 4 SMS": {
      "main": [
        [
          {
            "node": "Wait 4 Weeks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Reply": {
      "main": [
        [
          {
            "node": "Find Lead Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 1 Week": {
      "main": [
        [
          {
            "node": "Week 2 SMS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 2 Weeks": {
      "main": [
        [
          {
            "node": "Week 3 Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 3 Weeks": {
      "main": [
        [
          {
            "node": "Week 4 SMS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 4 Weeks": {
      "main": [
        [
          {
            "node": "Final SMS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Week 3 Email": {
      "main": [
        [
          {
            "node": "Wait 3 Weeks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send AI Reply": {
      "main": [
        [
          {
            "node": "Analyze Response Intent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Lead Data": {
      "main": [
        [
          {
            "node": "AI Generate Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SMS Reply Webhook": {
      "main": [
        [
          {
            "node": "Parse Reply",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Ready Leads": {
      "main": [
        [
          {
            "node": "Process One Lead at a Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Filter Ready Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Generate Response": {
      "main": [
        [
          {
            "node": "Send AI Reply",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Sequence Active": {
      "main": [
        [
          {
            "node": "Week 1 SMS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze Response Intent": {
      "main": [
        [
          {
            "node": "Update Response Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process One Lead at a Time": {
      "main": [
        [],
        [
          {
            "node": "Mark Sequence Active",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow helps solar sales teams reactivate cold leads automatically using value-first SMS follow-ups, AI-powered sentiment detection, real-time alerts, and CRM tracking.

Source: https://n8n.io/workflows/6213/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Watch on Youtube▶️

HTTP Request, Email Send, Google Sheets +3
AI & RAG

Property managers and operations teams who want better visibility into unresolved maintenance requests.

OpenAI, Google Sheets, Slack +1
AI & RAG

Automate reminders, follow-ups, and client engagement for your pet grooming business with this simple n8n workflow by Hyrum Hurst, AI Automation Engineer at QuarterSmart. Sends personalized SMS and em

Google Sheets, OpenAI, Twilio +2
AI & RAG

유저 문의 자동 분류/응대 (IF Node). Uses openAi, googleTranslate, googleSheets, readBinaryFile. Webhook trigger; 19 nodes.

OpenAI, Google Translate, Google Sheets +2
AI & RAG

Consulting firms in strategy, management, or IT who want to automate client onboarding and internal task assignment.

OpenAI, Google Sheets, Slack +3