How gustavomatoi/automa-o-python-e-gs works
This repository generates school-feedback reports from a selected CSV, uploads report tabs to Google Sheets, and includes separate Apps Script utilities for formula execution and dashboard refresh. The principal workflow runs from the desktop UI through report generation to Sheets upload. Report categories are implemented within the large reporting module; the excerpts do not establish all individual report stages or the CSVs each stage reads. The Apps Script files are standalone utilities, so their invocation relationship to the desktop app is not shown.
Main entry points: atualizarDash.js Dashboard refresh · gerarLinks.js Dashboard refresh copy · main.py Desktop workflow · relatorios.py Report generation
Components 12
Report application
- Desktop workflow
main.py - Report sheet upload
main.py
Report processing
- Report generation
relatorios.py - Selected CSV
Sheets utilities
- Formula endpoint
appscritps/executarFormulas.js - Formula execution
appscritps/executarFormulas.js - Dashboard refresh
appscritps/atualizarDash.js - Dashboard refresh copy
appscritps/gerarLinks.js
External services
- Google Sheets
- Google Drive
- Email service
Other components
- Report operator
Connections 13
- Report operator → Desktop workflow: selects and starts
main.py - Desktop workflow → Report generation: generates reports
main.py - Report generation → Selected CSV: reads input
- Desktop workflow → Report sheet upload: uploads reports
main.py - Report sheet upload → Google Sheets: writes tabs
main.py - Formula endpoint → Formula execution: dispatches
appscritps/executarFormulas.js - Formula execution → Google Sheets: sets formulas
appscritps/executarFormulas.js - Dashboard refresh → Google Sheets: replaces dashboards
appscritps/atualizarDash.js - Dashboard refresh → Google Drive: stages spreadsheet copy
appscritps/atualizarDash.js - Dashboard refresh → Email service: emails analyst
appscritps/atualizarDash.js - Dashboard refresh copy → Google Sheets: replaces dashboards
appscritps/gerarLinks.js - Dashboard refresh copy → Google Drive: stages spreadsheet copy
appscritps/gerarLinks.js - Dashboard refresh copy → Email service: emails analyst
appscritps/gerarLinks.js