MIDA / DATA CONNECTIONS
Google Sheets
Bring structured spreadsheet inputs into a repeatable report.
How the connection can work
Start with a CSV export. A recurring API connection uses a separately configured Google authorization flow and agreed spreadsheet ranges.
Access requirements
The spreadsheet owner approves access. Read-only permissions are preferred for reporting; access must match the files and purpose in scope.
BEFORE A CONNECTION GOES LIVE
- Keep a stable header row and one record per row.
- Avoid merged cells and mixed currencies in an amount column.
- Agree how manual edits and newly added rows are detected.
From access to a checked report
Assess
Confirm the account, reporting question, data coverage and approved access.
Map
Define identifiers, statuses, dates and calculation rules for the report.
Verify
Reconcile records and totals before establishing a recurring update.