Chase missing client documents from Google Sheets with OpenAI and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs on a schedule (cron 0 8 * * 1-5). Along the way it connects Google Sheets, OpenAI and Gmail.
How it runs
Trigger: On a schedule (cron 0 8 * * 1-5).
- Settings (Edit Fields (Set)): sets 6 fields: sheetId, firmName, replyTo…
- Get open requests (Google Sheets): uses Google Sheets
- Work out the next step (Edit Fields (Set)): sets 3 fields: remindersSent, daysSinceLast, step
- Is a message due? (If): checks a condition and branches into true / false
- Write the email (OpenAI): uses OpenAI
- Send the email (Gmail): uses Gmail
- Record the reminder (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs every weekday morning to read open document requests from Google Sheets, uses OpenAI to draft reminder emails in your firm’s tone, sends them via Gmail, and updates the sheet with the last-sent date and reminder count. How it…