Send renewal reminder ladder with Google Sheets, GPT-4.1-mini and Slack
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 17 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets, OpenAI Chat Model, Gmail and Google Calendar and 1 more.
How it runs
Trigger: On a schedule (every day at 09:00).
- Read Renewal Sheet (Google Sheets): uses Google Sheets
- Normalize Renewal Rows (Code): runs custom JavaScript code
- Score Risk and Pick Stage (Code): runs custom JavaScript code
- Any Reminders Due? (If): checks a condition and branches into true / false
- Loop Over Renewals (Loop Over Items (Split in Batches)): loops over the items in batches
- Collect Processed Rows (Aggregate): combines items into one
- Renewal Email Writer (AI Agent): runs an AI agent, with model: Email Writing Model; output parser: Email Output Format
- Build Daily Digest (Code): runs custom JavaScript code
- Send Renewal Email (Gmail): uses Gmail
- Post Digest to Slack (Slack): uses Slack
…plus 3 more steps. See the full node list below.
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 (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Google Calendar
n8n-nodes-base.googleCalendar - Aggregate
n8n-nodes-base.aggregate - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs daily to read renewal data from Google Sheets, calculate reminder stages and renewal risk, use OpenAI to draft tailored reminder emails, send them via Gmail, optionally book high-risk save calls in Google Calendar, and post a…