This guide will show you how you may log data from an I2C or SPI based sensor to a Google Sheet, directly from your PC, using Python.
No microcontrollers are required - we read data directly into a computer!
To enable reading I2C or SPI based sensors from your PC, we'll use a special USB bridge device. There are several options:
And then we can install Blinka to allow us to use CircuitPython libraries to make using the sensor easy.
There's a fair amount of initial software setup that must be done, most of which is for setting up services and credentials on Google. But once everything is in place, sending sensor data to a Google Sheet is really easy.
Let's get started...