{"product_id":"gmail-commitment-tracker-n8n-openrouter-to-google-sheets","title":"Gmail Commitment Tracker: n8n + OpenRouter to Google Sheets","description":"\u003ch3\u003eTurn Gmail promises into an actionable commitment tracker—automatically.\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your \u003cstrong\u003eGmail Sent Mail\u003c\/strong\u003e, uses \u003cstrong\u003eOpenRouter\u003c\/strong\u003e (LLM via HTTP) to extract explicit customer commitments, logs them into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003edaily due-soon\/overdue reminders\u003c\/strong\u003e and escalation notices through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHourly \/ manual run\u003c\/strong\u003e: Searches Gmail \u003cem\u003eSent Mail\u003c\/em\u003e for unprocessed messages that match your query.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePre-filters messages\u003c\/strong\u003e: Excludes internal\/automated recipients and ignores empty messages before analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts commitments with OpenRouter\u003c\/strong\u003e: Sends eligible email content to OpenRouter chat completions to extract a structured commitment including:\n    \u003cul\u003e\n      \u003cli\u003eAction\u003c\/li\u003e\n      \u003cli\u003eExact promise\u003c\/li\u003e\n      \u003cli\u003eOwner\u003c\/li\u003e\n      \u003cli\u003eDue date\u003c\/li\u003e\n      \u003cli\u003eConfidence score\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents re-scanning\u003c\/strong\u003e: Labels assessed emails with a processed label.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets register\u003c\/strong\u003e: Appends rows to a “\u003cstrong\u003eCommitments\u003c\/strong\u003e” tab with extracted fields, confidence, status, and traceability links back to the source message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail notifications\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eEmails the reviewer when confidence is low or due dates are unclear.\u003c\/li\u003e\n      \u003cli\u003eEmails the commitment owner for open items.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekday morning reminders\u003c\/strong\u003e: Reads open\/rescheduled rows in Google Sheets and sends each owner a due-soon\/overdue action list; escalates overdue items to the manager after the configured delay.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams tracking customer commitments made in email so nothing slips.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing commitment extraction across inbox communication.\u003c\/li\u003e\n  \u003cli\u003eOperators maintaining a single, auditable \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e register with message-level traceability.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling\u003c\/strong\u003e: Hourly scanning (and weekday morning review\/reminder runs).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eGmail\u003c\/strong\u003e (read sent messages, apply labels, send notifications) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (append and read commitment rows).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenRouter access\u003c\/strong\u003e: HTTP request to OpenRouter’s chat completions API for structured extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: if, set, code, gmail, http request, sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738542170291,"sku":"N8N-17538","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EKxvKFR3AGtqQLLXBT0bl_eiyWurc0.png?v=1785229909","url":"https:\/\/buyflowscripts.com\/products\/gmail-commitment-tracker-n8n-openrouter-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}