This workflow follows the Emailsend → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Email Automation - Daily Order Processing",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 24
}
]
}
},
"id": "e1f2a3b4-1111-2222-3333-444455556666",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.1,
"position": [
250,
300
]
},
{
"parameters": {
"operation": "getAll",
"documentId": {
"__rl": true,
"value": "YOUR_GOOGLE_SHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Orders",
"mode": "name"
},
"options": {}
},
"id": "f2a3b4c5-2222-3333-4444-555566667777",
"name": "Get Orders from Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
480,
300
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.status }}",
"value2": "Pending"
}
]
}
},
"id": "a3b4c5d6-3333-4444-5555-666677778888",
"name": "Filter Pending Orders",
"type": "n8n-nodes-base.filter",
"typeVersion": 1,
"position": [
710,
300
]
},
{
"parameters": {
"fromEmail": "your-email@gmail.com",
"toEmail": "={{ $json.customer_email }}",
"subject": "=Order Confirmation #{{ $json.order_id }}",
"emailType": "text",
"message": "=Hello {{ $json.customer_name }},\n\nYour order #{{ $json.order_id }} has been confirmed!\n\nOrder Details:\n- Product: {{ $json.product }}\n- Quantity: {{ $json.quantity }}\n- Total: ${{ $json.total }}\n\nThank you for your purchase!",
"options": {}
},
"id": "b4c5d6e7-4444-5555-6666-777788889999",
"name": "Send Confirmation Email",
"type": "n8n-nodes-base.emailSend",
"typeVersion": 2,
"position": [
940,
300
]
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "YOUR_GOOGLE_SHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Orders",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"status": "Sent"
},
"matchingColumns": [
"order_id"
],
"schema": []
},
"options": {}
},
"id": "c5d6e7f8-5555-6666-7777-888899990000",
"name": "Update Order Status",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1170,
300
]
},
{
"parameters": {
"chatId": "YOUR_TELEGRAM_CHAT_ID",
"text": "=\ud83d\udcca Daily Order Report\n\n\u2705 {{ $json.length }} orders processed\n\ud83d\udce7 Confirmation emails sent\n\nTime: {{ $now.toFormat('yyyy-MM-dd HH:mm') }}",
"additionalFields": {
"parse_mode": "Markdown"
}
},
"id": "d6e7f8a9-6666-7777-8888-999900001111",
"name": "Send Report to Telegram",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1.1,
"position": [
1400,
300
]
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get Orders from Sheets",
"type": "main",
"index": 0
}
]
]
},
"Get Orders from Sheets": {
"main": [
[
{
"node": "Filter Pending Orders",
"type": "main",
"index": 0
}
]
]
},
"Filter Pending Orders": {
"main": [
[
{
"node": "Send Confirmation Email",
"type": "main",
"index": 0
}
]
]
},
"Send Confirmation Email": {
"main": [
[
{
"node": "Update Order Status",
"type": "main",
"index": 0
}
]
]
},
"Update Order Status": {
"main": [
[
{
"node": "Send Report to Telegram",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Email Automation - Daily Order Processing. Uses googleSheets, emailSend, telegram. Scheduled trigger; 6 nodes.
Source: https://github.com/kooroosh1363/agentic-automation-lab/blob/main/02-email-automation/workflow.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
An enterprise-grade n8n workflow that leverages OpenAI GPT-4 to generate contextually relevant poll questions and automatically distributes them across multiple Telegram groups and channels. Includes
Automates Singapore COE price tracking, predicts trends using AI, and recommends optimal car purchase timing. Scrapes LTA data biweekly, analyzes historical trends, forecasts next 6 bidding rounds, an
Data Analytics Dashboard with AI Insights. Uses googleSheets, httpRequest, openAi, telegram. Scheduled trigger; 11 nodes.
Price Monitoring - Competitor Tracking with AI. Uses httpRequest, googleSheets, openAi, telegram. Scheduled trigger; 8 nodes.
Track changes and approvals in Excel 365. Uses microsoftExcel, googleSheets, telegram. Scheduled trigger; 21 nodes.