{"product_id":"n8n-competitor-seo-tracker-google-sheets-rapidapi","title":"n8n Competitor SEO Tracker: Google Sheets + RapidAPI","description":"\u003ch3\u003eDaily competitor SEO tracking with Google Sheets + RapidAPI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your competitors every day, pulls their latest SEO audit score and detected technology stack via \u003cstrong\u003eRapidAPI\u003c\/strong\u003e, and updates a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab—while flagging meaningful score drops and tech changes.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a daily schedule\u003c\/strong\u003e to keep competitor signals up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads competitor URLs\u003c\/strong\u003e from a Google Sheets tab named \u003cem\u003e“Competitors”\u003c\/em\u003e, along with previously stored values (\u003ccode\u003elast_score\u003c\/code\u003e and \u003ccode\u003elast_stack\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003eFor each URL, makes an \u003cstrong\u003eHTTP Request\u003c\/strong\u003e to the \u003cstrong\u003eWeb Metadata \u0026amp; Contact Extractor API\u003c\/strong\u003e on RapidAPI to retrieve:\n    \u003cul\u003e\n      \u003cli\u003ethe current `SEO audit score`\u003c\/li\u003e\n      \u003cli\u003ethe current detected tech stack\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares current vs. last saved values\u003c\/strong\u003e and flags:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003escore drop greater than 5 points\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eany technology stack change\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites the latest score and stack back to Google Sheets\u003c\/strong\u003e so the next run can detect changes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS marketing teams monitoring competitor SEO performance over time.\u003c\/li\u003e\n  \u003cli\u003eSEO professionals tracking sudden ranking-risk indicators (e.g., score drops \u0026gt; 5).\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building ongoing \u003cstrong\u003ecompetitor SEO tracker\u003c\/strong\u003e reporting into Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eOperators watching for platform or tooling changes reflected in the detected tech stack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: if, set, merge, sticky note, HTTP Request, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eTab name: \u003cstrong\u003e“Competitors”\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eColumns: \u003ccode\u003eurl\u003c\/code\u003e, \u003ccode\u003elast_score\u003c\/code\u003e, \u003ccode\u003elast_stack\u003c\/code\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRapidAPI authentication\u003c\/strong\u003e: HTTP Header Auth using header name \u003ccode\u003eX-RapidAPI-Key\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850649821363,"sku":"N8N-18289","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0Fpct53oP_gY0zanc6K64_SuFkVwkx.png?v=1786871284","url":"https:\/\/buyflowscripts.com\/products\/n8n-competitor-seo-tracker-google-sheets-rapidapi","provider":"N8N Commerce","version":"1.0","type":"link"}