Set up and use Google Sheets integration

Smartcat for Google Sheets is an extension app for Google Sheets that allows you to manage the localization of content into one or several languages directly in Google Sheets.

Smartcat for Google Sheets is an extension app for Google Sheets that allows you to manage the localization of content into one or several languages directly in Google Sheets.

The integration works as an extension app in Google Sheets displayed as a sidebar.

Setting up the extension

1. Install the Smartcat app from Google Marketplace.

   

2. Open the Google Sheets document you want to translate.

3. Click on the Smartcat icon located in the toolbar section on the right.

   

4. Click Sign In and authorize access to your Google Account. Log in to your Smartcat account and select your workspace. Click Continue to Google Sheets.

Configure your Google Sheet for translation

1. Select the Source language, specify the First row number to be translated. Map the columns to the corresponding languages. In the example below, the source text is located in column B, while column G is mapped for the Spanish language.

The translations for these languages go in these columns. For each language, click Save at the bottom of the sidebar.

Also, you can map any column for segment/document comments or context.

If one or several rows have column titles or content which does not need to be translated, set the first row to skip them.

1. Enter the name for your template.

2. Click Save Template.

Translate your spreadsheet

Automated translation

To translate content automatically using Reviewed Translations (translation memories) and AI Translation, click Translate automatically.

The corresponding empty cells are automatically filled with the translations.

Creating a translation project

1. Click Send to Smartcat.

   

2. Create a new project for your translation or select the existing project.

3. If you want to confirm the translation, mark the corresponding checkbox.

Review your translation

1. Click Open Smartcat project to view and edit your translations or invite professional linguists to review these.

   

2. An Overview tab opens where you can track the translation progress.

   

3. Proceed to the Files tab. Click on the name of your file to open Smartcat Editor.

   

4. The editing area is divided into segments. Edit your translation as needed.

5. Check the Quality Assurance tab for inaccuracies.

6. Access the history of changes by navigating to the History tab.

7. Review your translation by going through it segment by segment. Alternatively, you can also confirm all segments at once by clicking the green button in the toolbar above, on the left.

8. When you're done reviewing your translation in Smartcat Editor, click Done. This finalizes the review stage.

Assign a human reviewer

Another way to review your translation is to assign this task to a human reviewer. Navigate to the Tasks tab.

1. Select the Post-editing task, and then click Invite.

   

2. Select the most suitable option for you: invite a human reviewer from your team, from agencies, or Smartcat Marketplace. Alternatively, you can invite a human reviewer to the Smartcat workspace via email or link. Be sure to specify the reviewer's role and rate in the Additional Options section.

Learn more about collaboration in Smartcat in this article on how to add team members.

Sending translation to Google Sheets

Click Get from Smartcat to upload the translations back to Google Sheets. Wait until the loading process is over. Review your translation in Google Spreadsheet.