{"product_id":"gmail-school-circular-summarizer-with-gemini-sheets","title":"Gmail School Circular Summarizer with Gemini + Sheets","description":"\u003ch3\u003eTurn school circular PDFs into parent-ready summaries—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eGmail School Circular Summarizer with Gemini + Sheets\u003c\/strong\u003e monitors a labeled \u003cstrong\u003eGmail\u003c\/strong\u003e inbox for school circulars, extracts text from attached PDFs, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to produce a structured, parent-friendly digest, prevents duplicates with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails the final summary to a parent address.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks Gmail every hour\u003c\/strong\u003e for new emails inside your specified label (using a Gmail trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes email metadata\u003c\/strong\u003e and detects whether the message includes an attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the attachment from Gmail\u003c\/strong\u003e and \u003cstrong\u003eextracts text from the attached PDF\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf PDF text extraction is incomplete, \u003cstrong\u003ecreates fallback text\u003c\/strong\u003e so the workflow can continue reliably.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a stable fingerprint\u003c\/strong\u003e for each circular and \u003cstrong\u003elooks it up in Google Sheets\u003c\/strong\u003e to avoid sending the same circular multiple times.\u003c\/li\u003e\n  \u003cli\u003eFor new circulars, \u003cstrong\u003esends the finalized text to Google Gemini\u003c\/strong\u003e to extract \u003cstrong\u003estructured fields\u003c\/strong\u003e (e.g., dates, fees, actions) and produce both a \u003cstrong\u003eshort and detailed digest\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the structured record to Google Sheets\u003c\/strong\u003e, then \u003cstrong\u003eemails the formatted summary via Gmail\u003c\/strong\u003e to the parent recipient.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSchool admins who want to convert circular PDFs into consistent updates for parents without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an n8n workflow for document-to-digest pipelines (Gmail → PDF text → Gemini → email).\u003c\/li\u003e\n  \u003cli\u003eSaaS operators needing de-duplication and audit logging for recurring inbound communications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail Trigger\u003c\/strong\u003e (checks a specific label hourly) + Gmail sending step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration for circular logging and duplicate checks.\u003c\/li\u003e\n  \u003cli\u003eNode usage including: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (PaLM\/Gemini) for structured extraction and digest generation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e connect Gmail, set the trigger label, connect Gemini credentials and choose the model, and provide your Google Sheets spreadsheet ID, sheet name, and columns for the circular log\/duplicate fingerprint.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978930544819,"sku":"N8N-19317","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/d6vVu5KwVRHRtTgA0bRGs_3bJ52ZBm.png?v=1788859750","url":"https:\/\/buyflowscripts.com\/products\/gmail-school-circular-summarizer-with-gemini-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}