Seo competitor analysis & data logging with Semrush API and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (4)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
What it does
Competitor Analysis & SEO Data Logging Workflow Using Competitor Analysis Semrush API Description This workflow automates SEO competitor analysis using the Competitor Analysis Semrush API and logs the data into Google Sheets for structured reporting. It captures domain overview, organic competitors, organic pages, and keyword-level insights from the Competitor Analysis Semrush API, then appends them to different sheets for easy tracking. --- Node-by-Node Explanation 1. On form submission – Captures the website URL entered by the user. 2. Competitor Analysis – Sends the website to the Competitor Analysis Semrush API via HTTP POST request. 3. Re format output – Extracts and formats the domain overview data. 4. Domain overview – Saves organic keywords and traffic into Google Sheets. 5. Reformat – Extracts the organic competitors list. 6. Organic Competitor – Logs competitor domains, relevance, and traffic into Google Sheets. 7. Reformat 2 – Extracts organic pages data. 8. Organic Pages – Stores page-level data such as traffic and keyword counts. 9. Reformat2 – Extracts organic keywords details. 10. organic keywords – Logs keyword data like CPC, volume, and difficulty into Google Sheets. --- Benefits - ✅ Automated competitor tracking – No manual API calls, all logged in Google Sheets. - ✅ Centralized SEO reporting – Data stored in structured sheets for quick access. - ✅ Time-saving – Streamlines research by combining multiple reports in one workflow. - ✅ Accurate insights – Direct data from the Competitor Analysis Semrush API ensures reliability. --- Use Cases - 📊 SEO Research – Track domain performance and competitor strategies. - 🔍 Competitor Monitoring – Identify competitor domains, keywords, and traffic. - 📝 Content Strategy – Find top-performing organic pages and replicate content ideas. - 💰 Keyword Planning – Use CPC and difficulty data to prioritize profitable keywords. - 📈 Client Reporting – Generate ready-to-use SEO competitor analysis reports in Google Sheets.