Set up and use Google Sheets integration

Discover how to manage content localization using the Smartcat for Google Sheets extension, enabling seamless translation projects and collaboration within 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 right in Google Sheets.

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

Setting up the extension

1. Start with installing the Smartcat app from Google Marketplace.

2. Open the Google Sheets document that 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

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 will 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.

Enter the name for your template. 

Click Save Template.

Translate your spreadsheet

Automated translation

To translate content automatically (using Translation memories and AI Translation), just click Translate automatically.

The corresponding empty cells will automatically be filled with the translations.

Creating a translation project

Click Send to Smartcat.

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

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

Review your translation

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

An Overview tab will open, where you can track the translation progress.

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

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

Check the Quality Assurance tab for inaccuracies.

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

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.

When you're done reviewing your translation in Smartcat Editor, click Done. This will finalize 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.

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

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