Track and chase email promises with Gmail, Google Sheets and OpenAI
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 49 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Workflow Config (Code): runs custom JavaScript code
- Demo inbox emails (Code): runs custom JavaScript code
- Lane entry (Switch): routes items into 2 branches
- Demo extract (mirrors AI contract) (Code): runs custom JavaScript code
- Read ledger rows (Google Sheets): uses Google Sheets
- Fetch new inbox emails (Gmail): get many
- Route intake (Switch): routes items into 4 branches
- Run digest (Code): runs custom JavaScript code
- Classify aging (Code): runs custom JavaScript code
- Build extraction prompt (Code): runs custom JavaScript code
…plus 37 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in Extract promises (AI), Draft chase email (AI): replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) Extract promises (AI), Draft chase email (AI) | OpenAI node (AI section) |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail - OpenAI
n8n-nodes-base.openAi - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow monitors your Gmail inbox for promises people make, logs them to a Google Sheets “Commitments” ledger using OpenAI extraction, and runs a daily sweep to draft follow-up emails into a “Chase-Queue” tab for approval, with alerts and…