Templates / Find link gap prospects from competitor backlinks with DataForSEO, OpenAI, and Google Sheets

Find link gap prospects from competitor backlinks with DataForSEO, OpenAI, and Google Sheets

Ready for 3.0

by Daniel Shashko ✓ · 34 views · created 2026-09-05 · Market Research, AI Summarization

Ready 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 AI workflow has 19 nodes and runs when someone submits an n8n form (“Link gap”). Along the way it connects OpenAI Chat Model and Google Sheets. It also calls api.dataforseo.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Link gap”).

  1. Read The Form (Code): runs custom JavaScript code
  2. Find Who Links To Them All (HTTP Request): calls api.dataforseo.com (POST)
  3. Find Your Best Pages (HTTP Request): calls api.dataforseo.com (POST)
  4. Read The Prospects (Code): runs custom JavaScript code
  5. Read Your Best Pages (Code): runs custom JavaScript code
  6. Wait For Both (Merge): merges the data from its input branches
  7. Put Both Halves Together (Code): runs custom JavaScript code
  8. Any Worth Chasing? (If): checks a condition and branches into true / false
  9. Check They Are Alive (HTTP Request): calls api.dataforseo.com (POST)
  10. Nothing To Chase (n8n Form): shows the next form page

…plus 7 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelGoogle Sheets

HTTP calls to: api.dataforseo.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 (9)

From the author

Quick overview This workflow collects your domain, competitor domains, and a Google Sheets tracker, then uses DataForSEO to find domains linking to all competitors but not you, estimates their traffic, and uses OpenAI to generate a pitch page and outreach…

Excerpt from Daniel Shashko's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.