Seguimiento Prospectos

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 →

{
  "name": "Seguimiento Prospectos",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "days",
              "daysInterval": 1,
              "triggerAtHour": 9,
              "triggerAtMinute": 0
            }
          ]
        }
      },
      "id": "s1",
      "name": "Diario 9AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        0,
        300
      ]
    },
    {
      "parameters": {
        "operation": "getAll",
        "tableId": "prospectos",
        "options": {
          "limit": 1000
        }
      },
      "id": "s2",
      "name": "Traer Prospectos",
      "type": "n8n-nodes-base.supabase",
      "typeVersion": 2,
      "position": [
        220,
        300
      ],
      "credentials": {
        "supabaseApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "jsCode": "const rows = $('Traer Prospectos').all().flatMap(i => i.json).flat(1).filter(x => x && typeof x === 'object');\nconst DELTAS = [0, 2, 3, 4, 6, 15];\nconst now = Date.now();\nconst MENSAJES = {\n  0: 'Hola {N} \ud83d\udc4b Soy Jean, de JeanCRG. Vi que {B} trabaja por WhatsApp y quiero mostrarle algo: un asistente con IA que responde solo, agenda citas y captura clientes las 24h. \u00bfLe interesa una demo de 5 minutos? Sin compromiso.',\n  1: 'Hola {N} \ud83d\udc4b Le escrib\u00ed hace unos d\u00edas sobre el asistente IA para WhatsApp. \u00bfSigue interesado en ver una demo de 5 minutos?',\n  2: 'Hola {N} \ud83d\ude0a Solo quer\u00eda retomar el tema del asistente IA. Tenemos un piloto de 15 d\u00edas por $800.000 (100% descontable). \u00bfLe cuento c\u00f3mo funciona?',\n  3: 'Hola {N}, \u00bfqu\u00e9 tal? Le dejo el enlace para agendar una consulta gratis de 30 minutos: https://calendly.com/jeancrg/consulta-gratuita. Sin compromiso.',\n  4: 'Hola {N} \ud83d\ude4c \u00daltimo mensaje por ahora. Si en alg\u00fan momento quiere automatizar su WhatsApp, aqu\u00ed estamos. \u00a1\u00c9xitos con {B}!',\n  5: 'Hola {N}, \u00bfc\u00f3mo va {B}? Si quiere reactivar el tema del asistente IA, seguimos disponibles. \u00a1Un abrazo!'\n};\nconst pendientes = [];\nfor (const p of rows) {\n  const toque = p.toque || 0;\n  if (toque >= 5) continue;\n  const ult = p.fecha_ultimo_toque ? new Date(p.fecha_ultimo_toque).getTime() : null;\n  const deltaDias = DELTAS[Math.min(toque, 5)];\n  const due = ult === null || (now - ult) >= deltaDias * 86400000;\n  if (!due) continue;\n  const tel = String(p.telefono || '').replace(/\\D/g, '');\n  const msj = MENSAJES[Math.min(toque, 5)].replace('{N}', p.nombre || 'amigo').replace('{B}', p.negocio || 'su negocio');\n  pendientes.push({ json: {\n    nombre: p.nombre, negocio: p.negocio, telefono: tel, toque: toque + 1,\n    wa: 'https://wa.me/' + tel,\n    marcar: 'https://n8n-production-d5b6.up.railway.app/webhook/marcar-toque?secret=jeancrg2026panel&telefono=' + tel,\n    mensaje: msj\n  } });\n}\nreturn pendientes;"
      },
      "id": "s3",
      "name": "Calcular Pendientes",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        440,
        300
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "={{ 'https://api.telegram.org/bot8807842110:AAGgU6QDADaN-Lvt_hqZV_orFIhG0dwrT1E/sendMessage' }}",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={{ { chat_id: 7309831214, text: '\ud83d\udcc5 TOQUE ' + $json.toque + ' \u2014 ' + $json.nombre + ($json.negocio ? ' (' + $json.negocio + ')' : '') + '\\n\ud83d\udcf1 ' + $json.telefono + '\\n\ud83d\udcac ' + $json.mensaje + '\\n\\n\u2705 Tras contactar, marca el toque: ' + $json.marcar, disable_web_page_preview: true } }}",
        "options": {}
      },
      "id": "s4",
      "name": "Enviar Telegram",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        660,
        300
      ]
    }
  ],
  "connections": {
    "Diario 9AM": {
      "main": [
        [
          {
            "node": "Traer Prospectos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Traer Prospectos": {
      "main": [
        [
          {
            "node": "Calcular Pendientes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calcular Pendientes": {
      "main": [
        [
          {
            "node": "Enviar Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  }
}

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.

• supabaseApi

About this workflow

Seguimiento Prospectos. Uses supabase, httpRequest. Scheduled trigger; 4 nodes.

Source: https://github.com/JeanCardozo/chatAI/blob/main/workflows/seguimiento-prospectos.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

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