Ingest and audit a new survey export
Run this when a new survey export lands in Google Sheets. Audit completeness and quality before any analysis begins, so cleaning decisions are documented and intentional.
- Confirm the survey's purpose with the user: what business question was this survey designed to answer?
- Open the Google Sheets export.
- Check for structural issues: merged cells, extra header rows, columns with no header, or columns that appear to be system artifacts (submission ID, IP address, timestamp).