Developer & DevOps
Send personalized emails from Google Sheets data
12 nodes
274
124
Scheduled trigger
Workflow Description
This automation reads data from Google Sheets on a scheduled basis, applies filters to select specific rows, and sends customized emails through Gmail to recipients listed in the spreadsheet. It eliminates manual email distribution and ensures consistent, timely communication.
How it works
- 1.Trigger automation on a predefined schedule
- 2.Extract rows from the connected Google Sheets spreadsheet
- 3.Apply filters to select rows matching specified criteria
- 4.Merge and format filtered data into email content
- 5.Send emails via Gmail to addresses specified in the sheet
Use cases
- Send weekly or monthly reports automatically to team members from a centralized Google Sheet
- Distribute notifications to clients based on status changes recorded in a spreadsheet
- Trigger personalized email campaigns to prospects or customers using data from Google Sheets
Requirements
- Google Workspace account with API integration permissions
- Google Sheets file populated with recipient email addresses and message content
- Gmail account connected to a Google Cloud project with proper authentication
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Sheets
Gmail
Details
Trigger
Scheduled trigger
Nodes
12
Apps
2
Views
274
Downloads
124
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 (12)
/
Filter Status (Waiting for sending)
Filter
Set data
Set
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Schedule Trigger
Schedule Trigger
Retrieve Customer Messages Data
Google Sheets
Update Message Status
Google Sheets
Send a message (Gmail)
Gmail
Merge fields
Merge