AutomationFlowsMarketing & Ads › Caipher AI - Create Lead

Caipher AI - Create Lead

Caipher AI - Create Lead. Uses googleSheets. Webhook trigger; 4 nodes.

Webhook trigger★★★★☆ complexity4 nodesGoogle Sheets
Marketing & Ads Trigger: Webhook Nodes: 4 Complexity: ★★★★☆ Added:

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
{
  "name": "Caipher AI - Create Lead",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "elevenlabs-webhook/create-lead",
        "responseMode": "responseNode",
        "options": {}
      },
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2.1,
      "position": [
        260,
        460
      ],
      "id": "wh-create-lead",
      "name": "Create Lead Webhook"
    },
    {
      "parameters": {
        "jsCode": "const body = $input.all()[0].json.body || $input.all()[0].json;\n\nconst caller_name = body.caller_name || body.name || 'Unknown';\nconst caller_phone = body.caller_phone || body.phone || body.phone_number || '';\nconst caller_email = body.caller_email || body.email || '';\nconst business_name = body.business_name || body.company || '';\nconst industry = body.industry || '';\nconst interest = body.interest || body.reason || '';\nconst notes = body.notes || '';\n\nreturn [{\n  json: {\n    caller_name,\n    caller_phone,\n    caller_email,\n    business_name,\n    industry,\n    interest,\n    notes,\n    timestamp: new Date().toISOString()\n  }\n}];"
      },
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        500,
        460
      ],
      "id": "parse-lead",
      "name": "Parse Lead Data"
    },
    {
      "parameters": {
        "operation": "appendOrUpdate",
        "documentId": {
          "__rl": true,
          "value": "1KFnP0q_oY91rUX3KHzEOCuukxc4C3opkPLhOQMXBvzU",
          "mode": "list",
          "cachedResultName": "lead_template",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KFnP0q_oY91rUX3KHzEOCuukxc4C3opkPLhOQMXBvzU/edit?usp=drivesdk"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "Sheet1",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KFnP0q_oY91rUX3KHzEOCuukxc4C3opkPLhOQMXBvzU/edit#gid=0"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "name": "={{ $json.caller_name }}",
            "phone_number": "={{ $json.caller_phone }}",
            "email": "={{ $json.caller_email }}",
            "business_name": "={{ $json.business_name }}",
            "status": "=NEW_LEAD",
            "last_called": "={{ $json.timestamp }}",
            "notes": "={{ $json.notes || $json.interest }}",
            "output": "=INBOUND - NEW_LEAD",
            "leadCategory": "=Inbound Lead",
            "interestLevel": "=Warm"
          },
          "matchingColumns": [
            "phone_number"
          ],
          "schema": [
            {
              "id": "name",
              "displayName": "name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "business_name",
              "displayName": "business_name",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "phone_number",
              "displayName": "phone_number",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "displayName": "email",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "displayName": "status",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "last_called",
              "displayName": "last_called",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "notes",
              "displayName": "notes",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "output",
              "displayName": "output",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "leadCategory",
              "displayName": "leadCategory",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            },
            {
              "id": "interestLevel",
              "displayName": "interestLevel",
              "required": false,
              "defaultMatch": false,
              "display": true,
              "type": "string",
              "canBeUsedToMatch": true
            }
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "position": [
        740,
        460
      ],
      "id": "save-lead",
      "name": "Save Lead to Sheets",
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "respondWith": "json",
        "responseBody": "={{ JSON.stringify({ success: true, message: 'Lead created for ' + $('Parse Lead Data').first().json.caller_name, lead_name: $('Parse Lead Data').first().json.caller_name, lead_phone: $('Parse Lead Data').first().json.caller_phone }) }}"
      },
      "type": "n8n-nodes-base.respondToWebhook",
      "typeVersion": 1,
      "position": [
        980,
        460
      ],
      "id": "respond-lead",
      "name": "Respond Success"
    }
  ],
  "connections": {
    "Create Lead Webhook": {
      "main": [
        [
          {
            "node": "Parse Lead Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Lead Data": {
      "main": [
        [
          {
            "node": "Save Lead to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Lead to Sheets": {
      "main": [
        [
          {
            "node": "Respond Success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "tags": []
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

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

About this workflow

Caipher AI - Create Lead. Uses googleSheets. Webhook trigger; 4 nodes.

Source: https://github.com/theblockchainbaby/automotive-ai/blob/3cb12bbd79eaa99ca866dd6f2d0c6b4a669959eb/workflows/create-lead.json — 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

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

Turn a simple Google Sheet into a lightweight CRM powered by n8n.

Gmail, Google Sheets
Marketing & Ads

A comprehensive n8n workflow template for streamlining influencer application processing with real-time social media data validation, intelligent scoring algorithms, and automated onboarding workflows

N8N Nodes Verifiemail, Stop And Error, HTTP Request +2