🉑 Generate Anki flash cards for language learning with Google Translate and GPT
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs on Google Sheets events (row added). Along the way it connects OpenAI Chat Model, Google Sheets and Google Drive. It also calls api.pexels.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- initialText is empty? (If): checks a condition and branches into true / false
- Take initialText (Edit Fields (Set)): sets 1 field: entry
- Google Translate: uses Google Translate
- Call API Pexels (HTTP Request): calls api.pexels.com
- Extract Fields (Edit Fields (Set)): sets 3 fields: initialText, translatedText, image_name
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Get Picture (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Extract Pinyin and Example (Edit Fields (Set)): sets 2 fields: phonetic, example
- Upload Picture (Google Drive): uses Google Drive
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.pexels.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Google Translate
n8n-nodes-base.googleTranslate - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Merge
n8n-nodes-base.merge - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - No Operation, do nothing
n8n-nodes-base.noOp - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
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.…