send data to google sheet

This program consists of the following features:

1. Generating random values between 0 and 100, three times.
2. Storing the generated values into the global context and displaying them on the dashboard.
3. Every 5 seconds, retrieving the current date along with values from the global context to format for sending to Google Sheets.
4. Sending the formatted values to Google Sheets.

contact me or follow me : https://www.facebook.com/profile.php?id=61550015338310

Copy[{"id":"922c2433e8fa39fb","type":"group","z":"2f030861db17b313","name":"1","style":{"label":true},"nodes":["aefc663199c37a09","b4ad5f3f784b072d","8467219dfaba5669","aafa278a56de2cab"],"x":54,"y":59,"w":432,"h":202},{"id":"aefc663199c37a09","type":"function","z":"2f030861db17b313","g":"922c2433e8fa39fb","name":"data random 1","func":"let data = Math.floor(Math.random() * 100);\nlet name = \"data_random_1\"\nglobal.set(name,data)\nmsg.payload = data\nmsg.topic = name\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":380,"y":100,"wires":[["6e2c96e4f24a3011","e5621833cddfa48f","23380052cb9d99f5"]]},{"id":"b4ad5f3f784b072d","type":"inject","z":"2f030861db17b313","g":"922c2433e8fa39fb","name":"","props":[{"p":"payload"}],"repeat":"10","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":170,"y":100,"wires":[["aefc663199c37a09","8467219dfaba5669","aafa278a56de2cab"]]},{"id":"8467219dfaba5669","type":"function","z":"2f030861db17b313","g":"922c2433e8fa39fb","name":"data random 2","func":"let data = Math.floor(Math.random() * 100);\nlet name = \"data_random_2\"\nglobal.set(name, data)\nmsg.payload = data\nmsg.topic = name\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":380,"y":160,"wires":[["35fee838146ca9da","c8e43016ecdad323","3accd5fc02f74143"]]},{"id":"aafa278a56de2cab","type":"function","z":"2f030861db17b313","g":"922c2433e8fa39fb","name":"data random 3","func":"let data = Math.floor(Math.random() * 100);\nlet name = \"data_random_3\"\nglobal.set(name, data)\nmsg.payload = data\nmsg.topic = name\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":380,"y":220,"wires":[["774e145cc99dcf38","1d65c6b8ad8937be","5cd725f2827614d0"]]},{"id":"2a183ba4827e8a6b","type":"group","z":"2f030861db17b313","name":"2","style":{"label":true},"nodes":["6e2c96e4f24a3011","35fee838146ca9da","774e145cc99dcf38","e5621833cddfa48f","c8e43016ecdad323","1d65c6b8ad8937be","23380052cb9d99f5","3accd5fc02f74143","5cd725f2827614d0"],"x":514,"y":59,"w":492,"h":202},{"id":"6e2c96e4f24a3011","type":"debug","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"debug 1","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":600,"y":100,"wires":[]},{"id":"35fee838146ca9da","type":"debug","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"debug 2","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":600,"y":160,"wires":[]},{"id":"774e145cc99dcf38","type":"debug","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"debug 3","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":600,"y":220,"wires":[]},{"id":"e5621833cddfa48f","type":"ui_gauge","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"g1","group":"3d0365b79c006e12","order":1,"width":0,"height":0,"gtype":"gage","title":"{{msg.topic}}","label":"%","format":"{{value}}","min":0,"max":"100","colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","diff":false,"className":"","x":770,"y":100,"wires":[]},{"id":"c8e43016ecdad323","type":"ui_gauge","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"g2","group":"3d0365b79c006e12","order":2,"width":0,"height":0,"gtype":"gage","title":"{{msg.topic}}","label":"%","format":"{{value}}","min":0,"max":"100","colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","diff":false,"className":"","x":770,"y":160,"wires":[]},{"id":"1d65c6b8ad8937be","type":"ui_gauge","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"g3","group":"3d0365b79c006e12","order":3,"width":0,"height":0,"gtype":"gage","title":"{{msg.topic}}","label":"%","format":"{{value}}","min":0,"max":"100","colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","diff":false,"className":"","x":770,"y":220,"wires":[]},{"id":"23380052cb9d99f5","type":"ui_chart","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"c1","group":"4506087c088db452","order":3,"width":"15","height":"4","label":"{{msg.topic}}","chartType":"line","legend":"false","xformat":"HH:mm","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"30","removeOlderPoints":"","removeOlderUnit":"60","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"className":"","x":930,"y":100,"wires":[[]]},{"id":"3accd5fc02f74143","type":"ui_chart","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"c2","group":"4506087c088db452","order":3,"width":"15","height":"4","label":"{{msg.topic}}","chartType":"line","legend":"false","xformat":"HH:mm","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"30","removeOlderPoints":"","removeOlderUnit":"60","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"className":"","x":930,"y":160,"wires":[[]]},{"id":"5cd725f2827614d0","type":"ui_chart","z":"2f030861db17b313","g":"2a183ba4827e8a6b","name":"c3","group":"4506087c088db452","order":3,"width":"15","height":"4","label":"{{msg.topic}}","chartType":"line","legend":"false","xformat":"HH:mm","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":"30","removeOlderPoints":"","removeOlderUnit":"60","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"className":"","x":930,"y":220,"wires":[[]]},{"id":"3d0365b79c006e12","type":"ui_group","name":"Gauge","tab":"269f54e309cbe158","order":1,"disp":true,"width":"6","collapse":false,"className":""},{"id":"4506087c088db452","type":"ui_group","name":"Trendx","tab":"269f54e309cbe158","order":2,"disp":true,"width":"15","collapse":false,"className":""},{"id":"269f54e309cbe158","type":"ui_tab","name":"Home","icon":"dashboard","disabled":false,"hidden":false},{"id":"8562e75717463975","type":"group","z":"2f030861db17b313","name":"3","style":{"label":true},"nodes":["60459f96a01b7580","cb00e6632cae22d3","d0df5069aded39ac"],"x":114,"y":319,"w":352,"h":122},{"id":"60459f96a01b7580","type":"function","z":"2f030861db17b313","g":"8562e75717463975","name":"get data","func":"let gettime = new moment()\nlet timelocal = gettime.tz('Asia/Bangkok').format(\"YYYY-MM-DD HH:mm:ss\")\n\nlet data1 = global.get(\"data_random_1\")\nlet data2 = global.get(\"data_random_2\")\nlet data3 = global.get(\"data_random_3\")\n\nmsg.payload = [timelocal, data1, data2, data3]\nmsg.cells = \"Sheet1!A2:D2\"\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[{"var":"moment","module":"moment"},{"var":"momentTimezone","module":"moment-timezone"}],"x":360,"y":360,"wires":[["cb00e6632cae22d3","9ee49239.e1f2"]]},{"id":"cb00e6632cae22d3","type":"debug","z":"2f030861db17b313","g":"8562e75717463975","name":"debug 4","active":false,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"","statusType":"counter","x":360,"y":400,"wires":[]},{"id":"d0df5069aded39ac","type":"interval-multiples-timer","z":"2f030861db17b313","g":"8562e75717463975","interval":5000,"payload":"","topic":"","name":"5 sec","x":190,"y":360,"wires":[["60459f96a01b7580"]]},{"id":"a9a746ebd132301c","type":"group","z":"2f030861db17b313","name":"4","style":{"label":true},"nodes":["9ee49239.e1f2","dd5ab1222b7e28b9"],"x":514,"y":319,"w":392,"h":82},{"id":"9ee49239.e1f2","type":"GSheet","z":"2f030861db17b313","g":"a9a746ebd132301c","creds":"f2646a79f2458d4f","method":"append","action":"","sheet":"1axA9MhekH_dAizM9xyZMWi8CJ5oPCBRFAH4YLgTvM5Q","cells":"","flatten":false,"name":"","x":630,"y":360,"wires":[["dd5ab1222b7e28b9"]]},{"id":"dd5ab1222b7e28b9","type":"debug","z":"2f030861db17b313","g":"a9a746ebd132301c","name":"","active":false,"tosidebar":true,"console":false,"tostatus":true,"complete":"true","targetType":"full","statusVal":"","statusType":"counter","x":810,"y":360,"wires":[]},{"id":"f2646a79f2458d4f","type":"gauth","name":"[email protected]"}]