Joseph This workflow corresponds to n8n.io template #3792 — we link there as the canonical source.
This workflow follows the Gmail → 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 →
{
"id": "5OVS6Bo8q2fhZjDC",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Automated Website Keyword SEO Tracker",
"tags": [],
"nodes": [
{
"id": "f28674c5-4159-4625-9d3f-9131ffdb420a",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1160,
1080
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6f4ae15a-464e-4f45-af0e-b2a5382185af",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cecac1ac-a3d8-4606-b95c-5f4d7ffd40b8",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7df3db45-e6db-4040-a9a1-b195f2e71ef8",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6dce41f8-9489-49e5-8b13-955af918e981",
"name": "Map Organic Results Array",
"type": "n8n-nodes-base.set",
"position": [
-300,
180
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "06c29c8b-fe87-4fc6-81ae-f74cf6cd3daf",
"name": "Google Serp Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
-540,
180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f8b88a80-3325-4777-9d92-658ac80f6f35",
"name": "Set Keyword (s)",
"type": "n8n-nodes-base.code",
"position": [
-760,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4a965b72-7c58-44df-ab55-3f2748d2fa07",
"name": "Web URL Position Finder",
"type": "n8n-nodes-base.code",
"position": [
-80,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8e145c1b-2b5a-44b2-b04d-a4ebce555d0d",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1440,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fa779385-7aca-40db-8650-81d5c16e7fdb",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1060,
-180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6d027192-0ee0-41d3-8336-133551802ebd",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1380,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c528f973-0eee-4f7e-b905-ac09310d9a22",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-720,
1080
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "c13f9537-4104-411a-8b41-cd9b0f3de0f7",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
-940,
1080
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "84c8e8bc-da22-4d4d-a036-e544b879b44b",
"name": "Google Sheets Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-1380,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "87f4811b-f6f2-4e86-a309-0be8fabb07ba",
"name": "Get Row (notChecked Column)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
180
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5e51a61b-f067-4af7-86d9-70eb85a9ea09",
"name": "Update Check Status Column (to Checked)",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
180
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5920519e-2ad8-4a37-8905-9ca6bf25a7ce",
"name": "WA Start Checks Notification",
"type": "n8n-nodes-base.whatsApp",
"position": [
-420,
940
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d40f5338-c0ed-4fe8-96e7-e47884980308",
"name": "GMAIL Start Checks Notification",
"type": "n8n-nodes-base.gmail",
"position": [
-420,
1200
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "65697b95-f66d-4bbb-8cd9-e5014466b07b",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-600,
-180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46df2de6-0ec3-4d02-a101-eaa74e7a6233",
"name": "Notifications Switch",
"type": "n8n-nodes-base.switch",
"position": [
320,
180
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "d9b43876-cabc-4ac3-b93c-89bc74071a1c",
"name": "Send Email Improved",
"type": "n8n-nodes-base.gmail",
"position": [
480,
480
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4ff11769-ceec-48da-a2d0-57ab337b4678",
"name": "Send WA Message Improved",
"type": "n8n-nodes-base.whatsApp",
"position": [
480,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e29fd730-3790-49f5-89b4-d665d850e607",
"name": "Send Email Dropped",
"type": "n8n-nodes-base.gmail",
"position": [
940,
140
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "2bfdf0f7-bb4d-4c10-a9fa-ff579c3ba7f8",
"name": "Send WA Message Dropped",
"type": "n8n-nodes-base.whatsApp",
"position": [
940,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "99345bcc-baf8-4f0a-9223-bd4d340d09ad",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
900
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "38fc33fc-c04b-4496-b549-2d3bbc712d6d",
"connections": {
"Google Sheets": {
"main": [
[
{
"node": "WA Start Checks Notification",
"type": "main",
"index": 0
},
{
"node": "GMAIL Start Checks Notification",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets2": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Set Keyword (s)": {
"main": [
[
{
"node": "Google Serp Request",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"Google Serp Request": {
"main": [
[
{
"node": "Map Organic Results Array",
"type": "main",
"index": 0
}
]
]
},
"Notifications Switch": {
"main": [
[],
[
{
"node": "Send Email Dropped",
"type": "main",
"index": 0
},
{
"node": "Send WA Message Dropped",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Email Improved",
"type": "main",
"index": 0
},
{
"node": "Send WA Message Improved",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Get Row (notChecked Column)",
"type": "main",
"index": 0
}
]
]
},
"Web URL Position Finder": {
"main": [
[
{
"node": "Update Check Status Column (to Checked)",
"type": "main",
"index": 0
}
]
]
},
"Map Organic Results Array": {
"main": [
[
{
"node": "Web URL Position Finder",
"type": "main",
"index": 0
}
]
]
},
"Get Row (notChecked Column)": {
"main": [
[
{
"node": "Set Keyword (s)",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Get Row (notChecked Column)",
"type": "main",
"index": 0
}
]
]
},
"Update Check Status Column (to Checked)": {
"main": [
[
{
"node": "Notifications Switch",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement.
Source: https://n8n.io/workflows/3792/ — 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.
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Automatically processes new orders added to Google Sheets. Small orders are approved instantly; large orders trigger an HTML email with one-click Approve / Reject links — each handled by an independen
This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store.
This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.