Automate Competitor SEO Content Audits with n8n: Decodo Scraping + Gemini Analysis + Google Sheets Reporting
Input keyword list and brand identity sheet → Decodo searches and scrapes competitor pages → Gemini audits content gaps → outputs structured Action Plan to Google Sheets
Read the case’s method and prerequisites
Prerequisites: accessible n8n instance; Google Sheets OAuth2 credentials; Decodo API key; googlePalmApi credentials for the Gemini node. Create a Google Sheet with three tabs (Target Keywords, Brand Identity, Competitor Audit Feed) and configure target_geo, target_locale, and serp_results_amount in the Config node.
n8n · google-sheets
Associated by case tags. Verify costs, permissions and actual results in the case.