🉑 Generate Anki flash cards for language learning with Google Translate and GPT

Description

Context
Hey! I'm Samir, a Supply Chain Data Scientist from Paris who spent six years in China studying and working while struggling to learn Mandarin.



I know the challenges of mastering a complex language like Chinese and my greatest support was flash cards. Therefore, I designed this workflow to support fellow Mandarin learners by automating flashcard creation using n8n, so they can focus more on learning and less on manual data entry.

📬 For business inquiries, you can add me on Here

Who is this template for?
This workflow template is designed for language learners and educators who want to automate the creation of flashcards for Mandarin (or any other language) using Google Translate API, an AI agent for phonetic transcription and generating an illustrative sentence and a free image retrieval API.

Why?
If you use the open-source application Anki, this workflow will help you automatically generate personalized study materials.

How?
Let us imagine you want to learn how to say the word Contract in Mandarin.

The workflow will automatically
Translate the word in Simplified Mandarin (Mandarin: 合同).
Provide the phonetic transcription (Pinyin: Hétóng)
Generate an example sentence (Example: 我们签订了一份合同.)
Download an illustrative picture (For example, a picture of a contract signature)



All these fields are automatically recorded in a Google Sheet, making it easy to import into Anki and generate flashcards instantly

What do I need to start?
This workflow can be used with the free tier plans of the services used. It does not require any advanced programming skills.
Prerequisite
A Google Drive Account with a folder including a Google Sheet
API Credentials: Google Drive API, Google Sheets API and Google Translate API activated with OAuth2 credentials
A free API key of pexels.com
A google sheet with the columns
Next
Follow the sticky notes to set up the parameters inside each node and get ready to pump your learning skills.

I have detailed the steps in a short tutorial 👇



🎥 Check My Tutorial

Notes
This workflow can be used for any language. In the AI Agent prompt, you just need to replace the word pinyin with phonetic transcription.
You can adapt the trigger to operate the workflow in the way you want. These operations can be performed by batch or triggered by Telegram, email, or webhook.
If you want to learn more about how I used Anki flash cards to learn mandarin: 🈷️ Blog Article about Anki Flash Cards


This workflow has been created with N8N 1.82.1
Submitted: March 17th, 2025