Latenode
Google sheets
JavaScript

Sync website traffic data from Semrush to Google Sheets

This automation template provides a streamlined solution for website owners and digital marketers to track their website's traffic performance using the Semrush API and store the data in a Google Sheets spreadsheet. By periodically retrieving traffic metrics like organic search visits, pages per visit, and bounce rate, users can gain valuable insights to optimize their website's SEO and user experience.

The workflow is triggered when a user submits a website URL through a form interface, and it automatically processes the data from the Semrush API, reformats it, and appends it to a designated Google Sheets document for easy analysis and reporting. This automation simplifies the data collection and analysis process, allowing users to make data-driven decisions to improve their website's performance.

Updated May 8, 2026Est. run: 6sEst. cost: $0.0003
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
SEO, marketing & analytics

Workflow preview

What this template does

  • Extracts website traffic data from the Semrush API for specified domains
  • Normalizes the API response data into a consistent format
  • Appends the traffic metrics to a designated Google Sheets spreadsheet
  • Filters the data to include only the most relevant traffic performance indicators
  • Generates a spreadsheet with a detailed record of the website's traffic history

How it works

1
Trigger

Submit website URL

The workflow is triggered when a user submits a website URL through a form interface.

2
Logic

Fetch traffic data from Semrush API

The automation fetches the website's traffic metrics, such as organic search visits, pages per visit, and bounce rate, from the Semrush API.

3
Logic

Reformat API response

The retrieved data is then reformatted to prepare it for appending to the Google Sheets spreadsheet.

4
Action

Append data to Google Sheets

The reformatted traffic data is automatically appended to a designated Google Sheets document for easy analysis and reporting.

Setup guide

1

Add Semrush API Credential

Add your Semrush API credential in the Latenode Credentials panel. You can obtain the API key by signing up for a Semrush account and generating an API key in your Semrush account settings.

2

Add Google Sheets Credential

Add your Google Sheets credential in the Latenode Credentials panel. You can create a Google Cloud Platform project, enable the Google Sheets API, and generate OAuth 2.0 credentials for your application.

3

Configure Website Traffic Checker Node

In the Latenode visual builder, add a 'Website Traffic Checker Semrush' node. In the node settings, map the 'Website URL' input field to the trigger node that receives the user-submitted website URL.

4

Configure Google Sheets Output

In the Latenode visual builder, add a 'Google Sheets' node after the 'Website Traffic Checker Semrush' node. In the node settings, configure the Google Sheets spreadsheet and worksheet where you want to append the website traffic data.

5

Test and Publish Workflow

Test your workflow by submitting a website URL through the trigger node. Verify that the website traffic data is successfully appended to the Google Sheets document. Once you're satisfied with the workflow, publish it to make it available for use.

Requirements

A Semrush account with API access
A Google Sheets account and access to the specific spreadsheet where the data will be stored
Ability to create and configure a new Latenode workflow
Knowledge of the Semrush API and how to retrieve website traffic data

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
SEO, marketing & analytics

Comprehensive SEO Audit and Optimization Automation

The SEO & marketing analytics automation template provides a comprehensive analysis of a website's technical health, content quality, and user experience to identify issues and deliver actionable recommendations for improving search engine visibility and rankings. The workflow fetches the website content, analyzes various on-page elements like meta tags, headings, images, and content using language models and PageSpeed Insights, and generates an HTML report with optimization suggestions. The report is then emailed to stakeholders, enabling data-driven decisions to enhance the website's SEO performance. This automation streamlines the SEO audit process, saving time and resources while ensuring a thorough examination of the website's SEO-critical factors.

32s$0.0020
SEO, marketing & analytics

Sync Google Ads search volume to your Google Sheet for SEO insights

This automation helps users retrieve search volume data for a list of SEO keywords from the Google Ads API, and automatically populate the results back into a Google Sheet. It enables users to generate accurate search volume data, identify seasonal trends, assess keyword difficulty, and gather data-driven insights to inform their SEO campaigns. The workflow connects to the Google Ads API to fetch the monthly search volume, historical trends, and competition metrics for each keyword. Users can customize the list of keywords and choose their own database or storage system to store the generated data.

9s$0.0006
SEO, marketing & analytics

Automatically receive SMS alerts for new YouTube videos

The automation template allows users to monitor a specific YouTube channel or keyword, and automatically receive SMS notifications whenever a new video is published. This functionality is particularly useful for SEO and marketing analytics, enabling users to stay up-to-date on their competitors' content and activities. The automation integrates with a video monitoring service and a messaging platform like Twilio or an SMS carrier to deliver the notifications. By automating this process, users can streamline their content monitoring and stay informed without the need for manual checks.

5s$0.0003