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

Competitor Analysis & SEO Data Logging Workflow Using [Competitor Analysis Semrush API](https://rapidapi.com/skdeveloper/api/competitor-analysis-semrush)

Description This workflow automates SEO competitor analysis using the [Competitor Analysis Semrush API](https://rapidapi.com/skdeveloper/api/competitor-analysis-semrush) 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](https://rapidapi.com/skdeveloper/api/competitor-analysis-semrush), 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](https://rapidapi.com/skdeveloper/api/competitor-analysis-semrush) 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](https://rapidapi.com/skdeveloper/api/competitor-analysis-semrush) ensures reliability.