Track customer email commitments with Gmail, OpenRouter and Google Sheets

by Olivier ✓ · 0 views · created 2026-07-27 · Document Extraction, AI Summarization

What this workflow does

This workflow has 23 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Gmail and Google Sheets. It also calls openrouter.ai over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).

1. Set Scan Mode (Edit Fields (Set)): sets 1 field: executionMode
2. Set Reminder Mode (Edit Fields (Set)): sets 1 field: executionMode
3. Set Template Fields (Edit Fields (Set)): sets 13 fields: internalDomains, gmailSearchQuery, processedGmailLabel…
4. Is Daily Reminder Run (If): checks a condition and branches into true / false
5. Read Commitment Register (Google Sheets): uses Google Sheets
6. Search Sent Customer Emails (Gmail): get many (message)
7. Prepare Daily Promise Actions (Code): runs custom JavaScript code
8. Prepare Sent Customer Messages (Code): runs custom JavaScript code
9. Send Daily Promise Action List (Gmail): uses Gmail
10. Build Commitment AI Request (Code): runs custom JavaScript code

…plus 10 more steps. See the full node list below.

Services it uses

GmailGoogle Sheets

HTTP calls to: openrouter.ai

Before you upgrade to n8n 3.0

Nodes used (8)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets

From the author

Quick overview This workflow scans sent Gmail messages on a schedule, uses OpenRouter (LLM via HTTP) to extract explicit customer commitments, and logs them to Google Sheets with status and traceability links, then emails daily due-soon/overdue reminders and…

View the original on n8n.io → Check your own copy