Templates / Automated quiz delivery from Google Sheets to Telegram with status tracking

Automated quiz delivery from Google Sheets to Telegram with status tracking

Ready for 3.0

by Ninja - Abbas · 838 views · created 2025-08-17 · Social Media, Multimodal AI

Ready 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.

Nodes used (6)

Google SheetsTelegram

What it does

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: quiznumber | question | optiona | optionb | optionc | optiond | status - status: Use 🟨 for pending quizzes, ✅ once completed Setup Instructions 1. Copy the workflow into your n8n instance. 2. Add your Google Sheets credentials. 3. Replace the YOURSHEETID placeholder with your sheet ID. 4. Set environment variables: - TELEGRAMBOTTOKEN - TELEGRAMCHATID (for the group) - TELEGRAMNOTIFYCHATID (for refill notifications) 5. 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

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.