Google Gemini Text Localization Workflow: n8n + Gmail + Sheets

Localize text into multiple languages automatically with Google Gemini—then save to Google Sheets and email results via Gmail

This Google Gemini Text Localization Workflow (n8n + Gmail + Sheets) turns an n8n form submission into ready-to-use translations. It takes your source text, localizes it for each target language using Google Gemini, logs everything in a Google Sheets “Translations” tab, and emails all translations to the requester through Gmail.

What this workflow does

• Receives localization requests from an n8n form, including requester email, content type, target languages, and source text.
• Splits the comma-separated language list into one language item per target language.
• Processes translations in small batches, sending each language item to Google Gemini with localization instructions.
• Preserves placeholders and brand names as specified in the Gemini instructions, tailored to the provided content type.
• Appends results to Google Sheets: for each language, it records the language, source text, and the generated translation into the “Translations” sheet/tab.
• Compiles all translations into a single plain-text email body after processing completes.
• Sends one email via Gmail to the requester containing every translation.

Use cases

• SaaS teams requesting multi-language UI/marketing copy localization without manual emailing and copy/paste.
• Automation engineers creating a Gemini-powered localization pipeline using n8n, Sheets, and Gmail.
• Operators tracking every translation request in Google Sheets for review, auditing, or later reuse.

Technical details

• Google Gemini (PaLM) API for text localization (batch processing and model output capture).
• Google Sheets with OAuth2 to append rows into a “Translations” tab.
• Gmail OAuth2 to send one consolidated email containing all translations.
• n8n nodes include form trigger, split in batches, code, google sheets, and gmail.

Setup: Connect credentials for Google Gemini (PaLM), Google Sheets, and Gmail; select the target spreadsheet with a “Translations” tab; publish the n8n form and share its URL for localization requests.