Gmail Commitment Tracker: n8n + OpenRouter to Google Sheets

Turn Gmail promises into an actionable commitment tracker—automatically.

This n8n workflow scans your Gmail Sent Mail, uses OpenRouter (LLM via HTTP) to extract explicit customer commitments, logs them into Google Sheets, and sends daily due-soon/overdue reminders and escalation notices through Gmail.

What this workflow does

• Hourly / manual run: Searches Gmail Sent Mail for unprocessed messages that match your query.
• Pre-filters messages: Excludes internal/automated recipients and ignores empty messages before analysis.
• Extracts commitments with OpenRouter: Sends eligible email content to OpenRouter chat completions to extract a structured commitment including:
  • Action
  • Exact promise
  • Owner
  • Due date
  • Confidence score
• Prevents re-scanning: Labels assessed emails with a processed label.
• Updates Google Sheets register: Appends rows to a “Commitments” tab with extracted fields, confidence, status, and traceability links back to the source message.
• Gmail notifications:
  • Emails the reviewer when confidence is low or due dates are unclear.
  • Emails the commitment owner for open items.
• Weekday morning reminders: 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.

Use cases

• SaaS teams tracking customer commitments made in email so nothing slips.
• Automation engineers standardizing commitment extraction across inbox communication.
• Operators maintaining a single, auditable Google Sheets register with message-level traceability.

Technical details

• Scheduling: Hourly scanning (and weekday morning review/reminder runs).
• Integrations: Gmail (read sent messages, apply labels, send notifications) and Google Sheets (append and read commitment rows).
• OpenRouter access: HTTP request to OpenRouter’s chat completions API for structured extraction.
• n8n nodes used: if, set, code, gmail, http request, sticky note.