Email me when a Google Sheet gets a new row
Get an email with the details every time a new row is added to a sheet.
How it works
Trigger: Google Sheets — new row
- Watch the sheet for new rows.
- Email yourself every column of the new row.
Diagram
Trigger App
Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (91 lines)
{
"name": "Email me when a Google Sheet gets a new row (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Email me when a Google Sheet gets a new row\nGet an email with the details every time a new row is added to a sheet.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "458210f1-1c22-487e-a172-57c0105c7b90",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Sheet1",
"mode": "name"
},
"event": "rowAdded",
"options": {}
},
"id": "458210f1-1c22-487e-a172-57c0105c7b90",
"name": "New row",
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
0,
0
]
},
{
"parameters": {
"sendTo": "you@yourcompany.com",
"subject": "New row in your sheet",
"emailType": "text",
"message": "={{ Object.entries($json).filter(([k]) => k !== 'row_number').map(([k, v]) => k + ': ' + v).join('\\n') }}",
"options": {
"appendAttribution": false
}
},
"id": "458210f1-1c22-487e-a172-57c0105c7b90",
"name": "Email me",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
300,
0
]
}
],
"connections": {
"New row": {
"main": [
[
{
"node": "Email me",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Google Sheets › Watch New Rows
- Gmail › Send an Email
- Every module run uses Make operations — the free plan includes a monthly quota.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Google Sheets — New Spreadsheet Row
- Gmail — Send Email
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- Works great with Google Forms, since responses are saved to a sheet.
Related flows
ProductivityMedium
Leave requests approved on Telegram
Employees fill in a leave form; the manager approves or rejects it with one tap on Telegram, and the employee gets an email.
Google Forms → Google Sheets → Telegram → Gmail4h/mo
ProductivityMedium
AI daily news digest
Every morning, AI summarises the latest articles from a news feed into one short email.
RSS → AI model → Gmail5h/mo
ProductivityMedium
Turn labelled emails into Notion tasks
Label an email "To-do" and it becomes a Notion task with a link back to the email.
Gmail → Notion3h/mo