Automate car service reminders and replies with Google Sheets, Gemini 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 31 nodes and runs on a schedule (every day at 09:00) (plus 2 other triggers). Along the way it connects Gmail, Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (every day at 09:00) (plus 2 other triggers).
- Set Service Parameters (Edit Fields (Set)): sets 12 fields: shop_name, shop_phone, booking_link…
- Alert Owner of Failure (Gmail): uses Gmail
- Read Customers Sheet (Google Sheets): uses Google Sheets
- Route by Trigger (If): checks a condition and branches into true / false
- Pick Today's Emails (Code): runs custom JavaScript code
- Match Replies to Customers (Code): runs custom JavaScript code
- Loop Over Customers (Loop Over Items (Split in Batches)): loops over the items in batches
- Detect Intent with Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Intent Model
- Build Daily Report (Code): runs custom JavaScript code
- Write Email with Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Writer Model
…plus 15 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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Reply Trigger).
Nodes used (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow runs every morning, reads auto repair customer data from Google Sheets, uses Google Gemini to draft service-due reminder emails, and sends them via Gmail (or a test copy to the shop owner) while logging sent reminders back to the…