{"product_id":"n8n-workflow-send-project-deadline-digest-emails-gmail-sheets","title":"n8n Workflow: Send Project Deadline Digest Emails (Gmail + Sheets)","description":"\u003ch3\u003eNever miss a project deadline—get an automatic weekday email digest from your Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads upcoming project deadlines from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, filters items due in the next \u003cstrong\u003e7 days\u003c\/strong\u003e (including \u003cstrong\u003eoverdue\u003c\/strong\u003e and \u003cstrong\u003edue today\u003c\/strong\u003e), and sends a single consolidated \u003cstrong\u003eHTML email via Gmail\u003c\/strong\u003e to keep your team focused. It also flags \u003cstrong\u003einvalid deadline dates\u003c\/strong\u003e and skips any closed\/completed projects.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on weekdays at 08:00\u003c\/strong\u003e (or you can start it manually in demo mode).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads rows\u003c\/strong\u003e from the \u003cstrong\u003eDeadlines\u003c\/strong\u003e sheet in Google Sheets (or generates fictional rows for safe testing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates deadline dates\u003c\/strong\u003e in \u003ccode\u003eYYYY-MM-DD\u003c\/code\u003e format; invalid dates are counted and included in a warning section.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips closed\/completed projects\u003c\/strong\u003e based on the \u003ccode\u003estatus\u003c\/code\u003e column.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates days remaining\u003c\/strong\u003e and keeps only deadlines due within the next 7 days.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSorts by urgency\u003c\/strong\u003e and builds a single consolidated HTML digest with counts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends through Gmail\u003c\/strong\u003e for scheduled runs, or returns the email \u003cstrong\u003esubject + HTML as JSON\u003c\/strong\u003e for demo runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops cleanly\u003c\/strong\u003e when there are no relevant deadlines to report.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators monitoring deliverables: “Send a daily digest of what’s due soon.”\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers testing schedule + email logic using demo mode and fictional deadline data.\u003c\/li\u003e\n  \u003cli\u003eTeams tracking work in Google Sheets and needing Gmail notifications without building a custom app.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2): reads from a sheet named \u003ccode\u003eDeadlines\u003c\/code\u003e with columns like \u003ccode\u003eproject_id\u003c\/code\u003e, \u003ccode\u003eproject_name\u003c\/code\u003e, \u003ccode\u003edeadline\u003c\/code\u003e, \u003ccode\u003eowner_email\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, \u003ccode\u003epriority\u003c\/code\u003e, and \u003ccode\u003enext_step\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2): sends the consolidated HTML digest to a configured recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, and \u003ccode\u003emanual trigger\u003c\/code\u003e (plus a sticky note for guidance).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814418440371,"sku":"N8N-18005","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6I76xnWcvRRjvu3btNpUp_QZceKfct.png?v=1786439398","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-send-project-deadline-digest-emails-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}