HumationHuman + Automation
Back to Catalog

Automated quiz delivery from Google Sheets to Telegram with status tracking

Ninja - AbbasNinja - Abbas
484 views
2/3/2026
AI VisionWebhook TriggerImage AnalysisGoogle GeminiAPI Integration
Official Page

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

  1. Copy the workflow into your n8n instance.
  2. Add your Google Sheets credentials.
  3. Replace the YOUR_SHEET_ID placeholder with your sheet ID.
  4. Set environment variables:
    • TELEGRAM_BOT_TOKEN
    • TELEGRAM_CHAT_ID (for the group)
    • TELEGRAM_NOTIFY_CHAT_ID (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

Automated Quiz Delivery from Google Sheets to Telegram with Status Tracking

This n8n workflow automates the process of delivering quizzes from a Google Sheet to a Telegram channel or chat, while also tracking the delivery status back in the Google Sheet. It's designed for educational or engagement purposes where quizzes need to be regularly distributed and their status monitored.

What it does

  1. Reads Quiz Data: Fetches quiz questions and related information from a specified Google Sheet.
  2. Prepares Quiz Message: Formats the retrieved quiz data into a message suitable for Telegram.
  3. Sends Quiz to Telegram: Posts the prepared quiz message to a designated Telegram chat or channel.
  4. Updates Google Sheet: Records the delivery status (e.g., "Sent") back into the Google Sheet for the corresponding quiz entry.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Google Sheets Account: A Google account with access to the Google Sheet containing your quiz data.
    • Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth2 recommended).
  • Telegram Account: A Telegram account and a Bot Token.
    • Telegram Bot: A Telegram bot set up via BotFather.
    • Telegram Credential: An n8n credential configured for Telegram (Bot Token).
    • Telegram Chat ID: The Chat ID of the Telegram channel or group where the quizzes will be sent.

Setup/Usage

  1. Import the workflow: Download the JSON provided and import it into your n8n instance.
  2. Configure Credentials:
    • Update the "Google Sheets" node with your Google Sheets credential.
    • Update the "Telegram" node with your Telegram credential.
  3. Configure Google Sheets Node (ID: 18):
    • Specify the Spreadsheet ID of your quiz sheet.
    • Specify the Sheet Name where the quiz data is located.
    • Ensure the operation is set to "Read Data" or similar, to fetch the quiz questions.
  4. Configure Code Node (ID: 834):
    • This node is likely responsible for formatting the quiz data into a Telegram-friendly message. You may need to adjust the JavaScript code within this node to match the column names of your Google Sheet and the desired message format.
  5. Configure Telegram Node (ID: 49):
    • Set the Chat ID to the target Telegram chat or channel.
    • Verify the Message field uses expressions to pull the formatted quiz data from the preceding "Code" node.
  6. Configure If Node (ID: 20):
    • This node is typically used for conditional logic, such as checking if a quiz has already been sent. Review its conditions and adjust them based on your tracking column in Google Sheets.
  7. Configure Edit Fields (Set) Node (ID: 38):
    • This node is likely used to prepare the data for updating the Google Sheet. Ensure it sets the correct values (e.g., "Sent" status) for the update operation.
  8. Configure HTTP Request Node (ID: 19):
    • This node is used to update the Google Sheet with the delivery status.
    • Set the Method to PUT or POST (depending on the Google Sheets API method used for updating).
    • Set the URL to the Google Sheets API endpoint for updating a specific row/cell.
    • Ensure the Body contains the data to be updated, referencing the output from the "Edit Fields" node.
    • You might need to add appropriate Headers for authentication if not handled by the Google Sheets credential directly.
  9. Activate the workflow: Once configured, activate the workflow to start automating your quiz delivery. You might want to set up a schedule trigger (not included in this JSON) to run it periodically.

Note: The provided JSON only defines the nodes and their connections, not the specific configurations (like Spreadsheet ID, Chat ID, or detailed code). You will need to fill in these details based on your specific use case and Google Sheet structure. The Sticky Note (ID: 565) serves as a documentation element within the workflow itself.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Daily cash flow reports with Google Sheets, Slack & Email for finance teams

Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
619

Create verified user profiles with email validation, PDF generation & Gmail delivery

Verified User Profile Creation - Automated Email Validation & PDF Generation --- Overview This comprehensive automation workflow streamlines the user onboarding process by validating email addresses, generating professional profile PDFs, and delivering them seamlessly to verified users. 🎯 What This Workflow Does: Receives User Data - Webhook trigger accepts user signup information (name, email, city, profession, bio) Validates Email Addresses - Uses VerifiEmail API to ensure only legitimate email addresses proceed Conditional Branching - Smart logic splits workflow based on email verification results Generates HTML Profile - Creates beautifully styled HTML templates with user information Converts to PDF - Transforms HTML into professional, downloadable PDF documents Email Delivery - Sends personalized welcome emails with PDF attachments to verified users Data Logging - Records all verified users in Google Sheets for analytics and tracking Rejection Handling - Notifies users with invalid emails and provides guidance ✨ Key Features: ✅ Email Verification - Prevents fake registrations and maintains data quality 📄 Professional PDF Generation - Beautiful, branded profile documents 📧 Automated Email Delivery - Personalized welcome messages with attachments 📊 Google Sheets Logging - Complete audit trail of all verified users 🔀 Smart Branching - Separate paths for valid and invalid emails 🎨 Modern Design - Clean, responsive HTML/CSS templates 🔒 Secure Webhook - POST endpoint for seamless form integration 🎯 Perfect Use Cases: User registration systems Community membership verification Professional certification programs Event registration with verified attendees Customer onboarding processes Newsletter signup verification Educational platform enrollments Membership card generation 📦 What's Included: Complete workflow with 12 informative sticky notes Pre-configured webhook endpoint Email verification integration PDF generation setup Gmail sending configuration Google Sheets logging Error handling guidelines Rejection email template 🛠️ Required Integrations: VerifiEmail - For email validation (https://verifi.email) HTMLcsstoPDF - For PDF generation (https://htmlcsstopdf.com) Gmail OAuth2 - For email delivery Google Sheets OAuth2 - For data logging ⚡ Quick Setup Time: 15-20 minutes 🎓 Skill Level: Beginner to Intermediate --- Benefits: ✅ Reduces manual verification work by 100% ✅ Prevents spam and fake registrations ✅ Delivers professional branded documents automatically ✅ Maintains complete audit trail ✅ Scales effortlessly with user growth ✅ Provides excellent user experience ✅ Easy integration with any form or application --- Technical Details: Trigger Type: Webhook (POST) Total Nodes: 11 (including 12 documentation sticky notes) Execution Time: ~3-5 seconds per user API Calls: 3 external (VerifiEmail, HTMLcsstoPDF, Google Sheets) Email Format: HTML with binary PDF attachment Data Storage: Google Sheets (optional) --- License: MIT (Free to use and modify) --- 🎁 BONUS FEATURES: Comprehensive sticky notes explaining each step Beautiful, mobile-responsive email template Professional PDF styling with modern design Easily customizable for your branding Ready-to-use webhook endpoint Error handling guidelines included --- Perfect for: Developers, No-code enthusiasts, Business owners, SaaS platforms, Community managers, Event organizers Start automating your user verification process today! 🚀

Jitesh DugarBy Jitesh Dugar
51