Enrich Domain Data with SimilarWeb Traffic Metrics

Table of Contents

Workflow Description
🛠️ Step-by-Step Breakdown (Node View)
STEP 1 – Fetch & Clean Domains
STEP 2 – Fetch & Extract Traffic Data
STEP 3 – Store Metrics
💡 Why is this powerful?

Workflow Description

Here’s how this Agent works:
1️⃣ Fetch & Clean Domains – The workflow triggers whenever a new domain is added to the connected Google Sheet and cleans the domain URL by removing https://, www., and trailing slashes. It also structures the data including the row number.

2️⃣ Fetch & Extract Traffic Data – Sends the cleaned domain to SimilarWeb via RapidAPI, retrieves detailed traffic metrics, and formats the raw API response to highlight essential insights such as global rank, monthly visits, top traffic sources, top countries, and device split.

3️⃣ Store Metrics – Writes the enriched traffic data back to Google Sheets and optionally exports it to Airtable for further tracking or integration.

🛠️ Step-by-Step Breakdown (Node View)

STEP 1 – Fetch & Clean Domains

Node 1: Sheet Trigger: New Domain – Monitors a Google Sheet for new rows (domains) and triggers the workflow when a new domain is added.
Node 2: Clean Domain URL – Removes unnecessary URL components (https://, www., trailing slashes) and prepares structured data including the row number.

STEP 2 – Fetch & Extract Traffic Data

Node 3: Fetch Analysis (SimilarWeb API) – Sends the cleaned domain to SimilarWeb via RapidAPI and retrieves traffic data including global rank, country rank, category rank, visits, bounce rate, and device split.
Node 4: Extract Key Traffic Metrics – Processes the raw SimilarWeb API response to extract key metrics such as total visits, top traffic sources, top countries, and device split percentages.

STEP 3 – Store Metrics

Node 5: Update Sheet with Traffic Data – Updates the original or destination Google Sheet with the formatted traffic metrics.
Node 6: Export to Airtable (Optional) – Optionally sends enriched domain traffic data to an Airtable base for further tracking or integration.

💡 Why is this powerful?

Automatically enriches domains with critical traffic insights without manual effort.
Provides actionable data such as global rank, top traffic sources, and device split for better decision-making.
Seamless integration with Google Sheets and Airtable ensures data is structured, stored, and easily shareable.
Fully automated workflow that scales with your domain list.