Extract sheet data and send intelligent emails via Gmail
Workflow Description
An automation that runs on a schedule to read data from Google Sheets, process it through Gemini's intelligent model, and automatically send personalized Gmail messages. No manual intervention required.
How it works
- 1.Read data rows from your configured Google Sheets worksheet
- 2.Batch and process records through an LLM Chain for analysis
- 3.Evaluate and format outputs using Gemini AI intelligence
- 4.Send customized Gmail messages based on processing results
Use cases
- Automatically send personalized client reports from spreadsheet data
- Automate follow-up outreach with AI-powered, context-aware emails
- Process requests or inquiries from a sheet and send intelligent responses
Requirements
- Google account with access to Sheets and Gmail services
- Gemini API key or direct integration configured in n8n
- Structured data in Google Sheets ready for processing and delivery
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (17)
Scheduled Start: Daily Churn Check
Schedule Trigger
Fetch Customer Data from Sheet
Google Sheets
Filter High Churn Risk & No Campaign Customers
Filter
Check if Eligible Customers Found
If
Process Each Eligible Customer
Split In Batches
Generate Win-Back Offer
LLM Chain
(LLM Model for Offer Generation)
Gemini Model
(Parse Offer JSON)
Output Parser Structured
Log Sent Offer in System Log
Google Sheets
Send Win-Back Offer via Email
Gmail
Set 'Not Found' Status
Set
Log 'Not Found' in System Log
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note