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:

Adafruit MCP2221A Breakout - General Purpose USB to GPIO ADC I2C

PRODUCT ID: 4471
Wouldn't it be cool to drive a tiny OLED display, read a
OUT OF STOCK

Adafruit FT232H Breakout - General Purpose USB to GPIO, SPI, I2C

PRODUCT ID: 2264
Wouldn't it be cool to drive a tiny OLED display, read a
$14.95
IN STOCK

Binho Nova Multi-Protocol USB Host Adapter

PRODUCT ID: 4459
The Binho Nova Multi-Protocol USB Host Adapter allows you to interface your computer directly to hardware circuits. This device is powered...
$149.00
IN 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 May 21, 2020.