n8n Competitor SEO Tracker: Google Sheets + RapidAPI

Daily competitor SEO tracking with Google Sheets + RapidAPI

This n8n workflow automatically checks your competitors every day, pulls their latest SEO audit score and detected technology stack via RapidAPI, and updates a Google Sheets tab—while flagging meaningful score drops and tech changes.

What this workflow does

• Runs on a daily schedule to keep competitor signals up to date.
• Reads competitor URLs from a Google Sheets tab named “Competitors”, along with previously stored values (last_score and last_stack).
• For each URL, makes an HTTP Request to the Web Metadata & Contact Extractor API on RapidAPI to retrieve:
  • the current `SEO audit score`
  • the current detected tech stack
• Compares current vs. last saved values and flags:
  • a score drop greater than 5 points
  • any technology stack change
• Writes the latest score and stack back to Google Sheets so the next run can detect changes.

Use cases

• SaaS marketing teams monitoring competitor SEO performance over time.
• SEO professionals tracking sudden ranking-risk indicators (e.g., score drops > 5).
• Automation engineers building ongoing competitor SEO tracker reporting into Google Sheets.
• Operators watching for platform or tooling changes reflected in the detected tech stack.

Technical details

• n8n nodes: if, set, merge, sticky note, HTTP Request, Google Sheets
• Google Sheets integration:
  • Tab name: “Competitors”
  • Columns: url, last_score, last_stack
• RapidAPI authentication: HTTP Header Auth using header name X-RapidAPI-Key