Generate & post unique MCQ polls to Telegram with Gemini AI and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every 3 hours) (plus 1 other trigger). Along the way it connects Google Sheets and Google Gemini Chat Model. It also calls api.telegram.org over HTTP.
How it runs
Trigger: On a schedule (every 3 hours) (plus 1 other trigger).
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 2 tools (Get row(s) in sheet in Google Sheets, Append or update row in sheet in Google Sheets); memory: Simple Memory
- Read Quiz Data (Google Sheets): uses Google Sheets
- Check New Quiz Added (If): checks a condition and branches into true / false
- Send Telegram Poll (HTTP Request): calls api.telegram.org (POST)
- Aggregate: combines items into one
- Update Quiz Status (Google Sheets): update
Services it uses
HTTP calls to: api.telegram.org
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 (10)
- Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - If
n8n-nodes-base.if - Aggregate
n8n-nodes-base.aggregate
From the author
This template provides a complete, two-part automation system for exam preparation providers, educators, or content creators to automatically generate unique Multiple-Choice Questions (MCQs) on a specific syllabus, save them to Google Sheets, and publish them…