Tracks activities of a baby from Raspberry Pi Pico W to Google Sheets using micropython.
DIY version of Talli Baby Tracker
- Raspberry Pi Pico W
- Google App Credentials
- Some buttons/input devices
- Internet connection
- On local machine install Thonny
pip install thonny
- On Raspberry Pi Pico W install micropython
- Start thonny from terminal
- Copy code from this repository into directory.
- Run
google/generateRefreshToken.py
on the pico and copy the returned temporary token into secrets.py
- Setup to write to the worksheet set in secrets.py
- Change individual sheet names in main.py lines 61-70
- Change pins used on Pico in main.py line 56
- Supports as many pins as you'd like, only 8 are used by default: pins 14-23
- To save processing potentially large columns, store
=COUNTA(A:A)
in a specific cell of your sheet, and point to it in main.py line 34