Block 1 - On form submission
- Type / Role
- n8n-nodes-base.formTrigger - formTrigger
- Config choices
- Version 2.2
Track website traffic & backlinks with Ahref API and Google Sheets
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
Automated Website Traffic Tracker with Google Sheets Logging Track website traffic and backlinks effortlessly using the [Website Traffic Checker Ahref API](https://rapidapi.com/skdeveloper/api/w...
Best for
- Content Creation automation workflows
- Market Research automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.formtrigger, n8n-nodes-base.set, n8n-nodes-base.httprequest, n8n-nodes-base.if, n8n-nodes-base.emailsend, n8n-nodes-base.code, n8n-nodes-base.googlesheets, n8n-nodes-base.stickynote
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Sk developer .
Original n8n.io source1.1 Workflow description
- Title
- Track website traffic & backlinks with Ahref API and Google Sheets
- Workflow name
- Track website traffic & backlinks with Ahref API and Google Sheets
📊 Automated Website Traffic Tracker with Google Sheets Logging
Track website traffic and backlinks effortlessly using the Website Traffic Checker - Ahref API. This n8n workflow automates data retrieval and logging into Google Sheets, making it perfect for SEO professionals and digital marketers.
🧩 What This Workflow Does (Summary)
Accepts a domain via a simple web form.
Sends the domain to Website Traffic Checker - Ahref API.
If successful:
- Extracts backlink and traffic data.
- Appends the results to two separate Google Sheets.
If failed:
- Sends an email alert with domain and status code.
🔧 Node-by-Node Explanation
| Node | Purpose |
|---|---|
| 🟢 Form Trigger | Starts the workflow when a domain is submitted via form. |
| 🟩 Set Domain Value | Stores the submitted domain into a variable. |
| 🌐 HTTP Request | Calls Website Traffic Checker - Ahref API. |
| ✅ IF Node | Checks if the API responded with statusCode = 200. |
| ❌ Email Node (Fail) | Sends an alert email if API fails. |
| 📦 Code (Backlink Info) | Extracts backlink data from API response. |
| 📄 Google Sheet: Backlink Info | Appends backlink data to a sheet. |
| 📦 Code (Traffic Info) | Extracts traffic data from API response. |
| 📄 Google Sheet: Traffic Data | Appends traffic metrics to another sheet. |
📁 Google Sheet Columns
Backlink Info Sheet
| Column | Description |
|---|---|
website |
Domain submitted |
ascore |
Authority score |
referring domain |
Number of referring domains |
total backlinks |
Total backlinks |
Traffic Data Sheet
| Column | Description |
|---|---|
| accuracy | Accuracy level of the traffic data |
| bounce_rate | Bounce rate percentage |
| desktop_share | Percentage of traffic from desktop devices |
| direct | Direct traffic sources |
| display_ad | Display ad traffic sources |
| display_date | Date when traffic data was captured |
| Traffic from email campaigns | |
| mobile_share | Percentage of traffic from mobile devices |
| pages_per_visit | Average number of pages per visit |
| paid | Paid traffic sources |
| prev_bounce_rate | Bounce rate in the previous period |
| prev_direct | Previous period's direct traffic |
| prev_display_ad | Previous period's display ad traffic |
| prev_mail | Previous period's email traffic |
| prev_pages_per_visit | Previous period's pages per visit |
| prev_referral | Previous period's referral traffic |
| prev_search_organic | Previous organic search traffic |
| prev_search_paid | Previous paid search traffic |
| prev_social_organic | Previous organic social traffic |
| prev_social_paid | Previous paid social traffic |
| prev_time_on_site | Previous time spent on site |
| prev_users | Number of users in the previous period |
| prev_visits | Visits in the previous period |
| rank | Global rank of the website |
| referral | Referral traffic |
| search | Total search traffic |
| search_organic | Organic search traffic |
| search_paid | Paid search traffic |
| social | Total social traffic |
| social_organic | Organic social traffic |
| social_paid | Paid social traffic |
| target | Targeted country or demographic |
| time_on_site | Average time spent on site |
| unknown_channel | Traffic from unknown sources |
| users | Number of unique users |
| visits | Total number of visits |
🔐 How to Configure
🔑 Get API Key
- Go to Website Traffic Checker - Ahref API on RapidAPI.
- Sign in or create a free RapidAPI account.
- Subscribe to the API plan.
- Copy your
x-rapidapi-keyfrom the Endpoints tab.
📝 Add Key in n8n
Go to your HTTP Request node.
Under Headers, set:
x-rapidapi-host=website-traffic-checker-ahref.p.rapidapi.comx-rapidapi-key= your API key
📄 How to Setup Google Sheets in n8n
- Connect a Google account via
Google Sheetscredentials in n8n. - Use the full Google Sheet URL in the
documentIdfield. - Set correct Sheet name or GID (e.g., "Traffic Data").
- Use Auto Map or Custom Map to define columns.
> Make sure your Google Sheet has edit access and headers already created.
🧠 Use Case & Benefits
👤 Ideal For:
- SEO analysts
- Digital marketers
- Agencies managing multiple clients
- Web analytics consultants
✅ Benefits:
- Fully automated data collection.
- No manual copy-paste from tools.
- Real-time insights delivered to Google Sheets.
- Easy monitoring of backlinks and traffic trends.
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Set Domain Value
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 3 - Check Website Traffic API
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 4 - Check if API Call Succeeded
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 5 - Send Failure Email Alert
- Type / Role
- n8n-nodes-base.emailSend - emailSend
- Config choices
- Version 2.1
Block 6 - Extract Backlink Info
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 7 - Log Backlinks to Sheet
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.7
Block 8 - Extract Traffic Info
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 9 - Log Traffic to Sheet
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.7
Block 10 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 11 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 12 - Sticky Note2
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 13 - Sticky Note3
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 14 - Sticky Note4
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 15 - Sticky Note5
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 16 - Sticky Note6
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 17 - Sticky Note7
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 18 - Sticky Note8
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 19 - Sticky Note9
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
3. Summary Table
| Workflow | Track website traffic & backlinks with Ahref API and Google Sheets |
|---|---|
| Complexity | advanced |
| Nodes | 19 |
| Categories | Content Creation, Market Research |
| Author | Sk developer |
| Published | 19 Sept 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/8757/8757.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Track website traffic & backlinks with Ahref API and Google Sheets do?
Automated Website Traffic Tracker with Google Sheets Logging Track website traffic and backlinks effortlessly using the [Website Traffic Checker Ahref API](https://rapidapi.com/skdeveloper/api/w...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Market Research use case.