Send AI study reports and spaced-repetition reminders via OpenAI, Sheets and Gmail
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 workflow has 12 nodes and runs when someone submits an n8n form (“Daily Study Log”) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail. It also calls api.openai.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Daily Study Log”) (plus 1 other trigger).
- 2. Code - Validate and Calc Revision Dates (Code): runs custom JavaScript code
- 9. Sheets - Read All Logs (Morning) (Google Sheets): get many
- 3. HTTP - AI Analyze Session (HTTP Request): calls api.openai.com (POST)
- 10. Code - Find Revision Topics and Build Morning Email (Code): runs custom JavaScript code
- 4. Code - Parse AI Response and Merge Data (Code): runs custom JavaScript code
- 11. Gmail - Send Morning Reminder (Gmail): uses Gmail
- 5. Sheets - Read Existing Logs (Google Sheets): get many
- 6. Code - Build Complete Email HTML (Code): runs custom JavaScript code
- 7. Sheets - Save Session to Log (Google Sheets): append
- 8. Gmail - Send Full Daily Report (Gmail): uses Gmail
Services it uses
HTTP calls to: api.openai.com
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 (6)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This dual-trigger workflow logs daily study sessions from an n8n Form, analyzes them with OpenAI, stores results in Google Sheets, and emails a full coaching report via Gmail; it also runs daily at 7 AM to email each student revision reminders…