Google Apps Script (sheets) replace text values using translation table


Google Apps Script (sheets) replace text values using translation table

General Description


I am in need of a Google Apps Script to perform a translation of text in a Google Sheets column.

The text is in Hebrew, and a translation table to the specific terms is provided.

In general, the table hold financial securities transactions (Buy, Sell, Receive dividend etc.)

I have already written some code in the Script editor, see “[login to view URL]”. It is very basic but it works.

I also created a file with service functions called “[login to view URL]”

If you have your own service functions you usually use, you can of course use them instead

Many thanks!

function translate_transaction_text()


1] Open spreadsheet here:

[login to view URL]

2] Open sheet called “translate_text”

3] Perform the translation in the following logic:

In the column : text_hebrew_INPUT

Exists Hebrew text similar to:

TTT US /דיב

I would like a script to create a “translated” version of the text, so the output will be stored in column named: text_english_OUTPUT

TTT US /Dividend

The translation table is held in another sheet called: translation_table

Hebrew English

דיב Dividend

רבית Interest

In sheet “translate_text” Rows 3-14 are samples for the required output. Rows after are for testing.

4] The script should handle situations when there is more than one Hebrew word to replace, for example, row 13

5] The script will get the required column using the column name and not the column number. So it will be more dynamic…

This can be done using the code here:

[login to view URL]

6] If there is already a value in the column text_english_OUTPUT, do not re-rewrite it.

So, for example, if in cell text_english_OUTPUT!F3 data exists already (here it’s):

“TTT US /Dividend”

It should not rewrite it.

Many thanks for looking into this project!

Evner: Javascript, Google App Engine

Se mere: google sheets find and replace macro, google sheets substitute regex, google sheets find and replace formula, google sheets substitute multiple, google sheets find and replace wildcard, google sheets replace function, google sheets replace formula with value, google sheets find and replace script, windows bat script search replace text file, script find replace hex values, google apps script email verification, google apps script smtp, email validation google apps script, google apps script validation, google apps script api, google apps script attachments forward, google apps script for sheets, google apps script, i am looking for someone to write a google apps script in google sheets, make repairs to google apps script

Om arbejdsgiveren:
( 4 bedømmelser ) Givataim, Israel

Projekt ID: #20140933

Tildelt til:


Hello, how are you? I should be able to figure out how to do this. I would go through it in more detail and make sure, before committing to doing the project. Please let me know if you're interested. By the way, how Flere

$30 USD in 2 dage
(15 bedømmelser)

4 freelancere byder i gennemsnit $31 på dette job


Hello, I am a Java expert with 10+ years, especially highly skilled and experienced in web development adhering to deals in website and web applications development and graphic design. I have gone through your project Flere

$50 USD in 2 dage
(0 bedømmelser)

Dynamic and motivated professional with a proven record of generating and building relationships, managing projects from concept to completion, designing educational strategies, and coaching individuals to success. Ski Flere

$20 USD in 7 dage
(0 bedømmelser)

I am excellent with Microsoft excel. I am a Business Management student and I have taken many such projects which included editing or data entry. Relevant Skills and Experience Ability to use Microsoft Excel and Word Flere

$25 USD på 1 dag
(0 bedømmelser)