Sending data to google sheets using IFTTT

[hannanmustajab]

Hey, I am trying to send data to google sheets using webhook. I have setup an IFTTT particle plugin which receives data from event in JSON format and sends it to the sheets. It is not parsing the JSON, rather adding the whole payload in a cell. It is like,

{"sensorOne": 0.2, "sensorTwo": 0.2, "sensorThree": 0.0, "sensorFour": 0.0, "sensorFive": 0.0}.

I want each of them to be a column and then its data, just like Sensor One | 0.2 and so on.

Can you please suggest how to do it, and if there’s a way to do it without the IFTTT.

Secondly, In the IFTTT plugin we have to select a particular device from which the event is coming, but in my use case there are many devices. How do I address this ?

Last question, My end goal is to create report in google data studio, so is there a better way to get data there apart from Google sheets.

Thanks .

[rickkas7]

I would not use IFTTT to get data into Google sheets, it’s slow and I have found it to be unreliable.

This method is harder to set up initially, but works great:

https://docs.particle.io/datasheets/app-notes/an011-publish-to-google-sheets/

For larger quantities of data than you can reasonably put in a spreadsheet I’d use this technique instead:

https://github.com/rickkas7/google_cloud_tutorial#google-cloud-functions-to-datastore-example

That particular example uses Google Cloud Datastore, which I’m not sure works with Data Studio. However, it’s a minor code change to switch to storing in Google Cloud SQL instead of Google Cloud Datastore, and Cloud SQL is definitely supported by Data Studio.

This is even more work to set up initially, but once you get it working this would be the best way. It’s much more scaleable and once the data is in Cloud SQL you can do all sorts of things with it.

[gusgonnet]

@hannanmustajab

Last question, My end goal is to create report in google data studio, so is there a better way to get data there apart from Google sheets.

Hi,

I could not find Google Firebase as a data source to Data Studio, but maybe you can get inspiration from this Particle-Google integration and from the Pub/Sub send the data to a place/db where Data Studio can pick it up later?
That way you wouldn’t use spreadsheets.