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:

Wouldn't it be cool to drive a tiny OLED display, read a
In Stock
Wouldn't it be cool to drive a tiny OLED display, read a
Out of Stock
The Binho Nova Multi-Protocol USB Host Adapter allows you to interface your computer directly to hardware circuits. This device is powered...
Out of Stock

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...

This guide was first published on Jan 17, 2020. It was last updated on Jan 17, 2020.

This page (Overview) was last updated on Apr 15, 2022.

Text editor powered by tinymce.