Survey to spreadsheet sync
A scheduled job that splits thousands of survey responses into the right spreadsheets every morning, replacing a manual process that took weeks.
- Client
- Berkshire Soccer Academy, via TheCampStack
- My role
- Integration developer
- When
- 2024 to 2025
The academy runs a survey after each of its nine sessions a year and collects several thousand responses. Staff then split one giant survey export into separate spreadsheets by hand, which took weeks.
I built a scheduled Lambda that syncs the survey data and splits it into the correct spreadsheets every morning. Manual handling went to zero. The job is covered by end-to-end tests.