{"product_id":"n8n-workflow-extract-syllabus-pdfs-with-gemini-plan-study","title":"n8n Workflow: Extract Syllabus PDFs with Gemini \u0026 Plan Study","description":"\u003ch3\u003eTurn syllabus PDFs into a study plan—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow downloads a syllabus PDF from Google Drive, extracts and cleans the text, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to find assignments and due dates, then creates \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e deadlines and study-session events—and logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual execution\u003c\/strong\u003e: Run it on demand by clicking \u003cem\u003eExecute workflow\u003c\/em\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch \u0026amp; extract\u003c\/strong\u003e: Downloads the syllabus PDF from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e and extracts its text content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClean for accuracy\u003c\/strong\u003e: Removes formatting noise to improve parsing and AI results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI assignment + due date detection\u003c\/strong\u003e: Sends the cleaned syllabus text to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to return a JSON list of assignments, due dates, and effort estimates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize the AI output\u003c\/strong\u003e: Parses the JSON, converts due dates to \u003cstrong\u003eISO format\u003c\/strong\u003e, applies default hours, and assigns a priority based on how soon each due date is.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate schedule + calendar events\u003c\/strong\u003e: Creates events for both the \u003cstrong\u003eassignment deadlines\u003c\/strong\u003e and \u003cstrong\u003estudy sessions\u003c\/strong\u003e for each assignment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLog to Google Sheets\u003c\/strong\u003e: Merges event data and appends a standardized row for each event into your configured \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab, then outputs a run summary with event counts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStudents or study planners who want a consistent \u003cstrong\u003estudy schedule\u003c\/strong\u003e from a new semester syllabus.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators\/automation engineers building study or training operations that rely on recurring PDF syllabi.\u003c\/li\u003e\n  \u003cli\u003eTeams who want a transparent audit trail of generated deadlines and sessions via \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ stack\u003c\/strong\u003e: code, merge, sticky note, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eManual Trigger\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI\u003c\/strong\u003e: Google PaLM \/ \u003cstrong\u003eGemini\u003c\/strong\u003e API to produce assignments + due dates in JSON\u003c\/li\u003e\n  \u003cli\u003eRequires credentials for Google Drive, Google Calendar, Google Sheets, and Gemini; update the Drive \u003cem\u003efile ID\u003c\/em\u003e; ensure calendar permissions; and set the Sheets columns to match the expected schema.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931005935795,"sku":"N8N-18986","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2kTmb5xtOVyyX9OUkmxdg_I11xpmmo.png?v=1788253474","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-extract-syllabus-pdfs-with-gemini-plan-study","provider":"N8N Commerce","version":"1.0","type":"link"}