Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
styledefault
typelist
printabletrue

Introduction

GoogleSheets Google Sheets is one of the worlds most known, dynamic spreadsheet applications. When used for translation needs, it pairs perfectly with Lang Connector by Locale for a quick, and efficient automated translation workflow. By using a simple translation format and workflow, it’s it is easy to extract content for translation via your existing workflows, whether it’s it is a TMS, MT engine, or dedicated human for translation.

...

What you will need to get started

  1. The Login link for Locale (https://app.locale.to/en/).

  2. The username and password for the Google Account which contains the GoogleSheet Google Sheet for translation.

    1. Note: If you do not possess the correct credentials to access this information, please contact your system administrator or support representative. Locale does not have access to this nor do we provide this information.

  3. User login information for both your Locale instance, and your GoogleSheets Google Sheets account.

    1. A trial account of Locale can also be taken for free by going to locale.to and selecting the “Get Started” button.

...

Adding the GoogleSheets Google Sheets Connector to Locale

In order to add the GoogleSheets Google Sheets connector to your Locale instance, you’ll you will need the username and password information for the account you’d like to connect with locale.

  1. Start by accessing your Locale instance with your username and password. Once logged into Locale (instructions on that can be found here: Locale: Accessing your Locale instance), you will see a Dashboard which looks something like this image below.

...

  1. Select the Add Project button and you will be presented with the Locale Connector Store.

  2. Select the Document option in the menu filter to the left, and select the Create Project button under GoogleSheets Google Sheets in the first row.

...

  1. Next is the OAuth screen for connecting your GoogleSheet Google Sheet instance to the Locale platform.

...

  1. After this step, Lang Connector will connect with your GoogleSheets Google Sheets instance, and you’re ready for the project creation step.

...

Creating a Locale project with the GoogleSheets Google Sheets Connector

Once you have followed the steps above to configure the GoogleSheets Google Sheets connector, you are almost ready to create a project. It is also important to understand the document formatting and language mapping that must be in place for Lang Connector and the Locale platform to be able to properly handle your request. If you have not done so already, check out our article on Locale: Target language mapping in your GoogleSheets Google Sheets projects.

  1. The first step is to choose the GoogleSheets Google Sheets page which contains your content for translation.

...

  1. Locale will begin by analyzing the content found in the GoogleSheet Google Sheet page, and show the number of words and segments required for translation.

...

  1. Once your content has been pushed for translation, it will automatically be placed back into the GoogleSheet Google Sheet under the appropriate target language columns, and the status in Locale will show Completed.

...