If you enjoy my Google Workspace Apps Script work, please consider buying me a cup of coffee!
TSFormTranslator is a demonstration Google Apps Script which enables a Google Form owner to translate a form created in English into one of 79 different languages using Google Translate. ( For a list of supported languages, see the TSFormTranslator documentation. )
Once the form has been translated and shared, form users can submit responses in the form's language.
A nicely formatted email containing the submitted content will be sent to the form owner in both the form language and English translation each time a form user submits to the form.
**
NOTE: If you and your form users are using a browser such as Chrome (which already supports translation), you may be interested in TSContactForm instead.
Follow these instructions to install the TSFormTranslator script and host form into your Google Drive:
-
Login to your Google Drive.
-
Access the TSFormTranslator form.
-
Click the Use Template button. This will copy the form to your Google Drive.
See the TSFormTranslator documentation
Important Usage Notes:
-
TSFormTranslator uses Google Translate to translate form elements. Some English words and phrases may not translate as expected in all languages.
-
Some built-in Google Form text will not be translated by TSFormTranslator.
-
Some translation languages may only be viewable in browsers such as Chrome.
-
Form Page Navigation will no longer work after form translation.
-
Time, date and duration form field submissions will only show in English in the sent email.
-
Google Apps Scripts are subject to daily quota limits including the number of emails sent and the Trigger Aggregate Execution Time. See the Quota Limits tab of the Google Apps Script Dashboard for more information.
-
TSFormTranslator may not be appropriate for high traffic forms, especially in cases where the form owner consistently receives quota limit exceeded notifications.
Contributions are welcome. Please take a moment to review the guidelines for contributing and check the Change log for any existing updates.
Edit src/tsformtranslator.coffee for all changes to dist/code.gs and use Gulp to build. See the Using CoffeeScript and Gulp section below for more information.
Edit .html
files directly in the dist/ directory.
Ensure that Node.js and npm are installed on your system. NOTE: Most Node.js installers include npm.
To install dependencies, run the following command from the project's root directory (you may need to run sudo npm install
depending upon your environment):
$ npm install
Install Gulp globally. (You may need to run sudo npm install --global gulp
depending upon your environment):
$ npm install --global gulp
Code:
To build code, edit the source and run the following command from the project's root directory:
$ gulp
While developing, the gulp dev
task may be useful. Run the following command from the project's root directory:
$ gulp dev
You can find gulp tasks in the gulpfile.
Copyright Laura Taylor
Licensed under the Apache License, Version 2.0 (the "License"); you may not use the files except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.