Extract sheet data and send intelligent email messages
Workflow Description
Smart automation that reads data from Google Sheets periodically, processes it with an OpenAI-powered AI agent, and sends personalized emails via Gmail based on spreadsheet content and defined conditions.
How it works
- 1.Schedule periodic checks for Google Sheets data updates
- 2.Process data using an AI agent that understands context and makes decisions
- 3.Split data into batches and apply logical conditions
- 4.Generate email content through OpenAI language model
- 5.Send personalized messages via Gmail
Use cases
- Send daily client reports based on specific spreadsheet data
- Trigger smart email alerts when certain data conditions are met
- Distribute tailored offers to different customer segments from a sheet
Requirements
- Google Workspace account with access to Gmail and Google Sheets
- OpenAI API key to enable AI agent functionality
- Well-organized Google Sheet containing email recipients and content data
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 (21)
If
If
OpenAI Chat Model3
OpenAI
Agent Classification
Agent
Get Sustainability News
Google Sheets
Send to your mailing list
Gmail
Generate Email HTML
Code
Parse Article Blocks
HTML Page
Extract Articles Blocks
HTML Page
Trigger at 08:30 am
Schedule Trigger
Query EU News Website
HTTP Request
Split Out by Article Block
Split Out
Loop Over Articles
Split In Batches
Sustainability Flag
Set
Merge Article + Flag
Merge
Record Results
Google Sheets
Structured Output Parser
Output Parser Structured
Sticky Note1
Sticky Note
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note