This workflow follows the Gmail → HTTP Request 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": "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
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
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 →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automatically creates a subscriber in a given Beehiiv publication when a new opt-in is registered in a given Systeme.io sales funnel.
This workflow automates daily attendance tracking by analyzing uploaded attendance images, extracting participant names via VLM Run’s Execute Agent, appending the structured data into Google Sheets, a
🌿 W5 — M&P Contact famille. Uses notion, httpRequest, gmail. Webhook trigger; 5 nodes.
Portfolio Contact Form. Uses httpRequest, gmail, slack. Webhook trigger; 5 nodes.
Relay▶Deck — Verdict Notifications. Uses httpRequest, gmail. Webhook trigger; 3 nodes.