How ildem96/controle-financeiro-google-sheets works
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 Transaction capture · Controle Financeiro.xlsx Cadastro form
Components 12
Finance workflow
- Cadastro form
Controle Financeiro.xlsx - Transaction capture
controle_financeiro_google_sheets.js - Form clearing
controle_financeiro_google_sheets.js - Auxiliar records
Controle Financeiro.xlsx - Movimentações view
Controle Financeiro.xlsx - Balance report
controle_financeiro_google_sheets.js - Relatório tab
Controle Financeiro.xlsx
Report delivery
- Report generator
Controle Financeiro.xlsx - PDF email sender
controle_financeiro_google_sheets.js - Google Apps Script
Other components
- Spreadsheet user
- Email recipient
Connections 13
- Spreadsheet user → Cadastro form: enters data
README.md - Cadastro form → Transaction capture: submits fields
controle_financeiro_google_sheets.js - Transaction capture → Auxiliar records: writes records
controle_financeiro_google_sheets.js - Transaction capture → Movimentações view: sets formula
controle_financeiro_google_sheets.js - Transaction capture → Form clearing: calls
controle_financeiro_google_sheets.js - Form clearing → Cadastro form: clears fields
controle_financeiro_google_sheets.js - Spreadsheet user → Balance report: runs
- Balance report → Relatório tab: writes balances
controle_financeiro_google_sheets.js - Spreadsheet user → PDF email sender: confirms send
- Report generator → PDF email sender: provides email data
controle_financeiro_google_sheets.js - PDF email sender → Google Apps Script: exports PDF
controle_financeiro_google_sheets.js - PDF email sender → Google Apps Script: sends email
controle_financeiro_google_sheets.js - Google Apps Script → Email recipient: delivers report
README.md