# Updating Google Sheet after identifying the unique row and cell location

**URL:** <https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227>\
**Category:** Questions about Thunkable X\
**Tags:** help\
**Created:** [December 31, 2023, 3:56am UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227 "2023-12-31T03:56:30Z")\
**Posts on this page:** 8\
**Page:** 2

<div class="post-metadata">

**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\
**Post date:** [January 8, 2024, 7:48pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/21 "2024-01-08T19:48:46Z")

</div>

Thanks for all the assistance

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [January 8, 2024, 8:34pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/22 "2024-01-08T20:34:55Z")

</div>

You can get the row id from the data viewer list click event and then use that with the blocks you have in your screenshot to get the subtitle’s text from that row id.

See this example that is related: [Data list viewer item click change data source - #7 by tatiang](https://community.thunkable.com/t/data-list-viewer-item-click-change-data-source/1802762/7)

---

<div class="post-metadata">

**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\
**Post date:** [January 8, 2024, 9:07pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/23 "2024-01-08T21:07:14Z")

</div>

Thanks for sending. The row ID from the reference of the google sheets fuction is one in the same (1) with the data list viewers rows.

AKA “rowfind1”

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/c/8cded2f92d8b1a3a4f088c62368b30a82bf7483e.png)

 ![IMG_8232](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/5/354bbdf4a4b0205c5ca38913836dfcfefe341150.jpeg)

---

<div class="post-metadata">

**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\
**Post date:** [January 8, 2024, 9:08pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/24 "2024-01-08T21:08:18Z")

</div>

![IMG_8233](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/5/35d53878c1a13335d9f6b95732b48944e64ffc00.jpeg)

---

<div class="post-metadata">

**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\
**Post date:** [January 8, 2024, 9:11pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/25 "2024-01-08T21:11:35Z")

</div>

This seems simple but it’s not pulling anything from that row Id’s subtitle

Hmmmmmmm

---

<div class="post-metadata">

**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\
**Post date:** [January 8, 2024, 9:16pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/26 "2024-01-08T21:16:40Z")

</div>

Ive even replaced the variable with a number block #1.

Noda

---

<div class="post-metadata">

**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\
**Post date:** [January 8, 2024, 11:42pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/27 "2024-01-08T23:42:58Z")

</div>

Man Tatiang,

Now nothing seems to work.

I just tried to reference Google Sheet through Get Object.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/9/79d55ff7a069249a63e491b464afe513118940f8.png)

It comes back as null.

This is frustrating.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [April 7, 2024, 11:43pm UTC](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227/28 "2024-04-07T23:43:42Z")

</div>

Closed on April 7, 2024, 11:43pm UTC

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

[Previous page](https://community.thunkable.com/t/updating-google-sheet-after-identifying-the-unique-row-and-cell-location/2764227.md?page=1)
