Meta tags:

Headings (most frequently used words):

the, script, code, google, and, apps, translate, text, from, docs, sheets, slides, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, page, summary, objectives, about, this, solution, prerequisites, set, up, run, review, contributors, next, steps, how, it, works, services, create, project, install, test, deployment, gs, appsscript, json, workspace, for, developers, tools, connect, view, source,

Text of the page (most frequently used words):
text (152), val (107), the (89), google (65), var (31), cardservice (31), and (25), add (24), apps (22), #script (21), forminput (20), card (19), language (19), workspace (18), translate (18), selection (17), return (16), originlanguage (15), function (15), get (14), translation (14), destinationlanguage (14), for (13), code (12), sheets (12), slides (12), click (12), docs (11), ons (11), selected (10), with (10), destination (10), origin (10), user (10), this (9), const (9), string (9), cloud (8), console (8), thumb (8), project (8), addwidget (8), chat (8), developer (7), support (7), samples (7), createselectioncard (7), param (7), builder (7), service (6), overview (6), down (6), translates (6), source (6), helper (6), elements (6), show (6), inputtext (6), from (6), solution (6), english (5), twitter (5), blog (5), admin (5), within (5), input (5), false (5), setdisabled (5), setfunctionname (5), newaction (5), setonclickaction (5), settext (5), newtextbutton (5), addbutton (5), fromsection (5), hostapp (5), open (5), español (4), products (4), youtube (4), developers (4), your (4), select (4), using (4), services (4), https (4), www (4), com (4), languageapp (4), range (4), element (4), can (4), selectioninput (4), newbuttonset (4), translated (4), main (4), you (4), drive (4), all (3), newsletter (3), apis (3), explorer (3), dashboard (3), tools (3), release (3), notes (3), codelabs (3), sample (3), copy (3), build (3), understand (3), other (3), need (3), users (3), detects (3), target (3), more (3), content (3), page (3), extend (3), googleapis (3), auth (3), currentonly (3), textrange (3), selectiontype (3), getselection (3), cell (3), ranges (3), astext (3), getelement (3), default_output_text (3), default_input_text (3), previousselected (3), fieldname (3), setfieldname (3), fieldtitle (3), settitle (3), generatelanguagesdropdown (3), what (3), newcardsection (3), addsection (3), section (3), outputtext (3), view (3), file (3), run (3), following (3), how (3), home (3), gmail (3), resources (3), spaces (3), 한국어 (2), 日本語 (2), ภาษาไทย (2), বাংলা (2), हिंदी (2), فارسی (2), العربيّة (2), עברית (2), русский (2), türkçe (2), tiếng (2), việt (2), português (2), brasil (2), polski (2), italiano (2), indonesia (2), français (2), américa (2), latina (2), deutsch (2), manage (2), terms (2), platform (2), our (2), coding (2), too (2), steps (2), last (2), updated (2), 2026 (2), utc (2), copies (2), displays (2), oauth (2), button (2), licensed (2), under (2), details (2), license (2), send (2), feedback (2), images (2), onhomepage (2), asstring (2), slidesapp (2), getslidesselection (2), getvalue (2), numrows (2), let (2), numcols (2), length (2), getsheetsselection (2), gettext (2), skip (2), log (2), logger (2), getdocsselection (2), cleartext (2), clean (2), translatetext (2), empty (2), language_map (2), had (2), generate (2), true (2), setmultiline (2), setvalue (2), output (2), newtextinput (2), else (2), default_destination_lan (2), default_origin_lan (2), chinese (2), detect (2), review (2), prompted (2), authorize (2), create (2), install (2), test (2), when (2), editor (2), deployment (2), set (2), prerequisites (2), interface (2), languages (2), previews (2), updates (2), started (2), training (2), marketplace (2), automate (2), share (2), vault (2), tasks (2), sites (2), meet (2), keep (2), forms (2), classroom (2), calendar (2), search (2), github (2), codelab (2), integrate (2), agents (2), gemini (2), reference (2), guides (2), cookies, privacy, firebase, chrome, android, connect, subscribe, channel, videos, try, guided, hands, experience, explore, them, own, follow, workspacedevs, read, easy, easytounderstand, solved, problem, solvedmyproblem, otherup, missing, information, missingtheinformationineed, complicated, many, toocomplicatedtoomanysteps, out, date, outofdate, issue, samplescodeissue, otherdown, then, result, automatically, but, allows, manual, changing, key, actions, include, setting, configuring, creating, deploying, tell, except, otherwise, noted, are, see, java, registered, trademark, oracle, its, affiliates, site, policies, apache, creative, commons, attribution, publish, app, next, maintained, help, experts, contributors, timezone, america, new_york, dependencies, exceptionlogging, stackdriver, oauthscopes, documents, spreadsheets, presentations, runtimeversion, addons, common, name, logourl, gstatic, branding, product, translate_24dp, png, layoutproperties, primarycolor, 2772ed, homepagetrigger, runfunction, appsscript, json, gettextrange, getselectiontype, getactivepresentation, active, slide, getcell, getnumcolumns, getnumrows, getranges, getactiverangelist, getactive, spreadsheetapp, cells, non, edited, that, modify, only, getrangeelements, getactivedocument, documentapp, undefined, api, additem, array, index, foreach, dropdown, selectioninputtype, settype, newselectioninput, previously, drop, menu, checks, clear, filled, textbuttonstyle, settextbuttonstyle, buttons, enter, newcardbuilder, original, callback, rendering, zulu, yoruba, yiddish, xhosa, welsh, vietnamese, uzbek, urdu, ukrainian, turkish, thai, telugu, tamil, tajik, tagalog, filipino, swedish, swahili, sundanese, spanish, somali, slovenian, slovak, sinhala, sinhalese, sindhi, shona, sesotho, serbian, scots, gaelic, samoan, russian, romanian, punjabi, portuguese, portugal, brazil, polish, persian, pashto, nyanja, chichewa, norwegian, nepali, myanmar, burmese, mongolian, marathi, maori, maltese, malayalam, malay, malagasy, macedonian, luxembourgish, lithuanian, latvian, latin, lao, kyrgyz, kurdish, korean, khmer, kazakh, kannada, javanese, japanese, italian, irish, indonesian, igbo, icelandic, hungarian, hmong, hmn, hindi, hebrew, hawaiian, haw, hausa, haitian, creole, gujarati, greek, german, georgian, galician, frisian, french, finnish, estonian, esperanto, dutch, danish, czech, croatian, corsican, traditional, simplified, cebuano, ceb, catalan, bulgarian, bosnian, bengali, belarusian, basque, azerbaijani, armenian, arabic, amharic, albanian, afrikaans, langauge, means, right, sidebar, new, one, done, deployments, deploy, copied, make, info_outline, web, browser, access, internet, account, accounts, might, require, administrator, approval, use, creates, uses, default, edit, into, works, about, does, objectives, intermediate, minutes, type, duration, level, utilizes, functionality, requires, setup, authorization, customizable, allowing, specify, trigger, directly, their, document, outlined_flag, summary, save, categorize, based, preferences, stay, organized, collections, library, learning, node, progress, bars, data, schedule, meetings, team, member, macros, preview, links, books, respond, incidents, authentication, plan, travels, agent, accessible, across, projects, vertex, enterprise, answer, questions, analyze, label, messages, concepts, sign,

Text of the page (random words):
deutsch español español américa latina français indonesia italiano polski português brasil tiếng việt türkçe русский עברית العربيّة فارسی हिंदी বাংলা ภาษาไทย 中文 简体 中文 繁體 日本語 한국어 sign in add ons overview guides reference samples support google workspace home add ons overview guides reference samples support all products more resources more overview google workspace add ons ai concepts in google chat apps codelab analyze and label gmail messages with gemini answer questions with ai in chat spaces integrate gemini enterprise agents with google workspace integrate vertex ai agents with google workspace manage projects in chat spaces plan travels with an ai agent accessible across google workspace respond to incidents user authentication preview links from google books copy macros get team member details schedule meetings in chat spaces translate text editor add ons clean up data in sheets show progress bars in slides node js codelab learning resources github code samples github oauth 2 0 apps script library google workspace apps admin console cloud search gmail google calendar google chat google classroom google docs google drive google forms google keep google meet google sheets google sites google slides google tasks google vault extend automate share add ons apps script chat apps drive apps marketplace tools admin console apps script dashboard google cloud console apis explorer card builder training support how to get started codelabs developer support updates release notes developer previews youtube newsletter x twitter blog home google workspace add ons samples send feedback translate text from google docs sheets and slides stay organized with collections save and categorize content based on your preferences page summary outlined_flag this google workspace add on translates selected text within google docs sheets and slides using the google translate service users can select text trigger the add on and view the translated output directly within their document the add on is customizable allowing users to specify the source and target languages for translation it requires a google cloud project and setup for authorization and deployment the apps script code utilizes card service for the user interface and language service for translation functionality coding level intermediate duration 30 minutes project type google workspace add on objectives understand what the solution does understand what the apps script services do within the solution set up the script run the script about this solution with this solution you can translate text from within google docs sheets and slides how it works when you select text in docs sheets or slides and click get selection in the add on the script copies the text into the add on translates it and displays the translated text by default the script detects the source language and translates the text to english you can edit the source and target languages apps script services this solution uses the following services card service creates the user interface of the add on language service translates the text using google translate prerequisites to use this sample you need the following prerequisites a google account google workspace accounts might require administrator approval a web browser with access to the internet set up the script create the apps script project click the following button to open the translate apps script project open the project click overview info_outline on the overview page click make a copy install a test deployment in your copied apps script project click editor code open the code gs file and click run when prompted authorize the script click deploy test deployments click install done run the script open a file in google docs sheets or slides or create a new one on the right sidebar open the translate add on translate if prompted authorize the add on select text in your file in the add on click get selection translate review the code to review the apps script code for this solution click view source code view source code code gs const default_input_text const default_output_text const default_origin_lan empty string means detect langauge const default_destination_lan en english const language_map text detect language val text afrikaans val af text albanian val sq text amharic val am text arabic val ar text armenian val hy text azerbaijani val az text basque val eu text belarusian val be text bengali val bn text bosnian val bs text bulgarian val bg text catalan val ca text cebuano val ceb text chinese simplified val zh cn text chinese traditional val zh tw text corsican val co text croatian val hr text czech val cs text danish val da text dutch val nl text english val en text esperanto val eo text estonian val et text finnish val fi text french val fr text frisian val fy text galician val gl text georgian val ka text german val de text greek val el text gujarati val gu text haitian creole val ht text hausa val ha text hawaiian val haw text hebrew val he text hindi val hi text hmong val hmn text hungarian val hu text icelandic val is text igbo val ig text indonesian val id text irish val ga text italian val it text japanese val ja text javanese val jv text kannada val kn text kazakh val kk text khmer val km text korean val ko text kurdish val ku text kyrgyz val ky text lao val lo text latin val la text latvian val lv text lithuanian val lt text luxembourgish val lb text macedonian val mk text malagasy val mg text malay val ms text malayalam val ml text maltese val mt text maori val mi text marathi val mr text mongolian val mn text myanmar burmese val my text nepali val ne text norwegian val no text nyanja chichewa val ny text pashto val ps text persian val fa text polish val pl text portuguese portugal brazil val pt text punjabi val pa text romanian val ro text russian val ru text samoan val sm text scots gaelic val gd text serbian val sr text sesotho val st text shona val sn text sindhi val sd text sinhala sinhalese val si text slovak val sk text slovenian val sl text somali val so text spanish val es text sundanese val su text swahili val sw text swedish val sv text tagalog filipino val tl text tajik val tg text tamil val ta text telugu val te text thai val th text turkish val tr text ukrainian val uk text urdu val ur text uzbek val uz text vietnamese val vi text welsh val cy text xhosa val xh text yiddish val yi text yoruba val yo text zulu val zu callback for rendering the main card return cardservice card the card to show the user function onhomepage e return createselectioncard e default_origin_lan default_destination_lan default_input_text default_output_text main function to generate the main card param string originlanguage language of the original text param string destinationlanguage language of the translation param string inputtext the text to be translated param string outputtext the text translated return cardservice card the card to show to the user function createselectioncard e originlanguage destinationlanguage inputtext outputtext var hostapp e hostapp var builder cardservice newcardbuilder from language selection text input section var fromsection cardservice newcardsection addwidget generatelanguagesdropdown origin from originlanguage addwidget cardservice newtextinput setfieldname input setvalue inputtext settitle enter text setmultiline true if hostapp docs fromsection addwidget cardservice newbuttonset addbutton cardservice newtextbutton settext get selection setonclickaction cardservice newaction setfunctionname getdocsselection setdisabled false else if hostapp sheets fromsection addwidget cardservice newbuttonset addbutton cardservice newtextbutton settext get selection setonclickaction cardservice newaction setfunctionname getsheetsselection setdisabled false else if hostapp slides fromsection addwidget cardservice newbuttonset addbutton cardservice newtextbutton settext get selection setonclickaction cardservice newaction setfunctionname getslidesselection setdisabled false builder addsection fromsection translation language selection text input section builder addsection cardservice newcardsection addwidget generatelanguagesdropdown destination to destinationlanguage addwidget cardservice newtextinput setfieldname output setvalue outputtext settitle translation setmultiline true buttons section builder addsection cardservice newcardsection addwidget cardservice newbuttonset addbutton cardservice newtextbutton settext translate settextbuttonstyle cardservice textbuttonstyle filled setonclickaction cardservice newaction setfunctionname translatetext setdisabled false addbutton cardservice newtextbutton settext clear setonclickaction cardservice newaction setfunctionname cleartext setdisabled false return builder build helper function to generate the drop down language menu it checks what language the user had selected param string fieldname param string fieldtitle param string previousselected the language the user previously had selected return cardservice selectioninput the card to show to the user function generatelanguagesdropdown fieldname fieldtitle previousselected var selectioninput cardservice newselectioninput settitle fieldtitle setfieldname fieldname settype cardservice selectioninputtype dropdown language_map foreach language index array selectioninput additem language text language val language val previousselected return selectioninput helper function to translate the text if the originlanguage is an empty string the api detects the language return cardservice card the card to show to the user function translatetext e var originlanguage e forminput origin var destinationlanguage e forminput destination var inputtext e forminput input if originlanguage destinationlanguage inputtext undefined var translation languageapp translate e forminput input e forminput origin e forminput destination return createselectioncard e originlanguage destinationlanguage inputtext translation helper function to clean the text return cardservice card the card to show to the user function cleartext e var originlanguage e forminput origin var destinationlanguage e forminput destination return createselectioncard e originlanguage destinationlanguage default_input_text default_output_text helper function to get the text selected return cardservice card the selected text function getdocsselection e var text var selection documentapp getactivedocument getselection logger log selection if selection var elements selection getrangeelements for var i 0 i elements length i logger log elements i var element elements i only modify elements that can be edited as text skip images and other non text elements if element getelement astext element getelement astext gettext text element getelement astext gettext n if text var originlanguage e forminput origin var destinationlanguage e forminput destination var translation languageapp translate text e forminput origin e forminput destination return createselectioncard e originlanguage destinationlanguage text translation helper function to get the text of the selected cells return cardservice card the selected text function getsheetsselection e var text var ranges spreadsheetapp getactive getselection getactiverangelist getranges for var i 0 i ranges length i const range ranges i const numrows range getnumrows const numcols range getnumcolumns for let i 1 i numcols i for let j 1 j numrows j const cell range getcell j i if cell getvalue text cell getvalue n if text var originlanguage e forminput origin var destinationlanguage e forminput destination var translation languageapp translate text e forminput origin e forminput destination return createselectioncard e originlanguage destinationlanguage text translation helper function to get the selected text of the active slide return cardservice card the selected text function getslidesselection e var text var selection slidesapp getactivepresentation getselection var selectiontype selection getselectiontype if selectiontype slidesapp selectiontype text var textrange selection gettextrange if textrange asstring text textrange asstring n if text var originlanguage e forminput origin var destinationlanguage e forminput destination var translation languageapp translate text e forminput origin e forminput destination return createselectioncard e originlanguage destinationlanguage text translation appsscript json timezone america new_york dependencies exceptionlogging stackdriver oauthscopes https www googleapis com auth documents currentonly https www googleapis com auth spreadsheets currentonly https www googleapis com auth presentations currentonly runtimeversion v8 addons common name translate logourl https www gstatic com images branding product 1x translate_24dp png layoutproperties primarycolor 2772ed homepagetrigger runfunction onhomepage docs slides sheets contributors this sample is maintained by google with the help of google developer experts next steps extend google workspace with add ons build google workspace add ons publish an app send feedback except as otherwise noted the content of this page is licensed under the creative commons attribution 4 0 license and code samples are licensed under the apache 2 0 license for details see the google developers site policies java is a registered trademark of oracle and or its affiliates last updated 2026 05 29 utc need to tell us more easy to understand easytounderstand thumb up solved my problem solvedmyproblem thumb up other otherup thumb up missing the information i need missingtheinformationineed thumb down too complicated too many steps toocomplicatedtoomanysteps thumb down out of date outofdate thumb down samples code issue samplescodeissue thumb down other otherdown thumb down last updated 2026 05 29 utc this google workspace add on translates selected text within docs sheets and slides users select text click get selection in the add on and then click on translate the add on copies translates and displays the result using the card and language services it automatically detects the source language but allows manual selection and changing of target language key actions include setting up a google cloud project configuring oauth creating an apps script project deploying it and using the get selection button to get the translation n blog read the google workspace developers blog x twitter follow workspacedevs on x twitter code samples explore our sample apps or copy them to build your own codelabs try a guided hands on coding experience videos subscribe to our youtube channel google workspace for developers platform overview developer products release notes developer support terms of service tools admin console apps script dashboard google cloud console apis explorer connect blog newsletter x twitter youtube android chrome firebase google cloud platform google ai all products terms privacy manage cookies english deutsch español español américa latina français indonesia italiano polski português brasil tiế...