Track Google rankings daily with Decodo and Google Sheets

Automatically monitor your keyword positions on Google every day. This workflow uses Decodo to pull live search results and logs them straight into Google Sheets, no manual checking needed.

Why This Workflow?

Save Time: No more spending an hour every morning checking rankings by hand. Everything runs on autopilot. Save Money: Skip expensive SEO tools that charge per keyword for basic rank tracking. Accurate Data: Every result — including meta descriptions and URLs — gets recorded without copy-paste mistakes. Easy to Scale: Want to add more keywords, switch countries, or change devices? Just tweak one config node.

Who Is This For?

- SEO Specialists: Keep tabs on daily keyword movements for clients or internal projects. - Content Marketers: See how your latest content stacks up against competitors for target keywords. - Digital Agencies: Deliver automated ranking reports to clients without touching a spreadsheet manually.

How It Works

1. Scheduled Start: The workflow kicks off every morning at 9:00 AM using the Schedule Trigger. 2. Set Parameters: Keyword, country code (e.g., "id"), language ("en"), and device type are defined upfront. 3. Fetch Results: The Decodo node runs a live Google search based on your settings. 4. Filter & Validate: The workflow strips out ads, maps, and snippets — keeping only organic results with valid URLs. 5. Store Rankings: Top results (e.g., Top 5) get appended to a "SERPResults" tab in Google Sheets. 6. Log Issues: If something goes wrong (API timeout, empty results), errors are recorded in a separate "SERPErrors" tab.

What You Need