n8n Word of the Day: Gemini + Google Sheets Daily Email

Turn your submitted vocab into a daily “Word of the Day” email—automatically

This n8n workflow captures new vocabulary through an n8n Form, uses Google Gemini to generate structured study notes, logs everything to Google Sheets, and then sends you a scheduled HTML “word of the day” via Gmail—updating the sheet so you don’t repeat words.

What this workflow does

• Collects inputs: Receives a submission from an n8n Form containing a word, phrase, sentence, or grammar pattern to study.
• Generates a study card with Gemini: Sends the submitted text to Google Gemini using your target language and level, requesting a structured JSON response (term, reading, meaning, example, and grammar note).
• Stores everything in Google Sheets: Parses Gemini’s fields and appends them as a new row with metadata like date_added.
• Sends a daily review: Runs on a schedule, reads all rows from the same Google Sheets vocabulary sheet, and selects the next word based on whether it has been sent before.
• Email delivery + tracking: Sends the selected entry as an HTML “word of the day” email via Gmail, then updates the corresponding row’s last_sent date.

Use cases

• Build a lightweight vocabulary pipeline for self-study or team language learning.
• Have Gemini generate consistent grammar notes and examples from words you collect in real time.
• Send daily learning emails to yourself or SaaS users using Gmail, with state tracked in Google Sheets.

Technical details

• Nodes / tools: set, code, gmail, sticky note, form trigger, google sheets.
• Integrations: Google Gemini (Google AI), Google Sheets OAuth, Gmail.
• Required sheet columns: term, reading, meaning, example, grammar_note, date_added, last_sent.
• Configuration: update the Spreadsheet ID and Sheet Name in both capture and digest steps so the workflow writes and reads the same vocabulary sheet.