AutomationFlowsMarketing & Ads › Automate Loan Agency Lead Management with Twilio, Google Sheets & Drive

Automate Loan Agency Lead Management with Twilio, Google Sheets & Drive

ByMarth - Business Automation @marth on n8n.io

Setting up this powerful CRM system is a straightforward process that connects your lead sources, your database, and your communication channels. The core steps involve preparing your database, importing the workflow, and then customizing the nodes to match your business rules.…

Webhook trigger★★★★☆ complexity11 nodesGoogle SheetsTwilioGoogle Drive
Marketing & Ads Trigger: Webhook Nodes: 11 Complexity: ★★★★☆ Added:

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

This workflow follows the Google Drive → 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": "DmeYocUMLd2GidjA",
  "name": "Automated Loan Agency CRM Workflow",
  "tags": [],
  "nodes": [
    {
      "id": "89258a0e-d884-4904-9d90-c16ca02a6a33",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "69e8ccc5-83b2-46d5-b549-7c09d896462c",
      "name": "Data Cleansing & Duplicates",
      "type": "n8n-nodes-base.code",
      "position": [
        208,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "45fba5ea-b903-41b0-bded-8f94e93dbdc5",
      "name": "Auto-Assign Agent",
      "type": "n8n-nodes-base.code",
      "position": [
        416,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4972f43b-f5bd-46b0-a3b0-1ce2b5c8bdb7",
      "name": "Store Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        624,
        0
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "bb9f7707-10ad-4cce-9d64-1d640eec87c1",
      "name": "Send Notifications",
      "type": "n8n-nodes-base.twilio",
      "position": [
        832,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "89ff9c35-cb8b-4c8d-b5cb-e4d8cca828eb",
      "name": "Webhook1",
      "type": "n8n-nodes-base.webhook",
      "position": [
        0,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "679ea89a-4d27-4229-af09-a00194b2b95c",
      "name": "Update Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        208,
        336
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "ed81111d-5780-49dc-a2b2-ba5d50ec79d8",
      "name": "Document Management",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        416,
        336
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "7d622673-2dc8-472a-9a65-22de7e7b383a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e0f85838-4bad-4544-a7b3-57710d5c0dcd",
      "name": " New Lead Intake & Assignment",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5cf9ea36-70f3-4ab1-8ffb-7022bab56eb4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "24d03e3f-c089-4e1b-96f8-dc3f494476eb",
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "Data Cleansing & Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook1": {
      "main": [
        [
          {
            "node": "Update Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Data": {
      "main": [
        [
          {
            "node": "Send Notifications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Status": {
      "main": [
        [
          {
            "node": "Document Management",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Auto-Assign Agent": {
      "main": [
        [
          {
            "node": "Store Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Cleansing & Duplicates": {
      "main": [
        [
          {
            "node": "Auto-Assign Agent",
            "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

Setting up this powerful CRM system is a straightforward process that connects your lead sources, your database, and your communication channels. The core steps involve preparing your database, importing the workflow, and then customizing the nodes to match your business rules.…

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

More Marketing & Ads workflows → · Browse all categories →

Related workflows

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

Marketing & Ads

Note: This template is designed for both self-hosted and cloud-based n8n instances. The workflow image above shows the complete automation flow.

Google Drive, Google Sheets, Gmail
Marketing & Ads

Who is this for? Solo founders, sales teams, and event organizers who need email outreach without expensive tools but want full control from Telegram.

Telegram, Google Sheets, Google Sheets Trigger +2
Marketing & Ads

This workflow is designed to manage the assignment and validation of unique QR code coupons within a lead generation system with SuiteCRM.

HTTP Request, Form Trigger, Google Sheets +1
Marketing & Ads

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

Google Sheets, HTTP Request, Gmail +1
Marketing & Ads

AI Lead Qualification & Roting System. Uses httpRequest, twilio, airtable. Webhook trigger; 26 nodes.

HTTP Request, Twilio, Airtable