Automated Quiz Delivery from Google Sheets to Telegram with Status Tracking

Description

Overview
This workflow automates quiz delivery from a Google Sheet directly into a Telegram group. It ensures that quizzes are posted one by one as polls, and once a quiz is sent, its status in the sheet is automatically updated to prevent duplication. If no pending quiz is available, the workflow notifies a separate Telegram channel to refill the sheet.

Target Audience
This template is designed for teachers, community managers, and Telegram group admins who want an easy way to run quizzes, trivia games, or knowledge checks without manual posting.

Problem It Solves
Manually sending quizzes is repetitive and prone to mistakes (like re-posting the same question). This template ensures quizzes are sent in order, tracked, and managed automatically with minimal human effort.

Requirements
An active Google account with Google Sheets enabled
A Telegram bot token (via BotFather)
Chat IDs for both the quiz group and the notification group

Google Sheet Structure
Create a sheet with the following columns:
quiz_number | question | option_a | option_b | option_c | option_d | status

status**: Use 🟨 for pending quizzes, ✅ once completed

Setup Instructions
Copy the workflow into your n8n instance.
Add your Google Sheets credentials.
Replace the YOUR_SHEET_ID placeholder with your sheet ID.
Set environment variables:
TELEGRAM_BOT_TOKEN
TELEGRAM_CHAT_ID (for the group)
TELEGRAM_NOTIFY_CHAT_ID (for refill notifications)
Run the workflow.

Customization Options
Adjust the sheet name if not using “Sheet1”
Change emoji markers (🟨 / ✅) to your preferred system
Modify the Telegram notification message