workflows.fit
Back to n8n workflows
n8n templateFreeBy Sk developer

Track website traffic with Semrush API and log results to Google Sheets

Automated Seo Website Traffic Checker with Google Sheets Logging (Seo) Description: This workflow uses the [Website Traffic Checker Semrush](https://rapidapi.com/skdeveloper/api/website-traffic-checker-semrush) API to...

Data & StorageProductivityDevelopmentCore NodesForm TriggerCodeGoogle SheetsHttp Request
Loading interactive preview...

Template notes

Automated Seo Website Traffic Checker with Google Sheets Logging (Seo)

Description: This workflow uses the [Website Traffic Checker Semrush](https://rapidapi.com/skdeveloper/api/website-traffic-checker-semrush) API to analyze website traffic and performance. It collects data through a user-submitted website URL and stores the results in Google Sheets for easy access and reporting. Ideal for SEO analysis and data tracking.

---

Node-by-Node Explanation:

1. On form submission Captures the website URL submitted by the user through a form. Triggers the workflow when a website URL is submitted via the form interface.

2. Check webTraffic Sends a request to the [Website Traffic Checker Semrush](https://rapidapi.com/skdeveloper/api/website-traffic-checker-semrush) API to gather traffic data for the submitted website. Uses the provided URL to fetch real-time traffic statistics using the Semrush API.

3. Re format output Extracts and reformats the raw traffic data from the API response. Cleans and structures the traffic data for easy readability and reporting.

4. Google Sheets Appends the formatted traffic data into a Google Sheet for storage and further analysis. Stores the data in a Google Sheets document for long-term tracking and analysis.