Connect Google Sheets with Gmail
Workflow Description
Automated workflow that reads data from Google Sheets on a schedule, processes it through Gemini AI to extract and format relevant information, then sends customized emails via Gmail based on the analyzed results and applied conditions.
How it works
- 1.Scheduled trigger checks Google Sheets for new or updated rows
- 2.Batch processing applies filters to select relevant data records
- 3.LLM Chain with Gemini analyzes and transforms sheet data into structured insights
- 4.Conditional logic routes results based on defined criteria
- 5.Gmail sends personalized messages to specified recipients
Use cases
- Daily automated reports with AI-powered summaries of spreadsheet data
- Conditional notifications via email when specific sheet records are updated
- Distribute and format spreadsheet information to multiple contacts automatically
Requirements
- Google account with permissions for Sheets and Gmail access
- Organized spreadsheet with data rows and email address fields
- Valid API credentials or connection to Gemini language model service
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