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 →
{
"nodes": [
{
"parameters": {
"triggerTimes": {
"item": [
{
"hour": 9,
"minute": 0
}
]
}
},
"name": "Daily Trigger",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
200,
300
]
},
{
"parameters": {
"operation": "read",
"sheetId": "YOUR_SHEET_ID",
"range": "Leads!A1:D100"
},
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 2,
"position": [
500,
300
]
},
{
"parameters": {
"fromEmail": "noreply@example.com",
"toEmail": "admin@example.com",
"subject": "Daily Lead Summary",
"text": "Total Leads: {{$json.length}}"
},
"name": "Send Email",
"type": "n8n-nodes-base.emailSend",
"typeVersion": 1,
"position": [
800,
300
]
}
],
"connections": {
"Daily Trigger": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Workflow-Lead-Summary. Uses googleSheets, emailSend. Scheduled trigger; 3 nodes.
Source: https://github.com/Rumman90/n8n-workflows/blob/main/workflows/workflow-lead-summary.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.
Automate personalized email campaigns using a Google Sheets contact list, a Google Docs template, and SMTP delivery. Google Docs is used as the email template with variables: , , , . Google Sheet cont
Automatización de Email Marketing. Uses googleSheets, emailSend. Scheduled trigger; 4 nodes.
This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CR
Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.
This workflow is designed to manage the assignment and validation of unique QR code coupons within a lead generation system with SuiteCRM.