Gmail Commitments Tracker: OpenAI to Google Sheets Chase Emails

Turn Gmail promises into a live “Commitments” pipeline—then chase them automatically

Gmail Commitments Tracker: OpenAI to Google Sheets Chase Emails scans your inbox for concrete commitments, logs them into a Google Sheets ledger, and at 08:00 drafts follow-up chase emails for anything due or overdue—ready for your approval. You also get alerts when the AI output needs review, plus a daily digest of what’s coming due.

What this workflow does

• Runs hourly on a schedule: inbox intake runs every hour, and a daily sweep triggers at 08:00 (workflow timezone).
• Gmail intake & AI extraction: fetches recent unprocessed Gmail messages, builds an extraction prompt from the email content, and uses OpenAI to determine whether the message contains a concrete promise or fulfills an existing one.
• Updates Google Sheets “Commitments”: writes new promises into the Commitments tab using a dedupe key, or marks the oldest matching open commitment as done when a fulfillment email is detected.
• Prevents reprocessing: labels processed Gmail messages with your configured label.
• Human-in-the-loop alerts: emails the owner when the AI output is unparseable, missing a due date, or otherwise needs review.
• 08:00 chase classification & drafting: reads all commitment rows and classifies each active item as due today, overdue, 3+ days overdue (escalate), on track, or closed.
• Creates follow-up drafts for approval: drafts follow-up emails for due-today and overdue items, stores them in Google Sheets “Chase-Queue” as pending approval, notifies the owner by Gmail, and updates status/chase count.
• Daily digest: sends a summary email of what’s due.

Use cases

• Track sales, partnerships, or customer commitments directly from incoming emails.
• Automate reminder follow-ups without manually searching your inbox.
• Ensure urgent items (including 3+ days overdue) get escalated.

Technical details

• n8n workflow nodes: if, code, gmail, merge, open ai, switch.
• Integrations: Gmail + OpenAI + Google Sheets (“Commitments” and “Chase-Queue”).
• Core logic: deduplication via dedupe key, fulfillment detection, labeling to avoid reprocessing, and AI-driven email drafting.