Gabarito Subagente Financeiro Aula 3

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": "Gabarito SubAgente Financeiro Aula 3",
  "nodes": [
    {
      "parameters": {
        "workflowInputs": {
          "values": [
            {
              "name": "mensagem"
            },
            {
              "name": "ChatID"
            }
          ]
        }
      },
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "typeVersion": 1.1,
      "position": [
        0,
        0
      ],
      "id": "8bde74f4-f7b0-4911-8efa-9ad5dea27b1c",
      "name": "When Executed by Another Workflow"
    },
    {
      "parameters": {
        "promptType": "define",
        "text": "={{ $json.mensagem }}",
        "options": {
          "systemMessage": "=# Identidade\nVoc\u00ea \u00e9 a Bia, Analista Financeira da Hashtag Capital.\nSeu tom \u00e9: Emp\u00e1tico, Colaborativo e Atencioso. Escreva como um parceiro de neg\u00f3cios que quer ajudar, focando na solu\u00e7\u00e3o e n\u00e3o apenas na cobran\u00e7a/regra.\n\n# Contexto Temporal\nA data e hora exata de hoje \u00e9: {{ $now }}.\nUse para verificar vencimentos de boletos.\n\n# Sua Ferramenta Principal\nVoc\u00ea tem acesso \u00e0 tool `consultar_status_cliente`.\nUse-a sempre que o aluno perguntar sobre Pagamentos em aberto, boletos, segunda via.\n\n# Instru\u00e7\u00f5es de Opera\u00e7\u00e3o\n1. Coleta de dados. Pe\u00e7a o nome e e-mail do cliente para confer\u00eancia\n2. Consulta: Chame a tool enviando o E-mail do cliente.\n3. An\u00e1lise do Retorno:\n   - Se \"Sem Pend\u00eancias\": \"Sua conta est\u00e1 regular e sem pend\u00eancias financeiras.\"\n   - Se \"Pendente\": \"Aqui est\u00e1 o link para pagamento da fatura\"\n   - Se o cliente quiser a segunda via (independente de regularizado ou pendente): \u201cAqui est\u00e1 o link da 2a via do seu boleto\u201d\n\n# Regra de Seguran\u00e7a\nNunca invente informa\u00e7\u00f5es. Baseie-se estritamente no retorno da ferramenta.\n\n# REGRA DE FORMATA\u00c7\u00c3O\n- O sistema de chat N\u00c3O aceita formata\u00e7\u00e3o (negrito/it\u00e1lico).\n- NUNCA use asteriscos (`*` ou `**`).\n- NUNCA use tags HTML.\n\n# Regra de sa\u00edda\nSe o assunto for SUPORTE T\u00c9CNICO (App/D\u00favidas) ou CS (Investir/Agendar), responda apenas:\n##RESET##"
        }
      },
      "type": "@n8n/n8n-nodes-langchain.agent",
      "typeVersion": 3.1,
      "position": [
        208,
        0
      ],
      "id": "05a0eb75-4033-480e-9706-34908c01b4b7",
      "name": "AI Agent"
    },
    {
      "parameters": {
        "options": {}
      },
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "typeVersion": 1,
      "position": [
        80,
        208
      ],
      "id": "3bc896c8-1f2a-4767-af96-9bcbc55540f6",
      "name": "Google Gemini Chat Model",
      "credentials": {
        "googlePalmApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "sessionIdType": "customKey",
        "sessionKey": "={{ $json.ChatID }}",
        "contextWindowLength": 20
      },
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "typeVersion": 1.3,
      "position": [
        224,
        208
      ],
      "id": "81cb0e92-8363-47d2-83d2-82255722e1c7",
      "name": "Simple Memory"
    },
    {
      "parameters": {
        "documentId": {
          "__rl": true,
          "value": "1EIsMe2HqNieaq3ErlEde_SqGZFq_FBYhthYpPK4G3OA",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": 952327553,
          "mode": "list",
          "cachedResultName": "financeiro",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EIsMe2HqNieaq3ErlEde_SqGZFq_FBYhthYpPK4G3OA/edit#gid=952327553"
        },
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "E-mail Cliente",
              "lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', `E-mail que o cliente enviou para confer\u00eancia`, 'string') }}"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.googleSheetsTool",
      "typeVersion": 4.7,
      "position": [
        368,
        208
      ],
      "id": "579f1c2d-6591-4601-90a3-b611e6f39328",
      "name": "consultar_status_cliente",
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "consultar_status_cliente": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": true,
  "settings": {
    "executionOrder": "v1",
    "availableInMCP": false
  },
  "versionId": "d2ed9968-cc9a-4b1a-827f-2bbade79a800",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "id": "yEzjvEaDiPYa17ysD4Gvj",
  "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.

• googlePalmApi
• googleSheetsOAuth2Api

About this workflow

Gabarito SubAgente Financeiro Aula 3. Uses executeWorkflowTrigger, agent, lmChatGoogleGemini, memoryBufferWindow. Event-driven trigger; 5 nodes.

Source: https://github.com/IDB-devs/N8N_MultiAgentes_Analise/blob/main/MultiAgentes_Analise_Financeiro.json — 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.