“The ESP8266 is a low-cost Wi-Fi microchip, with built-in TCP/IP networking software, and microcontroller capability” - Wikipedia.
I bought sensors and wrote a small program on the ESP8266 that would read the values of the sensor and then hit an If This Then That (IFTTT) Webhook. The Webhook was tied to an IFTTT automation that would take the values sent to the Webhook and append them to an existing Google Sheet.
With a few variable changes, this program was able to be used for any sensor project that used an ESP8266. This allows me to very quickly be able to start new projects and start collecting data.
Sorting the Data in the Google Sheet
Making the Data Accessible to other Projects
As I mentioned above, one of the main problems I was trying to solve with this project was re-writing code every time I had a project idea involving sensors. In the past, every time I had a project it would get its own unique Google Sheet that would house the data. But with this project, I have one centralized Sheet that houses all the data, and the way my projects can access this data is via a Web App.
To access the data, you would need the Web App URL and then attach a series of query parameters to the end of the URL (see below). You could then use a GET request from any program to get the data you want, if it exists and if you have a unique key.
The data would come back as an array of JSON objects, and I would have to create a small script to parse out the specific data that I needed for each project.