Extract vocabulary flashcards from Spotify listening with Gemini and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on a schedule (cron 0 12 * * 7). Along the way it connects Google Gemini Chat Model, Google Sheets and Spotify.
How it runs
Trigger: On a schedule (cron 0 12 * * 7).
- Get the recently played Songs (Spotify): recently played
- Cut out Duplicate Songs (Code): runs custom JavaScript code
- Getting Lyrics (HTTP Request): calls an HTTP API
- Put all Lyrics together (Code): runs custom JavaScript code
- Read all Vocabularies (Google Sheets): uses Google Sheets
- Combine existing Words with new Words (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- Parse, Deduplicate, Week Code (Code): runs custom JavaScript code
- Create sheet (Google Sheets): create
- Cut out SheetName Column (Code): runs custom JavaScript code
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Spotify
n8n-nodes-base.spotify - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
What this workflow does This workflow turns your Spotify listening history into vocabulary flashcards for language learning. When you listen to music in your target language, you hear words hundreds of times without trying, they're already in your…