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": "Google Sheet Watch Changes",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "e26a4b1d-c7ed-4a65-8d61-ff3d17d198103",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"id": "b4c5d501-f41f-4929-a7fc-d41feecd138b",
"name": "Webhook"
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"leftValue": "={{ $json.body.range.columnStart }}",
"rightValue": 7,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
}
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "512f7d73-542c-428a-ab82-d2dbdf11fb7f",
"leftValue": "={{ $json.body.range.columnStart }}",
"rightValue": 8,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
}
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "b03b7337-434a-4f1e-babb-128f347bc444",
"leftValue": "={{ $json.body.range.columnStart }}",
"rightValue": 9,
"operator": {
"type": "number",
"operation": "equals"
}
}
],
"combinator": "and"
}
}
]
},
"options": {}
},
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
460,
0
],
"id": "cb1b74dc-6602-4bf8-b2d0-8fb1921f3fec",
"name": "Switch"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "c15ef578-470c-4fba-afb1-7cc20905e49e",
"leftValue": "={{ $json.body.value }}",
"rightValue": "TRUE",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.filter",
"typeVersion": 2.2,
"position": [
220,
0
],
"id": "7c4c2fd7-11cd-4947-8dbd-e2fc40b04be5",
"name": "Filter"
},
{
"parameters": {
"sendTo": "={{ $json.body.rowValues[0][\"2\"] }}",
"subject": "Thanks for inquiring with ABC company!",
"emailType": "text",
"message": "=Hey {{ $json.body.rowValues[0][\"0\"] }},\n\nThanks for inquiring. \n\nBest,\nJono",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
680,
-120
],
"id": "46345975-f2f2-4934-b718-448ca0fc5b8c",
"name": "Gmail",
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"method": "POST",
"url": "https://services.leadconnectorhq.com/hooks/6Jwyv0H9PIQbm8a1APCN/webhook-trigger/d6714a8f-0e46-4e4d-87a0-ce2bf3f2583a",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json.body.rowValues[0][\"2\"] }}"
},
{
"name": "package",
"value": "={{ $json.body.rowValues[0][\"11\"] }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
680,
120
],
"id": "6c932aee-75ae-437d-a45a-e6deb9fd601f",
"name": "HTTP Request"
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "Gmail",
"type": "main",
"index": 0
}
],
[],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "1063c2f4-f09c-4273-8893-c70d3d21b572",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "V6Y4KGdrGhKZqONo",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
gmailOAuth2
About this workflow
Google Sheet Watch Changes. Uses gmail, httpRequest. Webhook trigger; 5 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →