Track website traffic data with SEMrush API and Google Sheets

🚀 Website Traffic Monitoring with SEMrush API and Google Sheets Integration

Leverage the powerful [SEMrush Website Traffic Checker API](https://rapidapi.com/PrineshPatel/api/semrush-website-traffic-checker) to automatically fetch detailed website traffic insights and log them into Google Sheets for real-time monitoring and reporting. This no-code n8n workflow simplifies traffic analysis for marketers, analysts, and website owners.

---

⚙️ Node-by-Node Workflow Breakdown

1. 🟢 On Form Submission - Trigger: The workflow is initiated when a user submits a website URL via a form. This serves as the input for further processing. - Use Case: When you want to track multiple websites and monitor their performance over time. 2. 🌐 Website Traffic Checker - API Request: The workflow makes a POST request to the [SEMrush Website Traffic Checker API](https://rapidapi.com/PrineshPatel/api/semrush-website-traffic-checker) via RapidAPI using the website URL that was submitted. - API Data: The API returns detailed traffic insights, including: - Visits - Bounce rate - Page views - Sessions - Traffic sources - And more! 3. 🔄 Reformat - Parsing: The raw API response is parsed to extract the relevant data under trafficSummary. - Data Structure: The workflow creates a clean dataset of traffic data, making it easy to store in Google Sheets.

4. 📄 Google Sheets - Logging Data: The traffic data is appended as a new row in your Google Sheet. - Google Sheet Setup: The data is organized and updated in a structured format, allowing you to track website performance over time.

---

💡 Use Cases