# Adding row cells to google sheets

**URL:** <https://community.glideapps.com/t/adding-row-cells-to-google-sheets/42665>\
**Category:** Ask for Help\
**Created:** [June 2, 2022, 3:57pm UTC](https://community.glideapps.com/t/adding-row-cells-to-google-sheets/42665 "2022-06-02T15:57:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KenApp](https://avatars.discourse-cdn.com/v4/letter/k/57b2e6/32.png) [@KenApp](https://community.glideapps.com/u/KenApp)\
**Post date:** [June 2, 2022, 3:57pm UTC](https://community.glideapps.com/t/adding-row-cells-to-google-sheets/42665/1 "2022-06-02T15:57:49Z")

</div>

Hi guys, I’m using make/integromat to add data to a specific cell in a google sheet. What I’m hoping to achieve is to pass a data set that populates 1 cell per row (B2, B3, B4, B5, B6 etc). I’m passing a list of values delimited by a carriage return but its populating the full list in a single cell. I’m sure theres a really simple solution to this that I’m overlooking but I cant seem to get it.

\*\* I can create a CSV no issue and the carriage return will separate out the values into the cell below but it doesnt work the same way when I use the “update cell” function in make

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 2, 2022, 11:55pm UTC](https://community.glideapps.com/t/adding-row-cells-to-google-sheets/42665/2 "2022-06-02T23:55:12Z")

</div>

Are those rows that are consecutive? If you plan to add it to row 2, row 3, row 4, row 5, row 6 etc I think you can work with something like this:

- Set variable: Set a “counter” variable to 2.

Then it starts the iteration from here.

- Iterator: Iterate through a split of your “list of values” (so that it will be an array).

- Get variable: Get the value of the “counter” variable.

- Update row: Update the corresponding row using the “counter” variable you just get.

- Set variable: Set the value of the “counter” variable to the sum of the value you get 2 steps back and 1 (so it starts the next iteration accordingly).

---

<div class="post-metadata">

**Author:** ![KenApp](https://avatars.discourse-cdn.com/v4/letter/k/57b2e6/32.png) [@KenApp](https://community.glideapps.com/u/KenApp)\
**Post date:** [June 3, 2022, 4:56am UTC](https://community.glideapps.com/t/adding-row-cells-to-google-sheets/42665/3 "2022-06-03T04:56:34Z")

</div>

Thank you. Appreciate you taking the time to explain.

I had hoped there was an easier solution that I was overlooking. Thank you!