David Olusola This workflow corresponds to n8n.io template #3794 — we link there as the canonical source.
This workflow follows the Gmail → Google Drive 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 →
{
"id": "rCDUuQlDsQpcWDlb",
"name": "Solar Lead Qualification & Auto-Response System",
"tags": [],
"nodes": [
{
"id": "3e998cde-b40e-488f-8fec-bd6236739a17",
"name": "[STEP 2] Upload Utility Bill",
"type": "n8n-nodes-base.googleDrive",
"position": [
-900,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ff59804e-dffe-44f9-a508-b83c751079b4",
"name": "[STEP 3] Make Bill Viewable",
"type": "n8n-nodes-base.googleDrive",
"position": [
-700,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "68ed779d-b8ae-42c0-8c2b-5d02be52f1a2",
"name": "[STEP 4] Create Bill Link",
"type": "n8n-nodes-base.function",
"position": [
-520,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "97436bb1-f20d-4922-9be2-297c2f569885",
"name": "[STEP 5] Save Lead to Spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
200
],
"parameters": {},
"typeVersion": 4
},
{
"id": "65100f33-5e32-4fcc-a54a-5e122f590346",
"name": "[STEP 7] Check Qualification Criteria",
"type": "n8n-nodes-base.code",
"position": [
-1000,
680
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3eaba98d-43e9-4d5a-9c80-48320c8a66ff",
"name": "Check Qualification Status",
"type": "n8n-nodes-base.if",
"position": [
-600,
680
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "01c128a7-e67e-461f-b7ed-cc0d4275747c",
"name": "[STEP 10A] Send Acceptance Email",
"type": "n8n-nodes-base.gmail",
"position": [
-380,
500
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "11e46266-d94f-4ec5-adaa-8b6e23cc44bc",
"name": "[STEP 10B] Send Rejection Email",
"type": "n8n-nodes-base.gmail",
"position": [
-360,
740
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "73b04cb5-c785-49f4-bc16-4c2d84bbf3e0",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9b569a4a-f79d-4c05-a088-bd104efdf03d",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9f35a33d-c7c1-42db-aadf-91104d242ec5",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
500
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1370e913-8431-40a3-ae45-5114e7b82511",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
440
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0836ce79-f911-4d03-bce7-ce8554d4e580",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ef923c7c-3583-41fe-8f16-9e08ece43e83",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-1180,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6b69501b-83c9-43f0-a3d2-baf5da943df9",
"name": "[STEP 8] Update Qualification Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
-840,
680
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "777eff8b-241c-4e4d-9deb-1ee10c8a7a6d",
"name": "Append row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-160,
520
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "6ebb0a11-eef1-4bc4-a88c-02de73c9b734",
"name": "[STEP 5] Save Lead to Spreadsheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1240,
680
],
"parameters": {},
"typeVersion": 4
},
{
"id": "5831d64b-5f32-44f8-9d90-4b2a59e4af3d",
"name": "Webhook1",
"type": "n8n-nodes-base.webhook",
"position": [
-1520,
680
],
"parameters": {},
"typeVersion": 2
},
{
"id": "537dbebc-ea70-4e8c-b680-73796cb47a08",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "44b2c824-72ef-4a64-804e-63db76e40d41",
"connections": {
"Webhook": {
"main": [
[
{
"node": "[STEP 2] Upload Utility Bill",
"type": "main",
"index": 0
}
]
]
},
"Webhook1": {
"main": [
[
{
"node": "[STEP 5] Save Lead to Spreadsheet1",
"type": "main",
"index": 0
}
]
]
},
"[STEP 4] Create Bill Link": {
"main": [
[
{
"node": "[STEP 5] Save Lead to Spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Check Qualification Status": {
"main": [
[
{
"node": "[STEP 10A] Send Acceptance Email",
"type": "main",
"index": 0
}
],
[
{
"node": "[STEP 10B] Send Rejection Email",
"type": "main",
"index": 0
}
]
]
},
"[STEP 3] Make Bill Viewable": {
"main": [
[
{
"node": "[STEP 4] Create Bill Link",
"type": "main",
"index": 0
}
]
]
},
"[STEP 2] Upload Utility Bill": {
"main": [
[
{
"node": "[STEP 3] Make Bill Viewable",
"type": "main",
"index": 0
}
]
]
},
"[STEP 10A] Send Acceptance Email": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"[STEP 5] Save Lead to Spreadsheet": {
"main": [
[
{
"node": "[STEP 7] Check Qualification Criteria",
"type": "main",
"index": 0
}
]
]
},
"[STEP 5] Save Lead to Spreadsheet1": {
"main": [
[
{
"node": "[STEP 7] Check Qualification Criteria",
"type": "main",
"index": 0
}
]
]
},
"[STEP 8] Update Qualification Status": {
"main": [
[
{
"node": "Check Qualification Status",
"type": "main",
"index": 0
}
]
]
},
"[STEP 7] Check Qualification Criteria": {
"main": [
[
{
"node": "[STEP 8] Update Qualification Status",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Note: This template is designed for both self-hosted and cloud-based n8n instances. The workflow image above shows the complete automation flow.
Source: https://n8n.io/workflows/3794/ — 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.
Who is this for? Solo founders, sales teams, and event organizers who need email outreach without expensive tools but want full control from Telegram.
This workflow acts as an instant SDR that replies to new inbound leads across multiple channels in real time. It first captures and normalizes all incoming lead data into a unified structure. The work
Turn a simple Google Sheet into a lightweight CRM powered by n8n.
A comprehensive n8n workflow template for streamlining influencer application processing with real-time social media data validation, intelligent scoring algorithms, and automated onboarding workflows
AI Lead Qualification & Follow-Up. Uses httpRequest, slack, googleSheets, gmail. Webhook trigger; 18 nodes.