Send daily JLPT kanji-safe lessons to Microsoft Teams with Sheets and Claude
Ready for 3.0What this workflow does
This AI workflow has 18 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets and AWS Bedrock Chat Model.
How it runs
Trigger: On a schedule (every day at 08:00).
- Set Configuration Values (Edit Fields (Set)): sets 5 fields: jlpt_level, sheet_url, teams_webhook_url…
- Read Learned Kanji from Sheets (Google Sheets): uses Google Sheets
- Read Used Grammar from Sheets (Google Sheets): uses Google Sheets
- Read Grammar Bank from Sheets (Google Sheets): uses Google Sheets
- Prepare Lesson Context (Code): runs custom JavaScript code
- Create Lesson Draft (Basic LLM Chain): sends a prompt to an LLM, with model: Select Lesson AI Model; output parser: Define Lesson Output Format
- Validate Lesson Draft (Code): runs custom JavaScript code
- Refine and Proofread Lesson (Basic LLM Chain): sends a prompt to an LLM, with model: Select Proofreading AI Model; output parser: Define Proofreading Format
- Verify Kanji in Lesson (Code): runs custom JavaScript code
- Construct Teams Message Card (Code): runs custom JavaScript code
…plus 3 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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - AWS Bedrock Chat Model
@n8n/n8n-nodes-langchain.lmChatAwsBedrock - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow runs daily, reads your learned kanji and JLPT grammar lists from Google Sheets, uses an AWS Bedrock chat model to generate and proofread a lesson constrained to known kanji, then posts it as a Microsoft Teams Adaptive Card and…