Developer & DevOps
Connect Google Sheets with Gmail
12 nodes
196
107
Scheduled trigger
Workflow Description
A scheduled automation template that reads data from Google Sheets, applies filtering logic, and sends formatted email notifications via Gmail at predetermined intervals. Ideal for regular reporting and conditional alerts.
How it works
- 1.Initialize the scheduled trigger to run at specified time intervals
- 2.Retrieve rows and data from the connected Google Sheets document
- 3.Filter the extracted data based on defined conditions to identify target records
- 4.Merge and format the processed data into a structured email message
- 5.Send the formatted email through Gmail to designated recipients
Use cases
- Send periodic reports with updated data extracted from spreadsheets
- Trigger automatic notifications when specific records in Sheets meet criteria
Requirements
- Active Google account with connected Google Sheets and Gmail access
- Read and write permissions for both spreadsheet and email operations
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
196
Downloads
107
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