Sending Raspberry Pi data to Google Sheets for the Low Code people — the easy way

Greg Vonf @ Business Automated
7 min readApr 5, 2020

How a single line of Python code and Integromat can substitute this whole AWS IoT Core / Azure IoT Hub nightmare…

Wondering how to get out data from your Raspberry Pi — the real easy way?
Photo by Louis Reed on Unsplash

I consider myself reasonably tech-savvy. Bwah, I would say, I really like computers and tinkering with technology. However, my background was purely commercial and until last year I have never touched a line of code.

Out of nowhere a few months ago, as a newly born tech entrepreneur (adding “tech” gives the title far more flair), I was all of a sudden facing a new scenario. I needed to send data from my edge device (another “edgy” word that likes to be sprinkled with crumbles of “IoT” for more flavor) to… hmm, to the cloud, I guess?

How difficult can it be to send sensor data from Raspberry Pi to somewhere in the cloud? Should I hire an IoT consultant (likely expensive) or give it a go myself? What followed after was a 3-month long exploration of AWS / Azure and IoT solutions offered by these providers. In the end I have built a working solution with Azure, only to find out afterward, that it was a giant overkill. There was a much simpler and faster way of achieving the same objective.

The hard way

AWS

--

--

Greg Vonf @ Business Automated

Greg is the founder of Business Automated, an agency helping small businesses streamline and simplify their processes. For more visit www.business-automated.com