Data Domoticz -> Google Spreadsheet (sheets)

[coen17st]

Hi,

Does anyone know if there is an easy way to send data from Domoticz to a Google Spreadsheet? I have tried the standard =IMPORT functions in Google Sheets but unfortunately that does not work.

I am a beginner in scripting so hopefully there is an easy way or good step by step guide. anyone already doing this?

[HFman]

Also intrested in this.. did you find a way ?

[FireWizard]

Hi,

I don't know if you have MQTT and Node Red installed? If so, publish the data with MQTT to your MQTT broker (Mosquitto) and subscribe to the topics with Node Red and from there you can use a node to export to Google Sheets.
See:
https://flows.nodered.org/node/node-red ... preadsheet

Regards

[HFman]

Yes ! that is a good one ! I will try this, Thanks !

[salvacalatayud]

Hi,

I don't know if you have MQTT and Node Red installed? If so, publish the data with MQTT to your MQTT broker (Mosquitto) and subscribe to the topics with Node Red and from there you can use a node to export to Google Sheets.
See:
https://flows.nodered.org/node/node-red ... preadsheet

Regards

Can you share an example flow?

Enviado desde mi SM-N975F mediante Tapatalk

[FireWizard]

HI, @salvacalatayud,

I do not use Gsheets. I have tested it and I have an account.
After a long period I found it still works.

My question is:

1. How far are you?
- Have you created a Google Service Account?
If not, go to https://flows.nodered.org/node/node-red ... gle-sheets

Follow the guideline described above and create a Project.
Fill your Gsheets with some data.

In my example I used IFTTT to send the inbound, outbound and missed calls from my mobile phone to Gsheets.
(I do not know how long this will continue to work, as IFTTT has become a paid service).

If everything is correctly configured you are able to get the data from Gsheets with the node-red-contrib-google-sheets node.

You have to use an Inject node connected to the Gsheets node in order to start the request.

Screenshot_Gsheets1.png (7.38 KiB) Viewed 1242 times

If you have connected a Debug node, you will see the Cell data in an array

Screenshot_Gsheets2.png (11.34 KiB) Viewed 1242 times

In this case, I have only collected the data from Sheet1 and the cells A1 - F1, which is the header.
You van request more data or write data.

2.
So the question is, what is the type of data and what do you want to do with that data?

I'm happy to support you in developing your flow.

Regards