Extract vocabulary flashcards from Spotify listening with Gemini and Google Sheets

Description

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 subconscious. This workflow extracts those words and turns them into flashcards, so you're connecting meaning to sounds you already know.

Every Sunday, the workflow:
Fetches your recently played songs from Spotify
Finds lyrics via lrclib.net
Extracts 40-60 useful words (B1-B2 level) using Google Gemini
Deduplicates against all previously learned words
Writes new vocabulary to Google Sheets (master + weekly tab)

Review with the free Flashcard Lab app (iOS + Android) which reads directly from Google Sheets with spaced repetition. Works for any language, just change the AI prompt.

Setup

Setup time: ~15 minutes

Google Cloud Console: Create project, enable Sheets API + Drive API, create OAuth2 credentials, set app to "In Production" (tokens expire after 7 days in Testing mode)
Gemini API: Get a free key from Google AI Studio
Spotify Developer Dashboard: Create app, note Client ID + Secret
Google Sheet: Create a sheet with tab "All Vocabularies" and headers Word + Translation
Import workflow, connect credentials, select your Google Sheet in all Sheets nodes
Click "Execute Workflow" to test
Enable the schedule trigger for weekly runs

Changing the language

Edit the prompt in "Prepare all Lyrics into Pairs" — that's the only place you need to change. All other nodes use generic Word and Translation columns.

> 🎧 Tip: Listen to music in the language you're learning. The whole point is that your brain already absorbed these words passively — the flashcards connect meaning to sounds you already know.

Full documentation

👉 GitHub Repository