Skip to main content

Pull new backlinks into Google Sheets with DataForSEO and Gmail email report

Workflow preview

Workflow preview
100%
Pull new backlinks into Google Sheets with DataForSEO and Gmail email report preview
Open on n8n.io

1. Workflow Overview

This workflow helps you keep track of new backlinks by automatically generating a daily report in Goo...

Best for

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

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.scheduletrigger, n8n-nodes-base.googlesheets, n8n-nodes-base.aggregate, n8n-nodes-base.gmail, n8n-nodes-base.set, n8n-nodes-dataforseo.dataforseobacklinksapi, n8n-nodes-base.if

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
Pull new backlinks into Google Sheets with DataForSEO and Gmail email report
Workflow name
Pull new backlinks into Google Sheets with DataForSEO and Gmail email report

This workflow helps you keep track of new backlinks by automatically generating a daily report in Google Sheets with the DataForSEO API, and delivering it via Gmail.

On each run, the workflow connects to the DataForSEO Backlinks API to retrieve the latest backlink data for your target domain or URL. It then organizes the results into a structured Google Sheets report, complete with key backlink metrics such as referring source URL, referring domain, spam score, domain rating (DR), and dofollow link attributes where present.

Once the report is updated, the workflow automatically sends you an email notification via Gmail with a direct link to the Google Sheet, making it easy to review new links and measure link-building progress day-to-day.

Who’s it for

This workflow is especially useful for SEO teams, link-building specialists, and website owners who want automated daily overview of new backlinks.

What it does

This workflow automatically monitors newly detected backlinks and sends you a daily report via email.

How it works

Triggers automatically on a daily basis.

Fetches backlinks for your target domain or URL using the DataForSEO Backlinks API.

Extracts newly discovered backlinks and their key metrics.

Creates or updates a Google Sheets report with the latest data.

Sends an automated email with a direct link to your report.

Requirements

  • DataForSEO account and API credentials
  • Google Sheets connection in n8n
  • Gmail connection in n8n

Customization

You can easily customize this workflow by changing the number of backlinks analyzed, selecting additional backlink details for your report, saving daily reports in other tools (like Notion or Airtable), or changing how often the workflow runs.

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 - Sticky Note

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

Block 2 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.3

Block 3 - Create spreadsheet

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

Block 4 - Append row in sheet

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

Block 5 - Aggregate

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

Block 6 - Send a message

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.2

Block 7 - Sticky Note3

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

Block 8 - Initialize "items" field

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 9 - Set "items" field

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 10 - Get new backlinks

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

Block 11 - Merge "items" with DFS response

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 12 - Has more pages?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 13 - Filter (has new backlinks)

Type / Role
n8n-nodes-base.filter - filter
Config choices
Version 2.3

Block 14 - Append columns

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

Block 15 - Set final "items" field

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 16 - Split out items

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

Block 17 - Prepare data for Google Sheets

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 18 - Prepage columns for Google Sheets

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 19 - Sticky Note1

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

3. Summary Table

Workflow Pull new backlinks into Google Sheets with DataForSEO and Gmail email report
Complexity advanced
Nodes 19
Categories Market Research
Author DataForSEO
Published 25 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13694/13694.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 Pull new backlinks into Google Sheets with DataForSEO and Gmail email report do?

This workflow helps you keep track of new backlinks by automatically generating a daily report in Goo...

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.