Automated Google Keyword Position Tracking
detail.loadingPreview
This n8n workflow automates the crucial task of tracking Google search engine results page (SERP) positions for a list of keywords. It fetches keywords from a Google Sheet, uses Bright Data's SERP API to retrieve real-time ranking data, and then records the organic results directly back into your Google Sheet for effortless analysis.
About This Workflow
Gain a competitive edge in your SEO strategy with this robust n8n workflow. Designed for marketing professionals and SEO specialists, this automation seamlessly pulls your target keywords and specified geographic locations from a Google Sheet. It then intelligently leverages Bright Data's advanced SERP API to simulate actual Google searches, extracting rich organic ranking data including titles, URLs, meta descriptions, and their respective positions. All this valuable information is systematically appended back to your Google Sheet, instantly creating a dynamic and continuously updated keyword position tracking dashboard. Eliminate manual data collection, save countless hours, and gain real-time insights into your search performance to optimize your content and climb the ranks.
Key Features
- Automated Keyword Import: Effortlessly reads target keywords and associated country codes directly from a designated Google Sheet.
- Real-time SERP Data: Integrates with Bright Data's powerful SERP API to fetch accurate, localized Google search results in real-time.
- Detailed Ranking Metrics: Captures essential data points for each organic result, including rank, page title, URL, meta description, and extensions.
- Centralized Reporting: Automatically appends all collected ranking data back into your Google Sheet, providing a single source of truth for SEO performance.
- Scheduled Monitoring: Easily set up a schedule to run this workflow periodically, ensuring your position tracking data is always up-to-date.
How To Use
- Configure Google Sheets (Get Keywords & Append Ranking Result):
- Connect your Google Sheets account to n8n.
- In the 'Get Keywords' node, select the Google Sheet document and the specific sheet (e.g., 'Keywords to Track') containing your keywords (e.g., in a column named
search_term) and corresponding country codes (e.g., in a column namedcountry code). - In the 'append ranking result' node, select the same Google Sheet document and the target sheet where you want to store the collected ranking data. The workflow will automatically map input fields to the sheet's columns.
- Set up Bright Data Credentials:
- Create a new 'HTTP Header Auth' credential in n8n for Bright Data, providing your API key as the value for the appropriate header (e.g.,
AuthorizationorX-BrightData-Auth).
- Create a new 'HTTP Header Auth' credential in n8n for Bright Data, providing your API key as the value for the appropriate header (e.g.,
- Review 'Fetch Google Search Results JSON' Node:
- Ensure the
urlparameter in the 'bodyParameters' correctly constructs the Google search query using{{ $json.search_term }}and{{ $json['country code'] }}to dynamically pull values from your Google Sheet.
- Ensure the
- Verify 'format fields' Node:
- Confirm that the assignments accurately map the data received from Bright Data (e.g.,
linktoranking page,ranktoposition,titletotitle) to your desired output column names for the Google Sheet.
- Confirm that the assignments accurately map the data received from Bright Data (e.g.,
- Execute or Schedule:
- Manually trigger the 'When clicking ‘Execute workflow’' node to run a test.
- For continuous tracking, set up a schedule (e.g., daily, weekly) on the 'When clicking ‘Execute workflow’' node to automate the process.
Apps Used
Workflow JSON
{
"id": "b8b92330-30c0-45f7-98b3-3ab39a4116db",
"name": "Automated Google Keyword Position Tracking",
"nodes": 17,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: b8b92330-30c0...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.