AutomationBeginner

How to Auto-Translate Content into Multiple Languages in Make.com

Take one source text and have AI produce several language versions at once, saved back to a spreadsheet.

7 minBeginner

Localizing copy by hand is tedious. This scenario takes one English source string and loops through a list of target languages, asking AI to translate it into each, then writes every version back to your sheet.

  • A Make.com account
  • A Google Sheet with a source text column
  • An OpenAI API key
  • A short list of target languages

Step 1: Read the source rows

Add a Google Sheets Search Rows trigger and select rows that have source text but no translation yet. Use a filter on an empty status column so finished rows are skipped on later runs.

Step 2: Set up the language list

Add an Iterator module and feed it an array of languages. You can build the array inline with the split function so one comma separated cell becomes several loop cycles.

Iterator array
{{ split("Spanish,German,French,Japanese"; ",") }}
Make.com - translation loop
Sheets Search -> Iterator (4 languages) -> OpenAI translate -> Sheets Add Row
per source loop each language per language one row each

Step 3: Translate with OpenAI

Add OpenAI Create a Completion (Chat) inside the loop. Map the current language from the Iterator and the source text from the trigger. Ask for only the translation so you get clean output with no commentary.

OpenAI user message
Translate the text below into {{2.value}}. Return ONLY the translation, no quotes and no notes.

Text: {{1.source}}
Preserve tone and placeholders
Add a line to the prompt telling the model to keep any {curly braces} or %s placeholders unchanged. This protects variables in app strings from being translated by mistake.

Step 4: Write each translation back

Add a Google Sheets Add a Row module after the OpenAI module. Write the original id, the language, and the translated text. Because this sits inside the loop, you get one new row per language per source.

Step 5: Run and verify

Run once. For a single source row you should see four new rows appear, one per language. Spot check a couple of translations and then activate.

Result: every new line of source copy fans out into all your target languages automatically, ready to drop into your product or marketing.

Watch related tutorials

Tags
#make.com#translation#openai#iterator#localization