Track SEO keyword position in Google SERP (Google Sheets + SerpAPI integration)
Ready for 3.0What this workflow does
This workflow has 18 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Google Sheets, WhatsApp Business Cloud and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Get Row (notChecked Column) (Google Sheets): uses Google Sheets
- Google Sheets: uses Google Sheets
- Set Keyword (s) (Code): runs custom JavaScript code
- Google Sheets: uses Google Sheets
- Google Serp Request (HTTP Request): calls an HTTP API
- WA Start Checks Notification (WhatsApp Business Cloud): uses WhatsApp Business Cloud
- Gmail: uses Gmail
- Map Organic Results Array (Edit Fields (Set)): sets or maps fields
- Web URL Position Finder (Code): runs custom JavaScript code
- Update Check Status Column (to Checked) (Google Sheets): uses Google Sheets
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Gmail
n8n-nodes-base.gmail - Switch
n8n-nodes-base.switch
From the author
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…