Auto-Generate Anki Flashcards for Language Learning with n8n: Google Translate + GPT for Phonetics & Examples

Enter an English word in Google Sheet → auto-translate to target language → AI generates phonetics/pinyin and example sentence → fetch image and write back → import to Anki

Who

Language learners, educators, or anyone looking to reduce manual flashcard creation time

You get

After adding a word to Google Sheet, automatically get translation, phonetics/pinyin, example sentence, and illustration ready for Anki import

You need

n8n · Google Sheets · Google Translate · Pexels · Google Drive

Steps

1. Configure Google Sheet Trigger and Translation

   Set up the workflow trigger in n8n: start when a new row is added to the specified column (initialText) in Google Sheets. Then translate the English word to the target language via Google Translate. Specific actions: 1. Add 'Google Sheets Trigger' node, select 'Row Added' event, configure Google Sheets API credentials, and select the target spreadsheet and sheet 2. Add 'Google Translate' node, set input text to `{{ $json.initialText }}`, target language to zh-CN (or your desired language code) 3. Add 'IF' node to check if initialText is empty; if empty, route to 'No Operation' and terminate

   Setup guidance · Editorial suggestion。n8n workflow editor; for setup assistant to confirm inputs and permissions

   Copy prompt

   Please configure the first step of the n8n workflow based on the following:
   - Trigger: Google Sheets Trigger, event type Row Added, monitoring column initialText
   - Translation node: Google Translate, input `{{ $json.initialText }}`, target language zh-CN
   - Conditional branch: IF node checking `{{ $json.initialText }}` is not empty
   
   First confirm your Google Sheets API credentials are configured and you have the spreadsheet ID ready.

2. Configure AI Agent for Phonetics and Example Sentence

   Pass the translated result to an AI Agent that uses an OpenAI model to generate phonetics (pinyin or equivalent) and a short example sentence. Output must follow a fixed JSON format. Specific actions: 1. Add 'AI Agent' node (LangChain Agent), set input text to `{{ $json.translatedText }}` 2. Connect 'OpenAI Chat Model' sub-node, select gpt-4o-mini (or gpt-4o) 3. Connect 'Structured Output Parser' sub-node, define JSON Schema with pinyin and sentence fields 4. Enter the system message below into the AI Agent's System Message field 5. Add 'Set' node to extract output.pinyin and output.sentence into phonetic and example fields

   Execution prompt · Source text。AI Agent node System Message field

   Copy prompt

   # Role
   You are a helpful translation agent that will help users to extract the pinyin from Chinese characters to create flashcard for language learning.
   
   # Context
   You will receive a word or sentence in simplified Chinese characters; you are expected to extract the pinyin and generate a simple sentence in Chinese to illustrate the sense of the word. 
   
   # Tasks
   1. Generate the pinyin of the characters presented
   2. Propose a short sentence in mandarin to illustrate the definition of the word.
   
   # Notes
   - Generate the output in JSON format following the example below:
   {"pinyin": "Cāngkù",
   "sentence": "卡车抵达仓库。"}
   
   - Be very diligent in thinking about the task being asked from you.
   - Generate concise sentences as they need to fit in flash cards.

3. Configure Pexels Image Retrieval and Google Drive Upload

   Search for an illustration using the original English word on Pexels free image database, download it, and upload to Google Drive to obtain a shareable link. Specific actions: 1. Add 'Set' node to extract initialText as the search keyword 2. Add 'HTTP Request' node calling Pexels API: `GET https://api.pexels.com/v1/search?query={{ $json.initialText }}`, with Header `Authorization: <PEXELS_API_KEY>` 3. Add second 'HTTP Request' node to download the image, URL set to `{{ $json.photos[0].src.medium }}` 4. Add 'Google Drive' upload node, filename `{{ $('Trigger Added Row').item.json.initialText }}.jpeg`, select target folder 5. Add 'Set' node to extract webContentLink as image_link

   Setup guidance · Editorial suggestion。n8n workflow editor; HTTP Request and Google Drive node configuration

   Copy prompt

   Please configure the Pexels image retrieval nodes:
   - HTTP Request node: URL `https://api.pexels.com/v1/search`, Query param name=query, value=`{{ $('Trigger Added Row').item.json.initialText }}`
   - Header param name=Authorization, value=your Pexels API key
   - Download node: URL `{{ $json.photos[0].src.medium }}`
   
   Then configure Google Drive upload node:
   - Filename: `{{ $('Trigger Added Row').item.json.initialText }}.jpeg`
   - Select parent Drive and target folder
   
   Finally extract `{{ $json.webContentLink }}` as the image link.

4. Merge Results and Update Google Sheet

   Combine translation results, phonetics/example sentence, and image link, then update the corresponding row in the original Google Sheet. Specific actions: 1. Add 'Merge' node (combineBySql mode) to merge translation branch and AI Agent branch 2. Add second 'Merge' node (combineByPosition mode) to merge image branch 3. Add 'Google Sheets' node, operation type 'Update', matching column set to initialText 4. Map fields: initialText, translatedText, phonetic, sentence, image_name, image_link 5. Note: The template has crossed mapping for image_link and image_name; adjust according to actual needs

   Setup guidance · Editorial suggestion。n8n workflow editor; Merge and Google Sheets node configuration

   Copy prompt

   Please configure the final merge and write-back nodes:
   - Merge node 1: combineBySql mode, merge translation data with phonetic/example data
   - Merge node 2: combineByPosition mode, merge image data
   - Google Sheets node: operation=update, matchingColumns=["initialText"]
   - Field mappings:
     - initialText = {{ $json.initialText }}
     - translatedText = {{ $json.translatedText }}
     - phonetic = {{ $json.phonetic }}
     - sentence = {{ $json.example }}
     - image_name = {{ $json.image_name }}
     - image_link = {{ $json.image_link }}
   
   Confirm your sheet includes these column names and test with a single row first.

You are setting up an n8n workflow to automatically generate language learning flashcards. Core flow: Google Sheet trigger → Google Translate → AI Agent generates phonetics/example → Pexels image → merge and write back to sheet. First confirm you have: Google OAuth2 credentials (Drive/Sheets/Translate), Pexels API key, target Google Sheet (with initialText column), and n8n 1.82.1+. Then configure nodes step by step, paying special attention to the AI Agent System Message which must maintain JSON output format.