See llms.txt for all machine-readable content.

Back to Templates

Track daily Google SERP rankings with Decodo and Google Sheets

Created by

Created by: Khairul Muhtadin || khmuhtadin
Khairul Muhtadin

Last update

Last update 5 days ago

Categories

Share

Your daily SEO scoreboard, filled in automatically. This SERP tracker scrapes Google Search results with Decodo for your keywords and logs rankings into Google Sheets every morning. No manual rank checking, no copy-paste reporting.

Last updated: September 2026.

Why Use This Workflow?

Time Savings: Daily rank checking drops from 60 minutes to zero through full automation.
Cost Reduction: No expensive per-keyword SEO tracking software for basic monitoring needs.
Error Prevention: 100% of search data captured accurately, meta descriptions and URLs included, with no human copy-paste errors.
Scalability: Dozens of keywords across countries and devices from a single configuration node.

Ideal For

  • SEO Specialists: Daily keyword movements and SERP feature changes for clients or internal projects.
  • Content Marketers: Watch new content rank against competitors for high-intent keywords.
  • Digital Agencies: Automated, transparent ranking reports for clients without manual data entry.

How It Works

  1. Trigger: The workflow starts every morning at 9:00 AM via the Schedule Trigger.
  2. Data Collection: Parameters like keyword, country (e.g., "id"), language ("en"), and device type are defined.
  3. Processing: The Decodo node executes a live Google search based on your specific localized parameters.
  4. Intelligence Layer: The workflow filters the raw JSON response to extract organic results only and validates that each result has a valid URL.
  5. Output & Delivery: Top-ranked results (e.g., Top 5) are appended to a "SERP_Results" Google Sheet.
  6. Storage & Logging: Any errors (API timeouts or empty results) are automatically logged to a separate "SERP_Errors" sheet for troubleshooting.

Setup Guide

Prerequisites

Requirement Type Purpose
n8n instance Essential Workflow execution platform
Decodo API Essential Scrapes live Google Search results
Google Sheets Essential Destination for ranking data and error logs

Installation Steps

  1. Import the JSON file to your n8n instance
  2. Configure credentials:
    • Decodo API: Create an account at Decodo and paste your API key into the Decodo Search node.
    • Google Sheets: Connect your Google account via OAuth2 and ensure you have a spreadsheet ready with two tabs: SERP_Results and SERP_Errors.
  3. Update environment-specific values:
    • In the Write SERP Results and Write SERP Errors nodes, select your specific Spreadsheet from the dropdown.
  4. Customize settings:
    • Open the Set Search Input node to change the keyword, country code, and the "top_n" (number of ranks to track).
  5. Test execution:
    • Click "Test Workflow" to verify data appears in your Google Sheet.

Technical Details

Core Nodes

Node Purpose Key Configuration
Set Search Input Configuration Defines keyword, geo-location, and rank limit
Decodo Search Data Acquisition Performs localized Google Search via API
Split Out Data Structuring Converts the API array into individual rows for processing
IF Nodes Validation Filters for top-N ranks and ensures data integrity
Google Sheets Storage Appends successful data or logs failures

Workflow Logic

The workflow uses a Split Out and Extract Organic strategy. Even when Google returns SERP features (ads, maps, snippets), the workflow targets the organic blue links specifically. The "Valid Row" logic keeps your spreadsheet clean by only recording results that meet your "Top N" criteria (e.g., only the top 5 results).

Customization Options

Basic Adjustments:

  • Search Frequency: Change the Schedule Trigger to run weekly or hourly depending on your needs.
  • Rank Depth: Change the top_n value in the input node to track the Top 10, 20, or 50 results.

Advanced Enhancements:

  • Slack Notifications: Add a Slack node to alert your team if a specific keyword drops out of the Top 3.
  • Multi-Keyword Support: Replace the "Set" node with a Google Sheet "Read" node to loop through a list of hundreds of keywords.

Troubleshooting

Common Issues:

Problem Cause Solution
Empty Google Sheet No results found for keyword Check the SERP_Errors sheet for the raw API response.
Permission Error Google Sheets node not authorized Re-connect your Google Sheets OAuth2 credentials.
Decodo 401 Error Invalid API Key Verify your Decodo API key is active and has remaining credits.

Use Case Examples

Scenario 1: E-commerce Competitor Tracking

Challenge: A retail brand needs to know who is winning the "best running shoes" keyword daily.
Solution: This workflow tracks the Top 5 results every morning, allowing the brand to see when a competitor's blog post overtakes their product page.
Result: The marketing team identifies a ranking drop within 24 hours and updates their content immediately.

Scenario 2: Local SEO Monitoring

Challenge: A service business wants to monitor rankings specifically in Indonesia ("id") using English ("en") search settings.
Solution: By configuring the country and language parameters in the Set node, the workflow captures localized SERP data accurately.
Result: The business gets an accurate picture of their local visibility without using a VPN.

Quick Answers

When does it run?
Every morning at 9:00 AM. Change the Schedule Trigger for weekly or hourly runs.
Can it track other countries?
Yes. Set country and language in the input node (e.g., "id" + "en" for Indonesia).
Where do errors go?
A separate SERP_Errors sheet logs timeouts and empty results for troubleshooting.

Made by: khmuhtadin
Category: Marketing | Tags: SEO, SERP, Google Sheets, Decodo
Need custom workflows? Contact me

Connect with the creator:
Portfolio • Store • LinkedIn • Medium • Threads

Additional info

Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/