GPT-Translate-AddOn is a Google Sheets add-on that enables seamless multilingual translations using OpenAI's GPT-4 model. This tool is designed to assist users in translating text across various languages directly within Google Sheets, enhancing productivity and collaboration.
- Seamless translation between multiple languages within Google Sheets.
- Activate or deactivate the translation feature from the menu. S- upports various languages.
- Install the add-on from Google Workspace Marketplace.
- Follow the detailed installation and publication guide here: Google Workspace Marketplace How-To.
- Open Google Sheets, go to "Extensions > GPT Translate" to activate.
- Use the function
=gpt_translation("Your text", "LANGUAGE_CODE")
to translate text. - Example:
=gpt_translation(A1, "KR")
translates the text in cell A1 to Korean. - Replace
LANGUAGE_CODE
with the appropriate code (e.g.,"EN"
for English,"KR"
for Korean).
- Enter Your OpenAI API Key:
- Replace
YOUR_API_KEY
in the script with your personal OpenAI API key.
- Supported Languages:
- You can customize or extend this list by modifying the languageMap object in the script.
- The script includes a languageMap that supports the following languages by default:
EN: English
KR: Korean
PT: Portuguese
JA: Japanese
ES: Spanish
TH: Thai
ID: Indonesian
RU: Russian
ZH-CN: Chinese (Simplified)
ZH-TW: Chinese (Traditional)
TL: Tagalog
VI: Vietnamese
- Customize UI:
- Modify the menu options in the script to fit your specific needs. The UI includes options to activate or deactivate the GPT Translate feature through the Google Sheets menu.
This project is licensed under the MIT License.
Contributions are welcome! Please fork this repository, make your changes, and submit a pull request.