Hi, currently im doing some flow about key in some data inside the google sheet, and then the data will be fetch by using the google sheet nodes that i downloaded at node-red-contrib-google-sheets (node) - Node-RED . When i connect the Gsheet node to the ui_table, the data is showing but not in correct way
and then i try to create the header by myself at the ui_table setting but the data are not showing. can someone help me with this?
this is my flows
[{"id":"e4159a13.791338","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"1efed70a.0c6119","type":"ui_table","z":"e4159a13.791338","group":"e6008272.0a9e4","name":"","order":1,"width":13,"height":5,"columns":[{"field":"","title":"Period","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"","title":"Plan Qty","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"","title":"Actual Qty","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"","title":"Comments","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":770,"y":200,"wires":[]},{"id":"c9f665a3.4d8808","type":"inject","z":"e4159a13.791338","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"6000","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":280,"y":200,"wires":[["57af8e99.e6b3b"]]},{"id":"57af8e99.e6b3b","type":"GSheet","z":"e4159a13.791338","creds":"599d225a.93c68c","method":"get","action":"","sheet":"1f8CQvh1knhDiBr04zCJbCygXzfBXzM0cGQqfy3hf5Iw","cells":"[NON-PUASA] MONDAY-THURSDAY & SATURDAY SCHEDULE!D8:H14","flatten":false,"name":"","x":480,"y":200,"wires":[["b267354c.409008","1efed70a.0c6119"]]},{"id":"b267354c.409008","type":"debug","z":"e4159a13.791338","name":"","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload","statusType":"auto","x":790,"y":240,"wires":[]},{"id":"e6008272.0a9e4","type":"ui_group","name":"Production blabla","tab":"527d72c0.8806ec","order":1,"disp":true,"width":"13","collapse":false},{"id":"599d225a.93c68c","type":"gauth"},{"id":"527d72c0.8806ec","type":"ui_tab","name":"Test","icon":"dashboard","disabled":false,"hidden":false}]