How to change Google Sheet automatically?


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

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.


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.
1 Like

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.

1 Like