Richard (asst Fin) - Atualização Diária De Fluxo De Caixa

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": "Richard (Asst Fin) - Atualiza\u00e7\u00e3o di\u00e1ria de fluxo de caixa",
  "nodes": [
    {
      "id": "1",
      "name": "Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        240,
        300
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "value": "0 0 * * *"
            }
          ]
        },
        "timezone": "America/Sao_Paulo"
      },
      "typeVersion": 1,
      "notes": "Disparar todo dia \u00e0 meia-noite"
    },
    {
      "id": "2",
      "name": "Fetch Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        300
      ],
      "parameters": {
        "operation": "read",
        "range": "A:Z"
      },
      "typeVersion": 1,
      "notes": "Ler dados de entradas e sa\u00eddas do Google Sheets",
      "credentials": {
        "googleSheetsOAuth2": {
          "name": "<your credential>"
        }
      }
    },
    {
      "id": "3",
      "name": "Transform",
      "type": "n8n-nodes-base.function",
      "position": [
        680,
        300
      ],
      "parameters": {
        "functionCode": "return items.map(item => ({ ...item.json, balance: item.json.income - item.json.expense }));"
      },
      "typeVersion": 1,
      "notes": "Calcular o saldo do dia"
    },
    {
      "id": "4",
      "name": "Action",
      "type": "n8n-nodes-base.function",
      "position": [
        900,
        300
      ],
      "parameters": {
        "to": "finance@arvatech.com",
        "body": "O saldo atualizado do fluxo de caixa \u00e9: {{ $json.balance }}",
        "subject": "Atualiza\u00e7\u00e3o Di\u00e1ria do Fluxo de Caixa"
      },
      "typeVersion": 1,
      "notes": "Enviar e-mail com o saldo do dia para o departamento financeiro"
    },
    {
      "id": "5",
      "name": "Error Handler",
      "type": "n8n-nodes-base.slack",
      "position": [
        1120,
        450
      ],
      "parameters": {
        "resource": "message",
        "operation": "post",
        "channel": "#vcm-errors",
        "text": "\u274c Erro no workflow: Richard (Asst Fin) - Atualiza\u00e7\u00e3o di\u00e1ria de fluxo de caixa\nEmpresa: ARVA Tech Solutions\nPersona: Richard Garcia\nTarefa: Atualiza\u00e7\u00e3o di\u00e1ria de fluxo de caixa\n\nErro: {{ $json.error }}"
      },
      "typeVersion": 1,
      "notes": "Error handler - notifica falhas no Slack",
      "credentials": {
        "slackApi": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "1": {
      "main": [
        [
          {
            "node": "2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2": {
      "main": [
        [
          {
            "node": "3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3": {
      "main": [
        [
          {
            "node": "4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1",
    "saveManualExecutions": true,
    "callerPolicy": "workflowsFromSameOwner",
    "timezone": "America/Sao_Paulo",
    "errorWorkflow": "5"
  },
  "createdAt": "2025-11-28T17:05:12.865Z",
  "updatedAt": "2025-11-28T17:05:12.865Z",
  "versionId": "1",
  "meta": {
    "empresa_id": "7761ddfd-0ecc-4a11-95fd-5ee913a6dd17",
    "empresa_codigo": "ARVATE49",
    "persona_id": "20ae86c4-137e-412f-9c35-99fd7ce11ebf",
    "persona_nome": "Richard Garcia",
    "task_id": "a5c1f578-43ae-4176-912c-235519397cf2",
    "task_title": "Atualiza\u00e7\u00e3o di\u00e1ria de fluxo de caixa",
    "opportunity_id": "9b3cfadc-40dd-4b44-bfe1-89635ce48bb2",
    "automation_score": 75,
    "generated_by": "VCM Task-Driven Generator",
    "generated_at": "2025-11-28T17:05:12.865Z"
  }
}

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.

• googleSheetsOAuth2
• slackApi

About this workflow

Richard (Asst Fin) - Atualização diária de fluxo de caixa. Uses googleSheets, slack. Scheduled trigger; 5 nodes.

Source: https://github.com/sergiomvj/vcmdashboard/blob/d041aac2f7d06474262515a2c70c497041c4f9d8/AUTOMACAO/Old_scripts/06_N8N_WORKFLOWS/ARVATE49_Richard_Garcia_Atualizao_diria_de_fluxo_de_caixa.json — original creator credit. Request a take-down →

More Slack & Telegram workflows → · Browse all categories →

Related workflows

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