Evoort Solutions This workflow corresponds to n8n.io template #7685 — we link there as the canonical source.
This workflow follows the Form Trigger → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "c1f80a80-22bd-460a-b519-821eac8d8163",
"name": "On form submission",
"type": "n8n-nodes-base.formTrigger",
"position": [
640,
220
],
"parameters": {
"options": {},
"formTitle": "Website Traffic Checker",
"formFields": {
"values": [
{
"fieldLabel": "website",
"requiredField": true
}
]
},
"formDescription": "Website Traffic Checker"
},
"typeVersion": 2.2
},
{
"id": "21719ba3-293a-46f8-9b5b-b768fae7961f",
"name": "Reformat",
"type": "n8n-nodes-base.code",
"position": [
1160,
220
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.trafficSummary;"
},
"typeVersion": 2
},
{
"id": "0c8e4440-4788-4a57-b412-8eba19b4b99f",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220,
40
],
"parameters": {
"width": 740,
"height": 820,
"content": "**Automated Website Traffic Checker with Google Sheets Integration**\n\n**Description:** \nEasily check website traffic data using the SEMrush API and automatically log insights like visits, bounce rate, users, and session duration into Google Sheets with this streamlined no-code automation using n8n.\n\n---\n\n## \ud83e\udde0 Workflow Summary\n\nThis n8n workflow allows users to:\n\n1. Submit a website URL via a web form.\n2. Retrieve website traffic stats using SEMrush API (via RapidAPI).\n3. Reformat the returned data.\n4. Save traffic data into Google Sheets automatically.\n\n---\n\n## \u2699\ufe0f Node-by-Node (One-Line Explanation)\n\n| \ud83e\udde9 Node Name | \ud83d\udca1 Purpose |\n|--------------------------|------------|\n| **On form submission** | Triggers when a user submits a website via the form. |\n| **website traffic checker** | Sends the website to SEMrush API and fetches traffic data. |\n| **Reformat** | Extracts and returns only the `trafficSummary` part of the API response. |\n| **Append Data In Google Sheets** | Appends the formatted data into a Google Sheets document. |"
},
"typeVersion": 1
},
{
"id": "98be917f-b2b1-4ac2-9f49-fbe10f8ac235",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
580,
40
],
"parameters": {
"height": 340,
"content": " On form submission \nThis node triggers the workflow whenever a user submits the website URL through the form. It collects the input data required for further processing.\n"
},
"typeVersion": 1
},
{
"id": "44763ea2-f711-4a7e-b0ad-3bb41e8e336e",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
40
],
"parameters": {
"height": 340,
"content": "website traffic checker \nSends a POST request to the SEMrush API endpoint with the submitted website to fetch traffic data. It includes necessary headers like the RapidAPI key for authentication.\n"
},
"typeVersion": 1
},
{
"id": "b9cbd421-e2c8-4065-b5f1-a1e295ffb8ae",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
40
],
"parameters": {
"height": 340,
"content": "Reformat \nProcesses the raw API response by extracting the `trafficSummary` object, which contains the relevant website traffic metrics. This simplifies the data for downstream use.\n"
},
"typeVersion": 1
},
{
"id": "4ab092f2-b823-47c2-9d71-19c58385be19",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1360,
40
],
"parameters": {
"height": 340,
"content": "Append Data In Google Sheets \nTakes the formatted traffic data and appends it as a new row in a specified Google Sheets document. This enables automatic logging and tracking of website traffic stats."
},
"typeVersion": 1
},
{
"id": "e8f072af-bb51-418b-ba3a-f4acfbfd2690",
"name": "website traffic checker",
"type": "n8n-nodes-base.httpRequest",
"position": [
880,
220
],
"parameters": {
"url": "https://semrush-website-traffic-checker.p.rapidapi.com/webtraffic.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "semrush-website-traffic-checker.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "e41d0762-84c1-48bf-b690-4617b5b0805a",
"name": "Append Data In Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1400,
220
],
"parameters": {
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "url",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
}
],
"connections": {
"Reformat": {
"main": [
[
{
"node": "Append Data In Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "website traffic checker",
"type": "main",
"index": 0
}
]
]
},
"website traffic checker": {
"main": [
[
{
"node": "Reformat",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Leverage the powerful SEMrush Website Traffic Checker API 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…
Source: https://n8n.io/workflows/7685/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Overview 🌐
Splitout Code. Uses splitOut, httpRequest, googleSheets, stickyNote. Event-driven trigger; 36 nodes.
This n8n workflow is designed for Customer Success Managers (CSM), marketers, sales teams, and data administrators who need to automate the process of uploading and processing CSV data in HubSpot. It
The SEO On Page API is a powerful tool for keyword research, competitor analysis, backlink insights, and overall SEO optimization. With multiple endpoints, you can instantly gather actionable SEO data
Demonstration video