# How to make entries in different columns of googlesheeet

**URL:** <https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422>\
**Category:** General\
**Tags:** http-request, database, function-node\
**Created:** [19 December 2022 14:16 UTC](https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422 "2022-12-19T14:16:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nit-cyber](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nit-cyber/32/72630_2.png) [@nit-cyber](https://discourse.nodered.org/u/nit-cyber)\
**Post date:** [19 December 2022 14:16 UTC](https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422/1 "2022-12-19T14:16:49Z")

</div>

> **[node-red-contrib-google-sheets](https://flows.nodered.org/node/node-red-contrib-google-sheets)**
>
> nodered node to get, update, append, and clear google sheets.

using this node and want to pop-up data from different payloads to different columns in googlesheet  
Anyone please suggest the solution

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [20 December 2022 09:57 UTC](https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422/2 "2022-12-20T09:57:20Z")

</div>

It is explained in the built in help of that node.

The node also has built in examples (use `CTRL-I` in node-red to view and import examples)

---

<div class="post-metadata">

**Author:** ![nit-cyber](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nit-cyber/32/72630_2.png) [@nit-cyber](https://discourse.nodered.org/u/nit-cyber)\
**Post date:** [20 December 2022 11:25 UTC](https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422/3 "2022-12-20T11:25:59Z")

</div>

yes I used it like for columns A1:A30 , B1:B30 and so on and i want to fill it with different payloads but they are not working simultaneously and gives shift after each pop-up.

also if i want to insert a row automatically in googlesheet is there any way

---

<div class="post-metadata">

**Author:** ![nit-cyber](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nit-cyber/32/72630_2.png) [@nit-cyber](https://discourse.nodered.org/u/nit-cyber)\
**Post date:** [21 December 2022 11:20 UTC](https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422/4 "2022-12-21T11:20:19Z")

</div>

please see to the issue

---

<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:** [19 February 2023 11:21 UTC](https://discourse.nodered.org/t/how-to-make-entries-in-different-columns-of-googlesheeet/72422/5 "2023-02-19T11:21:16Z")

</div>

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