📊 Seo competitor analysis & data logging with Semrush API and Google Sheets

⚡ 1,493 views · 📊 Market Research & Insights

💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.

Description

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.

🔗 Nodes Used

Google Sheets, HTTP Request, n8n Form Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup