# How to change Google Sheet automatically?

**URL:** <https://community.thunkable.com/t/how-to-change-google-sheet-automatically/3712532>\
**Category:** Questions about Thunkable X\
**Created:** [April 3, 2025, 7:04pm UTC](https://community.thunkable.com/t/how-to-change-google-sheet-automatically/3712532 "2025-04-03T19:04:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![anandavardhana57zwwl](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@anandavardhana57zwwl](https://community.thunkable.com/u/anandavardhana57zwwl)\
**Post date:** [April 3, 2025, 7:04pm UTC](https://community.thunkable.com/t/how-to-change-google-sheet-automatically/3712532/1 "2025-04-03T19:04:10Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/2/a2bc7ace5e6e0bb99a460549a8eebd4bd2ed0c1a.png)  
Assume I have to support 25 languages. I have a Google Spreadsheet to which I connect which has 25 sheets called English, French, Spanish … Kannada, Tulu, Hindi. Each of these sheets has messages in that language. I dont want to repeat “get row object from” 1000 times. The Row ID’s I can change via a for loop. Is there a way/trick/workaround to automatically change the language? Right now we have to manually click it and change it. I want to automate it. Please advice how I can do it?  
Thanks  
Ananda

---

<div class="post-metadata">

**Author:** ![krish05](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/krish05/32/200523_2.png) [@krish05](https://community.thunkable.com/u/krish05)\
**Post date:** [April 4, 2025, 1:51pm UTC](https://community.thunkable.com/t/how-to-change-google-sheet-automatically/3712532/2 "2025-04-04T13:51:58Z")

</div>

Assuming your spreadsheet is built like this:

| Row | Language | Message (english letters) |
| --- | --- | --- |
| 1 | English | How are you? |
| 2 | French | Comment vas-tu? |
| 3 | Spanish | Cómo estás? |
| 4 | Kannada | Nīvu hēgiddīri? |
| 5 | Tulu | Yīr en̄ca ullar? |
| 6 | Hindi | Aap kaise ho? |

(I typed some of these myself, so please don’t criticize if I spelled it wrong)

Instead of the `get row object` block, use the `get first row object from` block.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/7/173af8237e16441baef7575e7231d16d82ed461a.png)  
_used one of my personal spreadsheets for this example, don’t copy_

- Make a button that says “Language.” When clicked, redirect to another screen and place a Data Viewer List and set all properties
- After that, you can create a variable and store the language type the _app user_ has selected from the Data Viewer.
- Then you can set it to `where ColumnName = userEntryVar`.

---

<div class="post-metadata">

**Author:** ![anandavardhana57zwwl](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@anandavardhana57zwwl](https://community.thunkable.com/u/anandavardhana57zwwl)\
**Post date:** [April 5, 2025, 3:27pm UTC](https://community.thunkable.com/t/how-to-change-google-sheet-automatically/3712532/3 "2025-04-05T15:27:44Z")

</div>

Thanks @krish05. Please note I am not using Data Viewer List. I am using individual Label/Text Boxes. Also I did more research and there appears to be no solution for my issues. I have to do it individually only. Thanks for your reply.

---

<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:** [July 4, 2025, 3:27pm UTC](https://community.thunkable.com/t/how-to-change-google-sheet-automatically/3712532/4 "2025-07-04T15:27:57Z")

</div>

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