{"product_id":"n8n-word-of-the-day-gemini-google-sheets-daily-email","title":"n8n Word of the Day: Gemini + Google Sheets Daily Email","description":"\u003ch3\u003eTurn your submitted vocab into a daily “Word of the Day” email—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures new vocabulary through an n8n Form, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate structured study notes, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and then sends you a scheduled HTML “word of the day” via \u003cstrong\u003eGmail\u003c\/strong\u003e—updating the sheet so you don’t repeat words.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects inputs\u003c\/strong\u003e: Receives a submission from an \u003cstrong\u003en8n Form\u003c\/strong\u003e containing a word, phrase, sentence, or grammar pattern to study.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a study card with Gemini\u003c\/strong\u003e: Sends the submitted text to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e using your target language and level, requesting a \u003cem\u003estructured JSON\u003c\/em\u003e response (term, reading, meaning, example, and grammar note).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores everything in Google Sheets\u003c\/strong\u003e: Parses Gemini’s fields and appends them as a new row with metadata like \u003cstrong\u003edate_added\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a daily review\u003c\/strong\u003e: 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery + tracking\u003c\/strong\u003e: Sends the selected entry as an HTML “word of the day” email via \u003cstrong\u003eGmail\u003c\/strong\u003e, then updates the corresponding row’s \u003cstrong\u003elast_sent\u003c\/strong\u003e date.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a lightweight vocabulary pipeline for self-study or team language learning.\u003c\/li\u003e\n  \u003cli\u003eHave Gemini generate consistent grammar notes and examples from words you collect in real time.\u003c\/li\u003e\n  \u003cli\u003eSend daily learning emails to yourself or SaaS users using Gmail, with state tracked in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tools\u003c\/strong\u003e: set, code, gmail, sticky note, form trigger, google sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Gemini (Google AI), Google Sheets OAuth, Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet columns\u003c\/strong\u003e: term, reading, meaning, example, grammar_note, date_added, last_sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration\u003c\/strong\u003e: update the \u003cem\u003eSpreadsheet ID\u003c\/em\u003e and \u003cem\u003eSheet Name\u003c\/em\u003e in both capture and digest steps so the workflow writes and reads the same vocabulary sheet.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46001837244595,"sku":"N8N-19481","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gOBYmIwGhv-QD3EY7DHWR_3QAu3IEL.png?v=1789117324","url":"https:\/\/buyflowscripts.com\/products\/n8n-word-of-the-day-gemini-google-sheets-daily-email","provider":"N8N Commerce","version":"1.0","type":"link"}