Skip to main content

Check bulk domain ranks and write scores to Google Sheets with DataForSEO

Workflow preview

Workflow preview
100%
Check bulk domain ranks and write scores to Google Sheets with DataForSEO preview
Open on n8n.io

1. Workflow Overview

Domain rank gives you a quick read on how authoritative a domain is based on its backlink profile. This...

Best for

  • Market Research automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.aggregate, n8n-nodes-base.googlesheets, n8n-nodes-base.splitout, n8n-nodes-base.stickynote, n8n-nodes-dataforseo.dataforseobacklinksapi

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by DataForSEO.

Original n8n.io source

1.1 Workflow description

Title
Check bulk domain ranks and write scores to Google Sheets with DataForSEO
Workflow name
Check bulk domain ranks and write scores to Google Sheets with DataForSEO

Domain rank gives you a quick read on how authoritative a domain is based on its backlink profile. This workflow lets you pull ranks for an entire list of targets at once, without any manual lookups.

On each manual run, the workflow reads your target domains from a Google Sheet and sends them as a batch request to the DataForSEO Bulk Ranks endpoint, which returns a rank score for up to 1000 domains, subdomains, or pages in a single call. The rank is based on the number of referring domains pointing to each target and is calculated using the same node-ranking principle as Google's PageRank algorithm. Values range from 0 to 1000 by default and reflect real-time data at the time of the request. After the request is complete, the rank scores are mapped back to the corresponding rows in your spreadsheet.

Who's it for

This workflow is a good fit for SEO experts and link-building teams who need to quickly screen or compare domain authority across large lists of targets for prospecting, audits, or reporting.

What it does

This workflow automatically retrieves rank scores for a list of domains specified in a Google Sheet and writes the results back to the spreadsheet, with a rank value for each target domain.

How it works

Triggers manually whenever you want to run a bulk rank check.

Reads the list of target domains from your Google Sheet.

Aggregates all domains into a single batch request.

Sends the request to the DataForSEO Bulk Ranks endpoint and retrieves a rank score for each domain.

Writes the scores back to the corresponding rows in your Google Sheet.

Requirements

  • DataForSEO account and API credentials
  • Google Sheets integration connected to n8n

Customization

You can customize this workflow by selecting the suitable rank scale: 0-100 or 0-1000. Additionally, you can combine rank data with other backlink metrics, such as spam score or referring domains, switch from domain-level to subdomain- or page-level analysis, or schedule the workflow to run automatically at specific intervals.

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 1 - When clicking ‘Execute workflow’

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 2 - Aggregate

Type / Role
n8n-nodes-base.aggregate - aggregate
Config choices
Version 1

Block 3 - Update row in sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 4 - Get targets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 5 - Split out (items)

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 6 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Get bulk ranks

Type / Role
n8n-nodes-dataforseo.dataForSeoBacklinksApi - dataForSeoBacklinksApi
Config choices
Version 1

3. Summary Table

Workflow Check bulk domain ranks and write scores to Google Sheets with DataForSEO
Complexity intermediate
Nodes 9
Categories Market Research
Author DataForSEO
Published 20 Apr 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/15160/15160.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 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. 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 Check bulk domain ranks and write scores to Google Sheets with DataForSEO do?

Domain rank gives you a quick read on how authoritative a domain is based on its backlink profile. This...

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 Market Research use case.