Build a Telegram Bot for AI-Powered UPSC Mains Answer Evaluation (Google Sheets + Gemini AI)

Job Details

Description

Summary I need a Telegram bot workflow built that automatically evaluates UPSC Mains exam answers using AI and tracks results in Google Sheets. This is for an exam-prep product aimed at UPSC (Indian civil services) aspirants. How it should work: A user submits their written answer to a practice question via a Telegram command (e.g. /answer their answer text) The bot matches the submission to the correct open question stored in a Google Sheet (supporting both "reply to the original question" matching and a fallback to the most recent unanswered question) The answer is sent to Google's Gemini API with a structured evaluation prompt based on UPSC marking criteria (content relevance, structure, keyword usage, examples/evidence, word count adherence) Gemini returns a JSON-structured score breakdown, strengths, areas to improve, and a model-answer outline The bot replies to the user in Telegram with a formatted score card The Google Sheet is updated with the user's answer, score, and feedback. Deliverables: Fully working, tested workflow (exported/documented so I can review the logic) Test run showing an end-to-end submission → evaluation → reply cycle Short documentation of the node structure and any setup steps (API keys, bot registration, sheet permissions) Ideal freelancer: Strong experience building on Pipedream, n8n, Make.com, or Zapier Comfortable writing custom JavaScript/code nodes within a workflow builder Experience with Telegram Bot API and Google Sheets API Bonus: experience designing reliable prompts/parsing for LLM JSON outputs.

Skills

Notification History

User Actions