Tools for makers · Cloud and apps
Google Sheets
Log your sensor readings into a spreadsheet with a few lines of Apps Script, then chart and analyse them like a scientist.
- 4 lessons
What it is for
With a short Google Apps Script, a spreadsheet can receive data from your ESP32. Each reading arrives as a new row with the date and time, and you can turn the columns into charts, averages and tables.
Spreadsheets are where data analysis starts at school and at work, so this is a great way to connect your electronics to maths and science lessons.
You need a free Google account; under-13s can ask a parent or teacher.
Tips
- Protect your script with a secret key, so only your device can add rows.
- After changing the script, deploy a new version.
- Use =AVERAGE(), =MAX() and =MIN() on a column for instant statistics.
