Google Sheets Tutorial for Sports Science: Link Google Forms to Google Sheets
For more tutorials, go here:
This is a video designed for sports scientists, sport and strength coaches, and other practitioners working in sport on how to get the most out of Google Sheets for sports science and performance.
We review how to create a robust system for data collection and visualization by:
1) Create a Google Form to collect data
2) Link the Google Form to Google Sheets to organize the data
3) Create an interactive dashboard in Google Sheets to display the data
*KEY NOTE: If you are performing calculations from your response data, make sure that you do it in another sheet!*
0:30 - Create a survey/questionnaire in Google Forms
2:00 - How to get Google Forms data into Google Sheets
4:20 - Key considerations when linking Forms to Sheets
9:20 - Set up an interactive dashboard in Google Sheets
22:00 - Create visualizations for the dashboard
26:00 - Make the dashboard organized and visually appealing