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.
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.
{{ split("Spanish,German,French,Japanese"; ",") }}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.
Translate the text below into {{2.value}}. Return ONLY the translation, no quotes and no notes.
Text: {{1.source}}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
25:00
12:05
18:30
32:08
21:45
28:30