Automate Testing and Collect Responses via Telegram in Postgres (Module "Quiz")

Description

Who is this for?
This template is ideal for educators, HR professionals, and anyone looking to automate testing and collect responses through Telegram, while storing results in a Postgres database.

What problem is this workflow solving?
Manually organizing and managing tests can be time-consuming and prone to error. This workflow automates the test distribution, response collection, and scoring process, ensuring a seamless and efficient testing experience.

What this workflow does
Adds test content, including questions and answers, to a Postgres database
Sends a Telegram bot link to test participants
Automatically delivers the test via the Telegram bot
Collects and stores responses
Displays the participant's ranking at the end of the test

Setup
Create tables in Postgres
Replace "n8n" in the provided SQL script with the name of your actual schema
Run the script in your database to create the required tables

Add credentials
Set up and connect your Telegram credentials
Set up and connect your Postgres credentials

How to customize this workflow to your needs
Modify the test content directly in the Postgres database
Customize the Telegram bot messages to match your tone and branding.
Adjust scoring logic if needed to reflect different evaluation methods.