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 connected to a computer with an IMU sensor that is streaming data to some graphing program
Wouldn't it be cool to drive a tiny OLED display, read a
$6.50
In Stock
Angled shot of a Adafruit FT232H Breakout - General Purpose USB to GPIO, SPI, I2C - USB C & Stemma QT.
Wouldn't it be cool to drive a tiny OLED display, read a
$14.95
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 Dec 20, 2019.

Text editor powered by tinymce.