Enrich domains with SimilarWeb traffic analytics in Google Sheets & Airtable
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 6 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Airtable. It also calls similarweb8.p.rapidapi.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- 🧼 Clean Domain URL (Edit Fields (Set)): sets 2 fields: domain, rowNumber
- 🌐 Fetch Analysis (SimilarWeb API) (HTTP Request): calls similarweb8.p.rapidapi.com
- 📊 Extract Key Traffic Metrics (Code): runs custom JavaScript code
- 📤 Update Sheet with Traffic Data (Google Sheets): update
- 📁 Export to Airtable (Optional) (Airtable): create
Services it uses
HTTP calls to: similarweb8.p.rapidapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Airtable
n8n-nodes-base.airtable
From the author
How it works This workflow starts whenever a new domain is added to a Google Sheet. It cleans the domain, fetches traffic insights from SimilarWeb, extracts the most relevant metrics, and updates the sheet with enriched data. Optionally, it can also send this…