# Google spreadsheet to ui\_table

**URL:** <https://discourse.nodered.org/t/google-spreadsheet-to-ui-table/50698>\
**Category:** General\
**Created:** [7 September 2021 07:28 UTC](https://discourse.nodered.org/t/google-spreadsheet-to-ui-table/50698 "2021-09-07T07:28:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![xpqrs97](https://avatars.discourse-cdn.com/v4/letter/x/f4b2a3/32.png) [@xpqrs97](https://discourse.nodered.org/u/xpqrs97)\
**Post date:** [7 September 2021 07:28 UTC](https://discourse.nodered.org/t/google-spreadsheet-to-ui-table/50698/1 "2021-09-07T07:28:42Z")

</div>

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](https://flows.nodered.org/node/node-red-contrib-google-sheets) . When i connect the Gsheet node to the ui\_table, the data is showing but not in correct way

![1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/f/ffe2a0dcbeba58ae28ea3e3d833e79e22377e594.png)

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?

![2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/2/5234664407ef461b266278fa5c108d2f172b985d.png)

this is my flows

```auto
[{"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}]

```

---

<div class="post-metadata">

**Author:** ![xpqrs97](https://avatars.discourse-cdn.com/v4/letter/x/f4b2a3/32.png) [@xpqrs97](https://discourse.nodered.org/u/xpqrs97)\
**Post date:** [8 September 2021 01:17 UTC](https://discourse.nodered.org/t/google-spreadsheet-to-ui-table/50698/2 "2021-09-08T01:17:23Z")

</div>

Converted to array of objects and it works fine.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [22 September 2021 01:17 UTC](https://discourse.nodered.org/t/google-spreadsheet-to-ui-table/50698/3 "2021-09-22T01:17:57Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.