Using a Python script to upload data online to a Google spreadsheet interface

Creating CSV is great; you can pretty much import that into any spreadsheet or database. What if you just want to skip that step and push your Raspberry Pi Zero data directly to Google spreadsheets? With Google's API and Python libraries, you can securely send your data to a spreadsheet in your Google account.

Getting ready

If you don't have a Google account, you will definitely need one for this recipe. The Google Developer documentation for Getting Started will have the most up-to-date instructions on setting up your application for authentication, but we will skip through it here. You can always refer to https://developers.google.com/api-client-library/python/start/get_started ...

Get Raspberry Pi Zero Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.