{"product_id":"n8n-auto-grade-pdfs-with-openai-drive-sheets-gmail-telegram","title":"n8n: Auto Grade PDFs with OpenAI, Drive, Sheets \u0026 Gmail + Telegram","description":"\u003ch3\u003eAuto-grade new PDF assignments automatically—then email students and send a daily teacher summary via Gmail + Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for newly uploaded PDF submissions, extracts their text with OpenAI, grades them using a rubric stored in Google Docs, records results in Google Sheets, notifies students via Gmail, and delivers a daily grading summary to the teacher through both Gmail and Telegram. Errors are surfaced via Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eMonitors Google Drive:\u003c\/b\u003e Triggers when a new PDF file is created in a specified Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts PDF text:\u003c\/b\u003e Downloads the PDF and sends it to \u003cb\u003eOpenAI\u003c\/b\u003e to extract full plain-text content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIdentifies submission details:\u003c\/b\u003e Parses student name, email, assignment title, and course from the filename.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads grading rubric:\u003c\/b\u003e Fetches the rubric from a \u003cb\u003eGoogle Docs\u003c\/b\u003e document URL you configure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates structured grades:\u003c\/b\u003e Sends assignment text + rubric to OpenAI to produce a \u003cb\u003eJSON grade\u003c\/b\u003e with per-criterion scores and \u003cb\u003ethree feedback paragraphs\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs to Gradebook:\u003c\/b\u003e Parses returned JSON (with fallback defaults if parsing fails) and appends a complete record to \u003cb\u003eGoogle Sheets\u003c\/b\u003e (your spreadsheet ID and Gradebook sheet name).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEmails student feedback:\u003c\/b\u003e Sends a formatted \u003cb\u003eGmail\u003c\/b\u003e message including grade, score breakdown, and personalized feedback.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends daily teacher summary:\u003c\/b\u003e Runs every day at \u003cb\u003e6 PM\u003c\/b\u003e, summarizes today’s grading results from the Google Sheets Gradebook, and sends it to the teacher via \u003cb\u003eGmail\u003c\/b\u003e and \u003cb\u003eTelegram\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eInstructors auto-grading homework PDFs at scale while keeping consistent rubric-based scoring.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running education workflows that require audit-ready logging in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTeachers who want student feedback delivered immediately and a daily rollup for themselves.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n trigger:\u003c\/b\u003e Google Drive new file creation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNodes\/integrations:\u003c\/b\u003e if, code, gmail, slack, telegram, google docs (plus Google Drive + Google Sheets)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExternal AI:\u003c\/b\u003e OpenAI for PDF text extraction and rubric-based JSON grading\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScheduling:\u003c\/b\u003e Daily summary at 6 PM\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eError alerts:\u003c\/b\u003e Slack notifications\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetup requirements:\u003c\/b\u003e Configure Google Drive folder ID, Google Docs rubric document URL, Google Sheets spreadsheet ID + Gradebook sheet name, and connect credentials for Google Drive, Google Docs, Google Sheets, Gmail, Telegram, and Slack.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862248775859,"sku":"N8N-18322","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/f-dD9B3tNMqJkRHsEwdKS_GIi9Aw8F.png?v=1786957680","url":"https:\/\/buyflowscripts.com\/products\/n8n-auto-grade-pdfs-with-openai-drive-sheets-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}