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 flashcards. 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.

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.

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 flashcards to learn Mandarin, check out my blog article about Anki flashcards.

Submitted: March 17th, 2025