Track Website Traffic with Semrush API & Log to Google Sheets

This n8n workflow automates website traffic monitoring by integrating the Semrush Website Traffic Checker API. It triggers on form submissions capturing a website URL, fetches real-time traffic statistics like visits, bounce rates, and sources via the API, reformats the raw data for clarity, and appends it to a Google Sheet for persistent storage and analysis.

Key benefits include real-time data collection without manual intervention, seamless integration between form inputs, powerful SEO APIs, and spreadsheet logging, saving hours on repetitive SEO audits. It's ideal for marketers, SEO specialists, and agencies tracking competitor or client site performance over time.

Use cases: Monitor your own site's traffic trends, benchmark competitors, generate client reports from Sheets, or build a knowledge base of traffic insights. Scalable for multiple URLs via repeated form submissions, with no coding required beyond initial setup.