# ildem96/controle-financeiro-google-sheets architecture

> Architecture diagram of the GitHub repository ildem96/controle-financeiro-google-sheets, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-17). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ildem96/controle-financeiro-google-sheets
- Repository: https://github.com/ildem96/controle-financeiro-google-sheets

## Overview

This is a small Google Apps Script spreadsheet workflow: the user enters a transaction in the Cadastro tab, `cadastrar()` records it in Auxiliar and invokes form clearing; the workbook’s Movimentações and Relatório tabs organize and calculate balances, and `enviar()` confirms, exports a PDF, and emails it. The README also names the spreadsheet areas, but their formulas and wiring are not shown in the sampled source, so those relationships are omitted. The single script excerpt supports the shown calls; the workbook itself is documented but not inspected.

Main entry points: [`controle_financeiro_google_sheets.js`](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js) (Transaction capture), [`Controle Financeiro.xlsx`](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx) (Cadastro form)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_workflow["Finance workflow"]
  node_form["Cadastro form"]
  node_entry["Transaction capture"]
  node_clear["Form clearing"]
  node_storage[("Auxiliar records")]
  node_movements["Movimentações view"]
  node_report["Balance report"]
  node_reporttab["Relatório tab"]
end

subgraph group_delivery["Report delivery"]
  node_generator["Report generator"]
  node_send["PDF email sender"]
  node_google{{"Google Apps Script"}}
end

node_user(("Spreadsheet user"))
node_email(("Email recipient"))

node_user -->|"enters data"| node_form
node_form -->|"submits fields"| node_entry
node_entry -->|"writes records"| node_storage
node_entry -->|"sets formula"| node_movements
node_entry -->|"calls"| node_clear
node_clear -->|"clears fields"| node_form
node_user -.->|"runs"| node_report
node_report -->|"writes balances"| node_reporttab
node_user -.->|"confirms send"| node_send
node_generator -->|"provides email data"| node_send
node_send -->|"exports PDF"| node_google
node_send -->|"sends email"| node_google
node_google -->|"delivers report"| node_email

click node_form "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx"
click node_entry "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js"
click node_clear "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js"
click node_storage "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx"
click node_movements "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx"
click node_report "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js"
click node_reporttab "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx"
click node_generator "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx"
click node_send "https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_form,node_entry,node_clear,node_storage,node_movements,node_report,node_reporttab,node_user toneBlue
class node_generator,node_send,node_google toneAmber
class node_email toneIndigo
```

## Components

### Finance workflow

- [Cadastro form](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx): `Controle Financeiro.xlsx`
- [Transaction capture](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js): `controle_financeiro_google_sheets.js`
- [Form clearing](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js): `controle_financeiro_google_sheets.js`
- [Auxiliar records](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx): `Controle Financeiro.xlsx`
- [Movimentações view](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx): `Controle Financeiro.xlsx`
- [Balance report](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js): `controle_financeiro_google_sheets.js`
- [Relatório tab](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx): `Controle Financeiro.xlsx`

### Report delivery

- [Report generator](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/Controle%20Financeiro.xlsx): `Controle Financeiro.xlsx`
- [PDF email sender](https://github.com/ildem96/controle-financeiro-google-sheets/blob/main/controle_financeiro_google_sheets.js): `controle_financeiro_google_sheets.js`
- **Google Apps Script**

### Other components

- **Spreadsheet user**
- **Email recipient**

## Connections

- Spreadsheet user → Cadastro form: enters data (evidence: `README.md`)
- Cadastro form → Transaction capture: submits fields (evidence: `controle_financeiro_google_sheets.js`)
- Transaction capture → Auxiliar records: writes records (evidence: `controle_financeiro_google_sheets.js`)
- Transaction capture → Movimentações view: sets formula (evidence: `controle_financeiro_google_sheets.js`)
- Transaction capture → Form clearing: calls (evidence: `controle_financeiro_google_sheets.js`)
- Form clearing → Cadastro form: clears fields (evidence: `controle_financeiro_google_sheets.js`)
- Spreadsheet user → Balance report: runs
- Balance report → Relatório tab: writes balances (evidence: `controle_financeiro_google_sheets.js`)
- Spreadsheet user → PDF email sender: confirms send
- Report generator → PDF email sender: provides email data (evidence: `controle_financeiro_google_sheets.js`)
- PDF email sender → Google Apps Script: exports PDF (evidence: `controle_financeiro_google_sheets.js`)
- PDF email sender → Google Apps Script: sends email (evidence: `controle_financeiro_google_sheets.js`)
- Google Apps Script → Email recipient: delivers report (evidence: `README.md`)
