Post Data to Google Sheets Particel


#1

Hello,
I read the few posts on sending data to google sheets using IFTTT. I used to publish my data from Particle in json format using a webhook. Now that I found Losant I love the graphing functions but need more of the google sheets options for my data.

Currently, my data is being sent to Losant as a string. See the example below. How do I convert this data and send it to my sheets? I have tried a few different things but still not getting the data over.

Thank you

Device State Pic

Google Sheets Header Pic

I tried a HTTP output but was not able to get it to work for me.
HTTP Pic

Any help would really be appreciated.

Thank you very much and Happy Thanksgiving.


#2

We looked into adding Google Sheets workflow nodes in the past, but for any operation other than reading from a public spreadsheet, the user must provide a token obtained through Google’s OAuth 2.0 authorization flow, which is something we can’t replicate within the workflow engine as it requires user action.

You could use the server-to-server authentication method outlined here but it’s quite a bit involved, and it requires you having a G Suite account and doing a lot of setup on the Google side.

You could then take the token generated through this process and use the HTTP Node to make requests against the Google Sheets API.

If that’s not an option, you can also use Losant’s data tables feature to store additional data within your application. Tables are subject to some pretty strict limits in a sandbox environment, so you would have to move your application to a paid organization plan to do anything production-ready within them.

Let us know if you pursue the Google Sheets option and if it’s a smooth process! We’d love to hear if it’s something our users can easily accomplish.


#3

Thank you Dylan,
I will look at both options and see if I can figure it out. We do have G Suite so that may be an option. I do have a call into sales as well.

In the meantime, I will just need to keep sending my data to google sheets via webhook on particle then try and decode the JSON on Losant end to get the super pretty display. The amount of data I am saving is too large for the Losant data tables (after 30 days or so).

It’s kind of maddening as I can send my data to losant in a string and view the data perfectly, but can’t send the same string to a webhook to google sheets. But I can send a json string to google but can’t’ decode it on Losant. :joy:

I am going to eventually figure this out even if it takes me a whole bottle of Gin. :slight_smile:

I found a post here but failed to implement the JSON decoder. Something off with my Json.

Thank you for taking the time to reply.