Recently I had a request from a customer to monitor some data and log that data for graphing. I thought, hey this sounds like a fantastic use case for the Google Cloud Platform webhook integration. I want to log this data to a Google Sheet which should be Childs play once the data is on Google Cloud. I had never used it before so I dug in.
I set my firmware up to publish 3 different events for different data that needs to be logged. Then I started working through the Google Cloud Platform tutorial. I setup the Webhooks, Topics and subscriptions and they are all working correctly(tested using the console on the Google Cloud Platform site). So far so good.
It was nearing the end of the day and I got to the end of the tutorial where it starts talking about where to go once you have all that information on the Google Cloud. Now I thought(incorrectly apparently) that once the data was on Google Cloud it would be just a hop, skip, and jump to log that data to a Google Sheet, I mean surely that’s the case right? Wrong, I then had to run my own code on my computer or another server to take the data off Google Cloud and do something with it. Am I nuts? Shouldn’t it be EXTREMELY easy to just take that data from the subscriptions on the Google Cloud and throw it right into a Google Sheet? I mean seriously? There’s no need for a third party server to do this if it’s all on Google. Am I missing something? Is this possible or do I seriously need a server script on another server OAuthed to Google to pull data from one section of Google(Google Cloud) and then put it on another section of Google(Google Sheets)?