MQTT to Google forms via nodered
Budget: $15 – $25 USD
Hi, I am making a simple nodered flow to publish data via google forms to a google sheet. I have attached a project document with concrete examples. I will also have a live broker with contiuous messages to program while doing on real data as I think that is needed.
Basically, I am trying to do the following : https://www.hackster.io/harit-shah/node-red-mqtt-with-google-sheets-ab1aa7
Parsing the message is done in nodered. I like nodered for its visual programming for data flows, especially live data flows.
I am thinking a prototype could be built in approx 5 hours. After this prottype I will have another 8 hours for optimisation inside google sheets by adding pivot tables and simple filter functions.. If this is successfull I have more work.
we could also use this flow: https://flows.nodered.org/flow/a36ccbcfc43c264cda892383fe034fe3
Basically, I am trying to do the following : https://www.hackster.io/harit-shah/node-red-mqtt-with-google-sheets-ab1aa7
Parsing the message is done in nodered. I like nodered for its visual programming for data flows, especially live data flows.
I am thinking a prototype could be built in approx 5 hours. After this prottype I will have another 8 hours for optimisation inside google sheets by adding pivot tables and simple filter functions.. If this is successfull I have more work.
we could also use this flow: https://flows.nodered.org/flow/a36ccbcfc43c264cda892383fe034fe3